Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting
Mailing Lists: lists.mysql.com > commits > 07 > 060662.html (Request Expert lists.mysql.com Support)

svn commit - mysqldoc@docsrva: r6968 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2

From: <paul(at)mysql.com>
Date: Fri Jun 29 2007 - 19:45:41 EDT


Author: paul
Date: 2007-06-30 01:45:36 +0200 (Sat, 30 Jun 2007) New Revision: 6968

Log:
 r22286@frost: paul | 2007-06-29 13:03:16 -0500  SHOW PROCESSLIST:

  • "unauthenticated user" is a User value, not a State
  • "Connect Out" is a Command value, not a State
  • "Sleeping" is a Command value, not a State

Modified: 

   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml
   trunk/refman-5.2/sql-syntax.xml

Property changes on: trunk


Name: svk:merge
  • 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27013 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22284 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18307 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27013 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22286 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18307

Modified: trunk/refman-4.1/sql-syntax.xml

  • trunk/refman-4.1/sql-syntax.xml 2007-06-29 19:19:10 UTC (rev 6967) +++ trunk/refman-4.1/sql-syntax.xml 2007-06-29 23:45:36 UTC (rev 6968) Changed blocks: 3, Lines Added: 12, Lines Deleted: 3; 1698 bytes

@@ -16262,7 +16262,8 @@

 db: NULL
 Command: Connect
 Time: 1004
-State: Has read all relay log; waiting for the slave I/O thread to update it +State: Has read all relay log; waiting for the slave + I/O thread to update it
 Info: NULL

  • 3. row *************************** Id: 3112

@@ -16320,7 +16321,12 @@

               system user, it refers to a non-client
               thread spawned by the server to handle tasks internally.
               This could be the I/O or SQL thread used on replication
-              slaves or a delayed-row handler. For system
+              slaves or a delayed-row handler.
+              unauthenticated user refers to a
+              thread that has become associated with a
+              client connection but for which authentication of the
+              client user has not yet been done.
+For system
               user, there is no host specified in the
               Host column.

@@ -16636,7 +16642,10 @@
  

             
               The thread is creating a temporary table in memory or on
-              disk.
+              disk. If the table is created in memory but later is
+              converted to an on-disk table, the state during that
+              operation will be Copying to tmp table on
+              disk.
Do you need help?X

Modified: trunk/refman-5.0/sql-syntax.xml

  • trunk/refman-5.0/sql-syntax.xml 2007-06-29 19:19:10 UTC (rev 6967) +++ trunk/refman-5.0/sql-syntax.xml 2007-06-29 23:45:36 UTC (rev 6968) Changed blocks: 3, Lines Added: 12, Lines Deleted: 3; 1698 bytes

@@ -18602,7 +18602,8 @@

 db: NULL
 Command: Connect
 Time: 1004
-State: Has read all relay log; waiting for the slave I/O thread to update it +State: Has read all relay log; waiting for the slave + I/O thread to update it
 Info: NULL

  • 3. row *************************** Id: 3112

@@ -18660,7 +18661,12 @@

               system user, it refers to a non-client
               thread spawned by the server to handle tasks internally.
               This could be the I/O or SQL thread used on replication
-              slaves or a delayed-row handler. For system
+              slaves or a delayed-row handler.
+              unauthenticated user refers to a
+              thread that has become associated with a
+              client connection but for which authentication of the

Do you need more help?X

+              client user has not yet been done.
+For system
               user, there is no host specified in the
               Host column.

@@ -18982,7 +18988,10 @@
  

             
               The thread is creating a temporary table in memory or on
-              disk.
+              disk. If the table is created in memory but later is
+              converted to an on-disk table, the state during that
+              operation will be Copying to tmp table on
+              disk.

Modified: trunk/refman-5.1/sql-syntax.xml

  • trunk/refman-5.1/sql-syntax.xml 2007-06-29 19:19:10 UTC (rev 6967) +++ trunk/refman-5.1/sql-syntax.xml 2007-06-29 23:45:36 UTC (rev 6968) Changed blocks: 3, Lines Added: 9, Lines Deleted: 2; 1588 bytes

@@ -20918,7 +20918,7 @@

 db: NULL
 Command: Connect
 Time: 1004
-State: Has read all relay log; waiting for the slave &raquo; +State: Has read all relay log; waiting for the slave

        I/O thread to update it
 Info: NULL

  • 3. row ***************************

@@ -20978,6 +20978,10 @@

               thread spawned by the server to handle tasks internally.
               This could be the I/O or SQL thread used on replication
               slaves or a delayed-row handler.
+              unauthenticated user refers to a
+              thread that has become associated with a
+              client connection but for which authentication of the
+              client user has not yet been done.
               event_scheduler refers to the thread
               that monitors scheduled events. For system
               user or event_scheduler,
Can we help you?X

@@ -21295,7 +21299,10 @@
  

             
               The thread is creating a temporary table in memory or on
-              disk.
+              disk. If the table is created in memory but later is
+              converted to an on-disk table, the state during that
+              operation will be Copying to tmp table on
+              disk.

Modified: trunk/refman-5.2/sql-syntax.xml

  • trunk/refman-5.2/sql-syntax.xml 2007-06-29 19:19:10 UTC (rev 6967) +++ trunk/refman-5.2/sql-syntax.xml 2007-06-29 23:45:36 UTC (rev 6968) Changed blocks: 7, Lines Added: 9, Lines Deleted: 36; 3322 bytes

@@ -20918,7 +20918,7 @@

 db: NULL
 Command: Connect
 Time: 1004
-State: Has read all relay log; waiting for the slave &raquo; +State: Has read all relay log; waiting for the slave

        I/O thread to update it
 Info: NULL

  • 3. row ***************************

@@ -20978,6 +20978,10 @@

               thread spawned by the server to handle tasks internally.
               This could be the I/O or SQL thread used on replication
               slaves or a delayed-row handler.

Can't find what you're looking for?X

+              unauthenticated user refers to a
+              thread that has become associated with a
+              client connection but for which authentication of the
+              client user has not yet been done.
               event_scheduler refers to the thread
               that monitors scheduled events. For system
               user or event_scheduler,

@@ -21133,7 +21137,6 @@

               storing row into queue, System
               lock, Table lock,
               Thread initialized,
-              unauthenticated user,
               update, Updating,
               updating main table, updating
               reference tables, upgrading

@@ -21221,16 +21224,6 @@
  

           
             
-              Connect Out
-            
-
-            
-              A replication slave is connecting to its master.
-            
-          
-
-          
-            
               converting HEAP to MyISAM

@@ -21295,7 +21288,10 @@
  

             
               The thread is creating a temporary table in memory or on
-              disk.
+              disk. If the table is created in memory but later is
+              converted to an on-disk table, the state during that
+              operation will be Copying to tmp table on
+              disk.

@@ -21492,17 +21488,6 @@
  

           
             
-              Sleeping

Confused? Frustrated?X

-            
-
-            
-              The thread is waiting for the client to send a new
-              statement to it.
-            
-          
-
-          
-            
               Sorting for group
Don't know where to look next?X

@@ -21571,18 +21556,6 @@
  

           
             
-              unauthenticated user
-            
-
-            
-              The state of a thread that has become associated with a
-              client connection but for which authentication of the
-              client user has not yet been done.
-            
-          
-
-          
-            
               Updating
             
 

-- 
MySQL Code Commits Mailing List
For list archives: 
http://lists.mysql.com/commits
To unsubscribe:    
http://lists.mysql.com/commits?unsub=lists@pantek.com
Received on Fri Jun 29 19:45:55 2007

This archive was generated by hypermail 2.1.8 : Fri Jun 29 2007 - 19:50:03 EDT

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library