| List: | Commits | « Previous MessageNext Message » | |
| From: | paul | Date: | June 27 2007 4:22pm |
| Subject: | svn commit - mysqldoc@docsrva: r6921 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2 | ||
| View as plain text | |||
Author: paul Date: 2007-06-27 16:21:54 +0200 (Wed, 27 Jun 2007) New Revision: 6921 Log: r22122@frost: paul | 2007-06-27 09:15:08 -0500 Explain a few PROCESSLIST State values. 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:26621 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22118 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:26621 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22122 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-27 13:47:27 UTC (rev 6920) +++ trunk/refman-4.1/sql-syntax.xml 2007-06-27 14:21:54 UTC (rev 6921) Changed blocks: 7, Lines Added: 34, Lines Deleted: 15; 4259 bytes @@ -16409,8 +16409,7 @@ version</literal>, <literal>Checking table</literal>, <literal>Connecting to master</literal>, <literal>Copying to group table</literal>, <literal>Copying to tmp - table</literal>, <literal>Creating delayed - handler</literal>, <literal>Creating index</literal>, + table</literal>, <literal>Creating index</literal>, <literal>Creating sort index</literal>, <literal>Creating table from master dump</literal>, <literal>Creating tmp table</literal>, <literal>Execution of @@ -16460,8 +16459,7 @@ read</literal>, <literal>Writing to net</literal>, <literal>allocating local table</literal>, <literal>cleaning up</literal>, <literal>closing - tables</literal>, <literal>converting HEAP to - MyISAM</literal>, <literal>copy to tmp table</literal>, + tables</literal>, <literal>copy to tmp table</literal>, <literal>creating table</literal>, <literal>deleting from main table</literal>, <literal>deleting from reference tables</literal>, @@ -16474,12 +16472,11 @@ <literal>login</literal>, <literal>preparing</literal>, <literal>purging old relay logs</literal>, <literal>query end</literal>, <literal>removing tmp table</literal>, - <literal>rename</literal>, <literal>rename result - table</literal>, <literal>reschedule</literal>, - <literal>setup</literal>, <literal>starting - slave</literal>, <literal>statistics</literal>, - <literal>storing row into queue</literal>, - <literal>unauthenticated user</literal>, + <literal>rename result table</literal>, + <literal>reschedule</literal>, <literal>setup</literal>, + <literal>starting slave</literal>, + <literal>statistics</literal>, <literal>storing row into + queue</literal>, <literal>unauthenticated user</literal>, <literal>update</literal>, <literal>updating</literal>, <literal>updating main table</literal>, <literal>updating reference tables</literal>, <literal>upgrading @@ -16563,6 +16560,18 @@ <listitem> <para> + <literal>converting HEAP to MyISAM</literal>, + </para> + + <para> + The thread is converting an internal temporary table from + a <literal>MEMORY</literal> table to an on-disk + <literal>MyISAM</literal> table. + </para> + </listitem> + + <listitem> + <para> <literal>Copying to group table</literal> </para> @@ -16599,12 +16608,12 @@ <listitem> <para> - <literal>Creating tmp table</literal> + <literal>Creating delayed handler</literal>, </para> <para> - The thread is creating a temporary table to hold a part of - the result for the query. + The thread is creating a handler for + <literal>DELAYED</literal> inserts. </para> </listitem> @@ -16731,11 +16740,11 @@ <listitem> <para> - <literal>Reading from net</literal> + <literal>purging old relay logs</literal>, </para> <para> - The server is reading a packet from the network. + The thread is removing unneeded relay log files. </para> </listitem> @@ -16755,6 +16764,16 @@ <listitem> <para> + <literal>rename</literal>, + </para> + + <para> + The thread is renaming a table. + </para> + </listitem> + + <listitem> + <para> <literal>Reopen table</literal> </para> Modified: trunk/refman-5.0/sql-syntax.xml =================================================================== --- trunk/refman-5.0/sql-syntax.xml 2007-06-27 13:47:27 UTC (rev 6920) +++ trunk/refman-5.0/sql-syntax.xml 2007-06-27 14:21:54 UTC (rev 6921) Changed blocks: 7, Lines Added: 34, Lines Deleted: 15; 4259 bytes @@ -18748,8 +18748,7 @@ version</literal>, <literal>Checking table</literal>, <literal>Connecting to master</literal>, <literal>Copying to group table</literal>, <literal>Copying to tmp - table</literal>, <literal>Creating delayed - handler</literal>, <literal>Creating index</literal>, + table</literal>, <literal>Creating index</literal>, <literal>Creating sort index</literal>, <literal>Creating table from master dump</literal>, <literal>Creating tmp table</literal>, <literal>Execution of @@ -18799,8 +18798,7 @@ read</literal>, <literal>Writing to net</literal>, <literal>allocating local table</literal>, <literal>cleaning up</literal>, <literal>closing - tables</literal>, <literal>converting HEAP to - MyISAM</literal>, <literal>copy to tmp table</literal>, + tables</literal>, <literal>copy to tmp table</literal>, <literal>creating table</literal>, <literal>deleting from main table</literal>, <literal>deleting from reference tables</literal>, @@ -18813,12 +18811,11 @@ <literal>login</literal>, <literal>preparing</literal>, <literal>purging old relay logs</literal>, <literal>query end</literal>, <literal>removing tmp table</literal>, - <literal>rename</literal>, <literal>rename result - table</literal>, <literal>reschedule</literal>, - <literal>setup</literal>, <literal>starting - slave</literal>, <literal>statistics</literal>, - <literal>storing row into queue</literal>, - <literal>unauthenticated user</literal>, + <literal>rename result table</literal>, + <literal>reschedule</literal>, <literal>setup</literal>, + <literal>starting slave</literal>, + <literal>statistics</literal>, <literal>storing row into + queue</literal>, <literal>unauthenticated user</literal>, <literal>update</literal>, <literal>updating</literal>, <literal>updating main table</literal>, <literal>updating reference tables</literal>, <literal>upgrading @@ -18902,6 +18899,18 @@ <listitem> <para> + <literal>converting HEAP to MyISAM</literal>, + </para> + + <para> + The thread is converting an internal temporary table from + a <literal>MEMORY</literal> table to an on-disk + <literal>MyISAM</literal> table. + </para> + </listitem> + + <listitem> + <para> <literal>Copying to group table</literal> </para> @@ -18938,12 +18947,12 @@ <listitem> <para> - <literal>Creating tmp table</literal> + <literal>Creating delayed handler</literal>, </para> <para> - The thread is creating a temporary table to hold a part of - the result for the query. + The thread is creating a handler for + <literal>DELAYED</literal> inserts. </para> </listitem> @@ -19070,11 +19079,11 @@ <listitem> <para> - <literal>Reading from net</literal> + <literal>purging old relay logs</literal>, </para> <para> - The server is reading a packet from the network. + The thread is removing unneeded relay log files. </para> </listitem> @@ -19094,6 +19103,16 @@ <listitem> <para> + <literal>rename</literal>, + </para> + + <para> + The thread is renaming a table. + </para> + </listitem> + + <listitem> + <para> <literal>Reopen table</literal> </para> Modified: trunk/refman-5.1/sql-syntax.xml =================================================================== --- trunk/refman-5.1/sql-syntax.xml 2007-06-27 13:47:27 UTC (rev 6920) +++ trunk/refman-5.1/sql-syntax.xml 2007-06-27 14:21:54 UTC (rev 6921) Changed blocks: 7, Lines Added: 34, Lines Deleted: 15; 4259 bytes @@ -21066,8 +21066,7 @@ version</literal>, <literal>Checking table</literal>, <literal>Connecting to master</literal>, <literal>Copying to group table</literal>, <literal>Copying to tmp - table</literal>, <literal>Creating delayed - handler</literal>, <literal>Creating index</literal>, + table</literal>, <literal>Creating index</literal>, <literal>Creating sort index</literal>, <literal>Creating table from master dump</literal>, <literal>Creating tmp table</literal>, <literal>Execution of @@ -21117,8 +21116,7 @@ read</literal>, <literal>Writing to net</literal>, <literal>allocating local table</literal>, <literal>cleaning up</literal>, <literal>closing - tables</literal>, <literal>converting HEAP to - MyISAM</literal>, <literal>copy to tmp table</literal>, + tables</literal>, <literal>copy to tmp table</literal>, <literal>creating table</literal>, <literal>deleting from main table</literal>, <literal>deleting from reference tables</literal>, @@ -21131,12 +21129,11 @@ <literal>login</literal>, <literal>preparing</literal>, <literal>purging old relay logs</literal>, <literal>query end</literal>, <literal>removing tmp table</literal>, - <literal>rename</literal>, <literal>rename result - table</literal>, <literal>reschedule</literal>, - <literal>setup</literal>, <literal>starting - slave</literal>, <literal>statistics</literal>, - <literal>storing row into queue</literal>, - <literal>unauthenticated user</literal>, + <literal>rename result table</literal>, + <literal>reschedule</literal>, <literal>setup</literal>, + <literal>starting slave</literal>, + <literal>statistics</literal>, <literal>storing row into + queue</literal>, <literal>unauthenticated user</literal>, <literal>update</literal>, <literal>updating</literal>, <literal>updating main table</literal>, <literal>updating reference tables</literal>, <literal>upgrading @@ -21220,6 +21217,18 @@ <listitem> <para> + <literal>converting HEAP to MyISAM</literal>, + </para> + + <para> + The thread is converting an internal temporary table from + a <literal>MEMORY</literal> table to an on-disk + <literal>MyISAM</literal> table. + </para> + </listitem> + + <listitem> + <para> <literal>Copying to group table</literal> </para> @@ -21256,12 +21265,12 @@ <listitem> <para> - <literal>Creating tmp table</literal> + <literal>Creating delayed handler</literal>, </para> <para> - The thread is creating a temporary table to hold a part of - the result for the query. + The thread is creating a handler for + <literal>DELAYED</literal> inserts. </para> </listitem> @@ -21388,11 +21397,11 @@ <listitem> <para> - <literal>Reading from net</literal> + <literal>purging old relay logs</literal>, </para> <para> - The server is reading a packet from the network. + The thread is removing unneeded relay log files. </para> </listitem> @@ -21412,6 +21421,16 @@ <listitem> <para> + <literal>rename</literal>, + </para> + + <para> + The thread is renaming a table. + </para> + </listitem> + + <listitem> + <para> <literal>Reopen table</literal> </para> Modified: trunk/refman-5.2/sql-syntax.xml =================================================================== --- trunk/refman-5.2/sql-syntax.xml 2007-06-27 13:47:27 UTC (rev 6920) +++ trunk/refman-5.2/sql-syntax.xml 2007-06-27 14:21:54 UTC (rev 6921) Changed blocks: 7, Lines Added: 34, Lines Deleted: 15; 4259 bytes @@ -21066,8 +21066,7 @@ version</literal>, <literal>Checking table</literal>, <literal>Connecting to master</literal>, <literal>Copying to group table</literal>, <literal>Copying to tmp - table</literal>, <literal>Creating delayed - handler</literal>, <literal>Creating index</literal>, + table</literal>, <literal>Creating index</literal>, <literal>Creating sort index</literal>, <literal>Creating table from master dump</literal>, <literal>Creating tmp table</literal>, <literal>Execution of @@ -21117,8 +21116,7 @@ read</literal>, <literal>Writing to net</literal>, <literal>allocating local table</literal>, <literal>cleaning up</literal>, <literal>closing - tables</literal>, <literal>converting HEAP to - MyISAM</literal>, <literal>copy to tmp table</literal>, + tables</literal>, <literal>copy to tmp table</literal>, <literal>creating table</literal>, <literal>deleting from main table</literal>, <literal>deleting from reference tables</literal>, @@ -21131,12 +21129,11 @@ <literal>login</literal>, <literal>preparing</literal>, <literal>purging old relay logs</literal>, <literal>query end</literal>, <literal>removing tmp table</literal>, - <literal>rename</literal>, <literal>rename result - table</literal>, <literal>reschedule</literal>, - <literal>setup</literal>, <literal>starting - slave</literal>, <literal>statistics</literal>, - <literal>storing row into queue</literal>, - <literal>unauthenticated user</literal>, + <literal>rename result table</literal>, + <literal>reschedule</literal>, <literal>setup</literal>, + <literal>starting slave</literal>, + <literal>statistics</literal>, <literal>storing row into + queue</literal>, <literal>unauthenticated user</literal>, <literal>update</literal>, <literal>updating</literal>, <literal>updating main table</literal>, <literal>updating reference tables</literal>, <literal>upgrading @@ -21220,6 +21217,18 @@ <listitem> <para> + <literal>converting HEAP to MyISAM</literal>, + </para> + + <para> + The thread is converting an internal temporary table from + a <literal>MEMORY</literal> table to an on-disk + <literal>MyISAM</literal> table. + </para> + </listitem> + + <listitem> + <para> <literal>Copying to group table</literal> </para> @@ -21256,12 +21265,12 @@ <listitem> <para> - <literal>Creating tmp table</literal> + <literal>Creating delayed handler</literal>, </para> <para> - The thread is creating a temporary table to hold a part of - the result for the query. + The thread is creating a handler for + <literal>DELAYED</literal> inserts. </para> </listitem> @@ -21388,11 +21397,11 @@ <listitem> <para> - <literal>Reading from net</literal> + <literal>purging old relay logs</literal>, </para> <para> - The server is reading a packet from the network. + The thread is removing unneeded relay log files. </para> </listitem> @@ -21412,6 +21421,16 @@ <listitem> <para> + <literal>rename</literal>, + </para> + + <para> + The thread is renaming a table. + </para> + </listitem> + + <listitem> + <para> <literal>Reopen table</literal> </para>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r6921 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2 | paul | 27 Jun |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.482 sec. using MySQL 5.1.14-beta-log