Description
Admin dashboard widget monitoring of query cache performance statistics – to optimize sizing configuration and highlight bottlenecks.
Query for ‘Options Autoload Size’ is freshly executed on each page load and its result size increases constantly over time and is closely related to the amount of data plugins save.
Heavy plugins might increase very significantly this query result size.
Poorly written plugins have been found to constantly increase this query result size.
Oversized ‘Options Autoload Size’ result is a top factor in slow wordpress sites and the potential cause of sudden performance degradation.
Monitor ‘Options Autoload Size’ fits into both ‘Query_cache_size’ and ‘Query_cache_limit’.
Monitor when ‘Qcache_lowmem_prunes’ occur.
Screenshots
Active query cache stats 
Disabled query cache stats 
Execute database command RESET QUERY CACHE
Reviews
There are no reviews for this plugin.
Contributors & Developers
“MyQSL query cache stats” is open source software. The following people have contributed to this plugin.
Contributors
Translate “MyQSL query cache stats” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.0.3
- Added wp_options Autoload Size
1.0.2
- Added Database Size
- Added Refresh button
1.0.1
- Added Questions, removed Queries
Query cache does not cache statements executed within stored programs.
Queries differs from Questions in that it also counts statements executed within stored programs.
Questions differs from Queries in that it doesn’t count statements executed within stored programs. - Added widget button RESET QUERY CACHE
Execute database command RESET QUERY CACHE.
1.0
- First release