Statistics
Short Description
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.
Detailed Description​
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.
How to reduce this wait​
To identify the source of high disk loads:
- look to see if backups are occurring in the production window
- look to see if the number of users has suddenly increased from normal
- look to see if the queries running have changed execution paths resulting in more data being examined
Additional Links​
- MySQL Documentation - General Thread States - statistics
- blog.monyog.com - Troubleshooting MySQL Performance Issues
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.