MySQL query cache stats
Admin dashboard widget measuring and monitoring MySQL / MariaDB query cache performance & statistics — to optimize sizing configuration and highlight bottlenecks.
Why
Database Query for Options Autoload is repeatedly executed for each WP page load and its poor performance has been identified as a good indicator for a poorly performing database resulting in slow site.
How
- Use dashboard widget to measure and monitor
Options Autoload Query Time
- Use dashboard widget to measure and monitor
Options Autoload Query Size
This query result size increases constantly over time, as WP site usage grows — but its oversized sudden growth or constant balooning must not be overlooked.
Heavy plugins might rely heavily on adding data to Options Autoload Query Size
.
Poorly written plugins causing WP performance degradation have been found to constantly increase this query result size.
Time Metrics
‘Options Autoload Query Time’ is measured in milliseconds (ms)
0 ms — great performance below one millisecond 1-2 ms — good performance 3-5 ms — OK performance 50+ ms — poor performance should be investigated
Size Metrics
‘Options Autoload Size’ is measured in Bytes
If you have the control to enable the database server wide query cache — configure query_cache_limit to be larger than Options Autoload Size
20,000 Bytes — freshly installed clean wordpress site
30,000 Bytes — small wordpress site
50,000 Bytes — medium wordpress site
250,000 Bytes — large wordpress site
2,000,000+ Bytes — too large should be investigated
( all above are rough metrics
)