[MySQL]Mysql Thread State Classification

Mysql Thread State Classification
原始文件定義: http://dev.mysql.com/doc/refman/5.5/en/general-thread-states.html

 •Network Operation
   Reading from net
   Writing to net

   Sending data

•Sort
   Sorting result
•Update
   update
   updating
   Updating
•Temp Table (Disk Operation)
   Copying to tmp table on disk
•Table Operation
   Copying to tmp table
   Opening tables
   closing tables
   converting HEAP to MyISAM
   Creating tmp table 

   removing tmp table

•Flush Operation
•Closing, Cleaning, Ending
   cleaning up
   end
•Other Administration Operation

   statistics

   preparing

   freeing items
   checking permissions

•Lock
   Locked
   Waiting for release of readlock

•User Operation

   init

   executing

   login
=================================================
出現次數統計 (2/22~3/1)
Sending data ## 218
update ## 192
Copying to tmp table ## 1241
Updating ## 61
Locked ## 136
end ## 90
init ## 7
Copying to tmp table on disk ## 28
statistics ## 22
preparing ## 5
Opening tables ## 3
Reading from net ## 7
cleaning up ## 3
closing tables ## 1
freeing items ## 1
updating ## 4
executing ## 2
login ## 27
Writing to net ## 46
converting HEAP to MyISAM ## 3
Sorting result ## 2
Waiting for release of readlock ## 97
checking permissions ## 1
Creating tmp table ## 2
removing tmp table ## 1
========================================
文章修改紀錄:
2/25 觀察到20個state, 並進行分類.
3/1 新增5個新觀察到的state.