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 ca…