原始文件定義: http://dev.mysql.com/doc/refman/5.5/en/general-thread-states.html
•Network Operation
Reading from net
Writing to net
Sending data
•SortSorting 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
•Lockchecking permissions
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.
=================================================
出現次數統計 (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.