![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196758.webp)
General Thread States
738
The thread is beginning an
ALTER TABLE
operation.
•
Sorting for group
The thread is doing a sort to satisfy a
GROUP BY
.
•
Sorting for order
The thread is doing a sort to satisfy a
ORDER BY
.
•
Sorting index
The thread is sorting index pages for more efficient access during a
MyISAM
table optimization
operation.
•
Sorting result
For a
SELECT
statement, this is similar to
Creating sort index
, but for nontemporary tables.
•
statistics
The server is calculating statistics to develop a query execution plan. If a thread is in this state for a
long time, the server is probably disk-bound performing other work.
•
System lock
The thread is going to request or is waiting for an internal or external system lock for the table. If
this state is being caused by requests for external locks and you are not using multiple
mysqld
servers that are accessing the same
MyISAM
tables, you can disable external system locks with
the
--skip-external-locking
[420]
option. However, external locking is disabled by default,
so it is likely that this option will have no effect. For
SHOW PROFILE
, this state means the thread is
requesting the lock (not waiting for it).
•
Table lock
The next thread state after
System lock
. The thread has acquired an external lock and is going to
request an internal table lock.
•
update
The thread is getting ready to start updating the table.
•
Updating
The thread is searching for rows to update and is updating them.
•
updating main table
The server is executing the first part of a multiple-table update. It is updating only the first table, and
saving columns and offsets to be used for updating the other (reference) tables.
•
updating reference tables
The server is executing the second part of a multiple-table update and updating the matched rows
from the other tables.
•
User lock
The thread is going to request or is waiting for an advisory lock requested with a
GET_LOCK()
[965]
call. For
SHOW PROFILE
, this state means the thread is requesting the lock
(not waiting for it).
•
Waiting for release of readlock
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...