Large Queries are Hanging in State 'Statistics' on High Load with Large Query Cache
(Doc ID 1992697.1)
Last updated on FEBRUARY 11, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.