MyQSL query cache stats
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.
Download & install the zip archive
The plugin package installer can be downloaded from the WP2E project tab called “code”.
1 – Select the version to download if this option is available otherwise the “latest” version of the main plugin will be used.
2 – After downloading the zip archive install the plugin package installer in you local environment and activate the script from the plugin list.
3 – Under the section “Plugins” of the admin dashboard you should see a new “Dependencies & Licenses” link. Follow the instructions from this panel to finalize the installation of the missing dependencies.
-
- Give a name to your project
-
- Download the Installer Package
-
- Install & activate the plugin locally
-
- Install the suggested dependencies
Tips: Use the WP2E panel to add/suggest new dependencies to the local installation. Press F5 in the list of dependencies if the changes are not displayed right away.