|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
svn commit - mysqldoc@docsrva: r6976 - 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:51:50 EDT
Name: svk:merge
+<!-- replication-related states that we need definitions for...
+<!-- replication-related states that we need definitions for...
+<!-- replication-related states that we need definitions for...
Date: Fri Jun 29 2007 - 19:51:50 EDT
Author: paul
Date: 2007-06-30 01:51:48 +0200 (Sat, 30 Jun 2007)
New Revision: 6976
Log:
r22299@frost: paul | 2007-06-29 18:16:14 -0500
Splice all the yet-undefined thread states into the "general" state list.
To all: If you have a definition to contribute for any of these SHOW PROCESSLIST states, please submit it and I'll add it to the manual. Thanks.
Changing master
Creating table from master dump
Killing slave
Opening master dump table
Processing request
Reading master dump table data
Rebuilding the index on master dump table
starting slave
Thread initialized
Waiting for master update
Waiting for the next event in relay log
After create
allocating local table
Analyzing
cleaning up
copy to tmp table
Creating index
Creating sort index
creating table
discard_or_import_tablespace
end
Execution of init_command
freeing items
got handler lock
got old table
info
init
insert
logging slow query
login
Making temp file
Opening table
preparing
query end
removing tmp table
rename result table
Repair done
reschedule
Rolling back
Saving state
setup
Sorting index
Sorting result
storing row into queue
update
waiting for delay_list
waiting for handler lock
waiting for handler open
Waiting for INSERT
Waiting for table
Waiting on cond
Modified:
trunk/refman-4.1/optimization.xml trunk/refman-5.0/optimization.xml trunk/refman-5.1/optimization.xml trunk/refman-5.2/optimization.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:22298 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:22299 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/optimization.xml
- trunk/refman-4.1/optimization.xml 2007-06-29 23:51:30 UTC (rev 6975) +++ trunk/refman-4.1/optimization.xml 2007-06-29 23:51:48 UTC (rev 6976) Changed blocks: 20, Lines Added: 247, Lines Deleted: 86; 14595 bytes
@@ -9433,95 +9433,44 @@
these are useful only for finding bugs in the server.
-
- After create , allocating local
- table , Analyzing ,
- Changing master , Checking master
- version , Checking table ,
- cleaning up , closing
- tables , Connecting to master ,
- converting HEAP to MyISAM , copy to
- tmp table , Copying to group
- table , Copying to tmp table ,
- Copying to tmp table on disk ,
- Creating delayed handler , Creating
- index , Creating sort index ,
- Creating table from master dump ,
- creating table , Creating tmp
- table , deleting from main table ,
- deleting from reference tables ,
- discard_or_import_tablespace ,
- end , Execution of
- init_command , Finished reading one binlog;
- switching to next binlog , Flushing
- tables , freeing items ,
- FULLTEXT initialization , got
- handler lock , got old table ,
- Has read all relay log; waiting for the slave I/O
- thread to update it , Has sent all binlog to
- slave; waiting for binlog to be updated ,
- info , init ,
- insert , Killed ,
- Killing slave , Locked ,
- logging slow query ,
- login , Making temp file
- , Opening master dump table ,
- Opening table , Opening
- tables , preparing ,
- Processing request , Purging old
- relay logs , query end ,
- Queueing master event to the relay log ,
- Reading event from the relay log ,
- Reading from net , Reading master
- dump table data , Rebuilding the index on
- master dump table , Reconnecting after a
- failed binlog dump request , Reconnecting
- after a failed master event read ,
- Registering slave on master ,
- Removing duplicates , removing tmp
- table , rename , rename
- result table , Reopen tables ,
- Repair by sorting , Repair
- done , Repair with keycache ,
- Requesting binlog dump ,
- reschedule , Rolling
- back , Saving state ,
- Searching rows for update , Sending
- binlog event to slave , Sending
- data , setup , Sorting for
- group , Sorting for order ,
- Sorting index , Sorting
- result , starting slave ,
- statistics , storing row into
- queue , System lock ,
- Table lock , Thread
- initialized , update ,
- Updating , updating main
- table , updating reference tables ,
- upgrading lock , User
- lock , waiting for delay_list ,
- Waiting for event from ndbcluster ,
- waiting for handler insert ,
- waiting for handler lock , waiting
- for handler open , Waiting for
- INSERT , Waiting for master to send
- event , Waiting for master update ,
- Waiting for slave mutex on exit ,
- Waiting for table , Waiting for
- tables , Waiting for the next event in relay
- log , Waiting for the slave SQL thread to
- free enough relay log space , Waiting on
- cond , Waiting to finalize
- termination , Waiting to reconnect after a
- failed binlog dump request , Waiting to
- reconnect after a failed master event read ,
- Writing to net
-
+<!-- replication-related states that we need definitions for...
+Changing master +Creating table from master dump +Killing slave +Opening master dump table +Processing request +Reading master dump table data +Rebuilding the index on master dump table +starting slave +Thread initialized +Waiting for master update +Waiting for the next event in relay log + +--> ++ + + +After create ++ + ++ +allocating local table ++ + ++ +Analyzing ++ Checking table
@@ -9532,6 +9481,12 @@
+ cleaning up
+
+
+
+
+
closing tables
@@ -9557,6 +9512,12 @@
+ copy to tmp table
+
+
+
+
+
Copying to group table
@@ -9604,6 +9565,24 @@
+ Creating index
+
+
+
+
+
+ Creating sort index
+
+
+
+
+
+ creating table
+
+
+
+
+
Creating tmp table
@@ -9643,6 +9622,30 @@
+ discard_or_import_tablespace
+
+
+
+
+
+ end
+
+
+
+
+
+ Execution of init_command
+
+
+
+
+
+ freeing items
+
+
+
+
+
Flushing tables
@@ -9665,6 +9668,36 @@
+ got handler lock
+
+
+
+
+
+ got old table
+
+
+
+
+
+ info
+
+
+
+
+
+ init
+
+
+
+
+
+ insert
+
+
+
+
+
Killed
@@ -9691,10 +9724,29 @@
- Opening tables
+ logging slow query
+
+
+ login
+
+
+
+
+
+ Making temp file
+
+
+
+
+
+ Opening tables , Opening
+ table
+
+
+
The thread is trying to open a table. This is should be
very fast procedure, unless something prevents opening.
For example, an ALTER TABLE or a
@@ -9705,6 +9757,12 @@
+ preparing
+
+
+
+
+
Purging old relay logs
@@ -9715,6 +9773,12 @@
+ query end
+
+
+
+
+
Reading from net
@@ -9739,6 +9803,12 @@
+ removing tmp table
+
+
+
+
+
rename
@@ -9749,6 +9819,12 @@
+ rename result table
+
+
+
+
+
Reopen tables
@@ -9772,6 +9848,12 @@
+ Repair done
+
+
+
+
+
Repair with keycache
@@ -9784,6 +9866,24 @@
+ reschedule
+
+
+
+
+
+ Rolling back
+
+
+
+
+
+ Saving state
+
+
+
+
+
Searching rows for update
@@ -9809,6 +9909,12 @@
+ setup
+
+
+
+
+
Sorting for group
@@ -9831,6 +9937,18 @@
+ Sorting index
+
+
+
+
+
+ Sorting result
+
+
+
+
+
statistics
@@ -9842,6 +9960,12 @@
+ storing row into queue
+
+
+
+
+
external locking
@@ -9877,6 +10001,12 @@
+ update
+
+
+
+
+
Updating
@@ -9936,6 +10066,12 @@
+ waiting for delay_list
+
+
+
+
+
Waiting for event from ndbcluster
@@ -9958,10 +10094,29 @@
- Waiting for tables
+ waiting for handler lock
+
+
+ waiting for handler open
+
+
+
+
+
+ Waiting for INSERT
+
+
+
+
+
+ Waiting for tables , Waiting
+ for table
+
+
+
The thread got a notification that the underlying
structure for a table has changed and it needs to reopen
the table to get the new structure. However, to reopen the
@@ -9983,6 +10138,12 @@
+ Waiting on cond
+
+
+
+
+
Writing to net
Modified: trunk/refman-5.0/optimization.xml
- trunk/refman-5.0/optimization.xml 2007-06-29 23:51:30 UTC (rev 6975) +++ trunk/refman-5.0/optimization.xml 2007-06-29 23:51:48 UTC (rev 6976) Changed blocks: 20, Lines Added: 247, Lines Deleted: 86; 14631 bytes
@@ -11728,95 +11728,44 @@
these are useful only for finding bugs in the server.
-
- After create , allocating local
- table , Analyzing ,
- Changing master , Checking master
- version , Checking table ,
- cleaning up , closing
- tables , Connecting to master ,
- converting HEAP to MyISAM , copy to
- tmp table , Copying to group
- table , Copying to tmp table ,
- Copying to tmp table on disk ,
- Creating delayed handler , Creating
- index , Creating sort index ,
- Creating table from master dump ,
- creating table , Creating tmp
- table , deleting from main table ,
- deleting from reference tables ,
- discard_or_import_tablespace ,
- end , Execution of
- init_command , Finished reading one binlog;
- switching to next binlog , Flushing
- tables , freeing items ,
- FULLTEXT initialization , got
- handler lock , got old table ,
- Has read all relay log; waiting for the slave I/O
- thread to update it , Has sent all binlog to
- slave; waiting for binlog to be updated ,
- info , init ,
- insert , Killed ,
- Killing slave , Locked ,
- logging slow query ,
- login , Making temp file
- , Opening master dump table ,
- Opening table , Opening
- tables , preparing ,
- Processing request , Purging old
- relay logs , query end ,
- Queueing master event to the relay log ,
- Reading event from the relay log ,
- Reading from net , Reading master
- dump table data , Rebuilding the index on
- master dump table , Reconnecting after a
- failed binlog dump request , Reconnecting
- after a failed master event read ,
- Registering slave on master ,
- Removing duplicates , removing tmp
- table , rename , rename
- result table , Reopen tables ,
- Repair by sorting , Repair
- done , Repair with keycache ,
- Requesting binlog dump ,
- reschedule , Rolling
- back , Saving state ,
- Searching rows for update , Sending
- binlog event to slave , Sending
- data , setup , Sorting for
- group , Sorting for order ,
- Sorting index , Sorting
- result , starting slave ,
- statistics , storing row into
- queue , System lock ,
- Table lock , Thread
- initialized , update ,
- Updating , updating main
- table , updating reference tables ,
- upgrading lock , User
- lock , waiting for delay_list ,
- Waiting for event from ndbcluster ,
- waiting for handler insert ,
- waiting for handler lock , waiting
- for handler open , Waiting for
- INSERT , Waiting for master to send
- event , Waiting for master update ,
- Waiting for slave mutex on exit ,
- Waiting for table , Waiting for
- tables , Waiting for the next event in relay
- log , Waiting for the slave SQL thread to
- free enough relay log space , Waiting on
- cond , Waiting to finalize
- termination , Waiting to reconnect after a
- failed binlog dump request , Waiting to
- reconnect after a failed master event read ,
- Writing to net
-
+<!-- replication-related states that we need definitions for...
+Changing master +Creating table from master dump +Killing slave +Opening master dump table +Processing request +Reading master dump table data +Rebuilding the index on master dump table +starting slave +Thread initialized +Waiting for master update +Waiting for the next event in relay log + +--> ++ + + +After create ++ + ++ +allocating local table ++ + ++ +Analyzing ++ Checking table
@@ -11827,6 +11776,12 @@
+ cleaning up
+
+
+
+
+
closing tables
@@ -11852,6 +11807,12 @@
+ copy to tmp table
+
+
+
+
+
Copying to group table
@@ -11899,6 +11860,24 @@
+ Creating index
+
+
+
+
+
+ Creating sort index
+
+
+
+
+
+ creating table
+
+
+
+
+
Creating tmp table
@@ -11938,6 +11917,30 @@
+ discard_or_import_tablespace
+
+
+
+
+
+ end
+
+
+
+
+
+ Execution of init_command
+
+
+
+
+
+ freeing items
+
+
+
+
+
Flushing tables
@@ -11960,6 +11963,36 @@
+ got handler lock
+
+
+
+
+
+ got old table
+
+
+
+
+
+ info
+
+
+
+
+
+ init
+
+
+
+
+
+ insert
+
+
+
+
+
Killed
@@ -11986,10 +12019,29 @@
- Opening tables
+ logging slow query
+
+
+ login
+
+
+
+
+
+ Making temp file
+
+
+
+
+
+ Opening tables , Opening
+ table
+
+
+
The thread is trying to open a table. This is should be
very fast procedure, unless something prevents opening.
For example, an ALTER TABLE or a
@@ -12000,6 +12052,12 @@
+ preparing
+
+
+
+
+
Purging old relay logs
@@ -12010,6 +12068,12 @@
+ query end
+
+
+
+
+
Reading from net
@@ -12034,6 +12098,12 @@
+ removing tmp table
+
+
+
+
+
rename
@@ -12044,6 +12114,12 @@
+ rename result table
+
+
+
+
+
Reopen tables
@@ -12067,6 +12143,12 @@
+ Repair done
+
+
+
+
+
Repair with keycache
@@ -12079,6 +12161,24 @@
+ reschedule
+
+
+
+
+
+ Rolling back
+
+
+
+
+
+ Saving state
+
+
+
+
+
Searching rows for update
@@ -12104,6 +12204,12 @@
+ setup
+
+
+
+
+
Sorting for group
@@ -12126,6 +12232,18 @@
+ Sorting index
+
+
+
+
+
+ Sorting result
+
+
+
+
+
statistics
@@ -12137,6 +12255,12 @@
+ storing row into queue
+
+
+
+
+
external locking
@@ -12174,6 +12298,12 @@
+ update
+
+
+
+
+
Updating
@@ -12235,6 +12365,12 @@
+ waiting for delay_list
+
+
+
+
+
Waiting for event from ndbcluster
@@ -12257,10 +12393,29 @@
- Waiting for tables
+ waiting for handler lock
+
+
+ waiting for handler open
+
+
+
+
+
+ Waiting for INSERT
+
+
+
+
+
+ Waiting for tables , Waiting
+ for table
+
+
+
The thread got a notification that the underlying
structure for a table has changed and it needs to reopen
the table to get the new structure. However, to reopen the
@@ -12282,6 +12437,12 @@
+ Waiting on cond
+
+
+
+
+
Writing to net
Modified: trunk/refman-5.1/optimization.xml
- trunk/refman-5.1/optimization.xml 2007-06-29 23:51:30 UTC (rev 6975) +++ trunk/refman-5.1/optimization.xml 2007-06-29 23:51:48 UTC (rev 6976) Changed blocks: 20, Lines Added: 247, Lines Deleted: 86; 14631 bytes
@@ -11933,95 +11933,44 @@
these are useful only for finding bugs in the server.
-
- After create , allocating local
- table , Analyzing ,
- Changing master , Checking master
- version , Checking table ,
- cleaning up , closing
- tables , Connecting to master ,
- converting HEAP to MyISAM , copy to
- tmp table , Copying to group
- table , Copying to tmp table ,
- Copying to tmp table on disk ,
- Creating delayed handler , Creating
- index , Creating sort index ,
- Creating table from master dump ,
- creating table , Creating tmp
- table , deleting from main table ,
- deleting from reference tables ,
- discard_or_import_tablespace ,
- end , Execution of
- init_command , Finished reading one binlog;
- switching to next binlog , Flushing
- tables , freeing items ,
- FULLTEXT initialization , got
- handler lock , got old table ,
- Has read all relay log; waiting for the slave I/O
- thread to update it , Has sent all binlog to
- slave; waiting for binlog to be updated ,
- info , init ,
- insert , Killed ,
- Killing slave , Locked ,
- logging slow query ,
- login , Making temp file
- , Opening master dump table ,
- Opening table , Opening
- tables , preparing ,
- Processing request , Purging old
- relay logs , query end ,
- Queueing master event to the relay log ,
- Reading event from the relay log ,
- Reading from net , Reading master
- dump table data , Rebuilding the index on
- master dump table , Reconnecting after a
- failed binlog dump request , Reconnecting
- after a failed master event read ,
- Registering slave on master ,
- Removing duplicates , removing tmp
- table , rename , rename
- result table , Reopen tables ,
- Repair by sorting , Repair
- done , Repair with keycache ,
- Requesting binlog dump ,
- reschedule , Rolling
- back , Saving state ,
- Searching rows for update , Sending
- binlog event to slave , Sending
- data , setup , Sorting for
- group , Sorting for order ,
- Sorting index , Sorting
- result , starting slave ,
- statistics , storing row into
- queue , System lock ,
- Table lock , Thread
- initialized , update ,
- Updating , updating main
- table , updating reference tables ,
- upgrading lock , User
- lock , waiting for delay_list ,
- Waiting for event from ndbcluster ,
- waiting for handler insert ,
- waiting for handler lock , waiting
- for handler open , Waiting for
- INSERT , Waiting for master to send
- event , Waiting for master update ,
- Waiting for slave mutex on exit ,
- Waiting for table , Waiting for
- tables , Waiting for the next event in relay
- log , Waiting for the slave SQL thread to
- free enough relay log space , Waiting on
- cond , Waiting to finalize
- termination , Waiting to reconnect after a
- failed binlog dump request , Waiting to
- reconnect after a failed master event read ,
- Writing to net
-
+<!-- replication-related states that we need definitions for...
+Changing master +Creating table from master dump +Killing slave +Opening master dump table +Processing request +Reading master dump table data +Rebuilding the index on master dump table +starting slave +Thread initialized +Waiting for master update +Waiting for the next event in relay log + +--> ++ + + +After create ++ + ++ +allocating local table ++ + ++ +Analyzing ++ Checking table
@@ -12032,6 +11981,12 @@
+ cleaning up
+
+
+
+
+
closing tables
@@ -12057,6 +12012,12 @@
+ copy to tmp table
+
+
+
+
+
Copying to group table
@@ -12104,6 +12065,24 @@
+ Creating index
+
+
+
+
+
+ Creating sort index
+
+
+
+
+
+ creating table
+
+
+
+
+
Creating tmp table
@@ -12143,6 +12122,30 @@
+ discard_or_import_tablespace
+
+
+
+
+
+ end
+
+
+
+
+
+ Execution of init_command
+
+
+
+
+
+ freeing items
+
+
+
+
+
Flushing tables
@@ -12165,6 +12168,36 @@
+ got handler lock
+
+
+
+
+
+ got old table
+
+
+
+
+
+ info
+
+
+
+
+
+ init
+
+
+
+
+
+ insert
+
+
+
+
+
Killed
@@ -12191,10 +12224,29 @@
- Opening tables
+ logging slow query
+
+
+ login
+
+
+
+
+
+ Making temp file
+
+
+
+
+
+ Opening tables , Opening
+ table
+
+
+
The thread is trying to open a table. This is should be
very fast procedure, unless something prevents opening.
For example, an ALTER TABLE or a
@@ -12205,6 +12257,12 @@
+ preparing
+
+
+
+
+
Purging old relay logs
@@ -12215,6 +12273,12 @@
+ query end
+
+
+
+
+
Reading from net
@@ -12239,6 +12303,12 @@
+ removing tmp table
+
+
+
+
+
rename
@@ -12249,6 +12319,12 @@
+ rename result table
+
+
+
+
+
Reopen tables
@@ -12272,6 +12348,12 @@
+ Repair done
+
+
+
+
+
Repair with keycache
@@ -12284,6 +12366,24 @@
+ reschedule
+
+
+
+
+
+ Rolling back
+
+
+
+
+
+ Saving state
+
+
+
+
+
Searching rows for update