Large Queries are Hanging in State 'Statistics' on High Load with Large Query Cache
Last updated on DECEMBER 29, 2016
Applies to:MySQL Server - Version 5.1 and later
Information in this document applies to any platform.
- Busy server.
- Processlist shows queries spending much time in 'statistics' state (especially large queries involving many tables/columns/conditions/etc).
- Parameter query_cache_size is configured to large value (typically bigger than 128Mb)
- Sometimes high ratio in status variables Qcache_lowmem_prunes / Uptime may be observed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms