{"id":128942,"date":"2020-09-23T18:18:00","date_gmt":"2020-09-23T18:18:00","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/mysql-query-cache-stats\/"},"modified":"2025-12-02T17:06:07","modified_gmt":"2025-12-02T17:06:07","slug":"mysql-query-cache-stats","status":"publish","type":"plugin","link":"https:\/\/azb.wordpress.org\/plugins\/mysql-query-cache-stats\/","author":8209693,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.4","stable_tag":"trunk","tested":"6.9.4","requires":"3.6","requires_php":"5.6","requires_plugins":null,"header_name":"MySQL query cache stats","header_author":"Moris Dov","header_description":"Dashboard widget for MySQL query cache statistics","assets_banners_color":"1582a5","last_updated":"2025-12-02 17:06:07","external_support_url":"","external_repository_url":"","donate_link":"http:\/\/www.childrensheartlink.org\/donate","header_plugin_uri":"https:\/\/wordpress.org\/plugins\/mysql-query-cache-stats","header_author_uri":"https:\/\/profiles.wordpress.org\/morisdov","rating":0,"author_block_rating":0,"active_installs":40,"downloads":3139,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":2403328,"resolution":"128x128","location":"assets","locale":""},"icon-256x256.png":{"filename":"icon-256x256.png","revision":2403328,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":2982519,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":2982947,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":2983033,"resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":2981933,"resolution":"3","location":"assets","locale":""}},"screenshots":{"1":"Active query cache stats","2":"Disabled query cache stats","3":"Execute database command RESET QUERY CACHE"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[153,71056,247,4056,9568],"plugin_category":[43,52,59],"plugin_contributors":[89429],"plugin_business_model":[],"class_list":["post-128942","plugin","type-plugin","status-publish","hentry","plugin_tags-database","plugin_tags-mariadb","plugin_tags-performance","plugin_tags-tuning","plugin_tags-wp_options","plugin_category-customization","plugin_category-performance","plugin_category-utilities-and-tools","plugin_contributors-morisdov","plugin_committers-morisdov"],"banners":{"banner":"https:\/\/ps.w.org\/mysql-query-cache-stats\/assets\/banner-772x250.png?rev=2982519","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/mysql-query-cache-stats\/assets\/icon-128x128.png?rev=2403328","icon_2x":"https:\/\/ps.w.org\/mysql-query-cache-stats\/assets\/icon-256x256.png?rev=2403328","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/mysql-query-cache-stats\/assets\/screenshot-1.png?rev=2982947","caption":"Active query cache stats"},{"src":"https:\/\/ps.w.org\/mysql-query-cache-stats\/assets\/screenshot-2.png?rev=2983033","caption":"Disabled query cache stats"},{"src":"https:\/\/ps.w.org\/mysql-query-cache-stats\/assets\/screenshot-3.png?rev=2981933","caption":"Execute database command RESET QUERY CACHE"}],"raw_content":"<!--section=description-->\n<p>Admin dashboard widget measuring and monitoring MySQL \/ MariaDB <a href=\"https:\/\/mariadb.com\/resources\/blog\/flexible-mariadb-server-query-cache\" title=\"MariaDB Query Cache\">query cache<\/a> performance &amp; statistics - to optimize sizing configuration and highlight bottlenecks.<\/p>\n\n<h4>Why<\/h4>\n\n<p>Database Query for <a href=\"https:\/\/kinsta.com\/knowledgebase\/wp-options-autoloaded-data\/#what-is-the-wp_options-table\" title=\"What is the wp_options table\">Options Autoload<\/a> 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.<\/p>\n\n<h4>How<\/h4>\n\n<ul>\n<li>Use dashboard widget to measure and monitor <code>Options Autoload Query Time<\/code><\/li>\n<li>Use dashboard widget to measure and monitor <code>Options Autoload Query Size<\/code>\nThis query result size increases constantly over time, as WP site usage grows - but its oversized sudden growth or constant balooning must not be overlooked.<\/li>\n<\/ul>\n\n<p>Heavy plugins might rely heavily on adding data to <code>Options Autoload Query Size<\/code>.\nPoorly written plugins causing WP performance degradation have been found to constantly increase this query result size.<\/p>\n\n<h4>Time Metrics<\/h4>\n\n<p>'Options Autoload Query Time' is measured in milliseconds (ms)<\/p>\n\n<p>0 ms - great performance below one millisecond\n 1-2 ms - good performance\n 3-5 ms - OK performance\n 50+ ms - poor performance should be investigated<\/p>\n\n<h4>Size Metrics<\/h4>\n\n<p>'Options Autoload Size' is measured in Bytes\nIf you have the control to enable the database server wide query cache - configure query_cache_limit to be larger than <code>Options Autoload Size<\/code><\/p>\n\n<p>20,000 Bytes - freshly installed clean wordpress site\n 30,000 Bytes - small wordpress site\n 50,000 Bytes - medium wordpress site\n 250,000 Bytes - large wordpress site\n 2,000,000+ Bytes - too large should be investigated\n( <code>all above are rough metrics<\/code> )<\/p>\n\n<!--section=faq-->\n<dl>\n<dt id='this%20plugin%20improves%20page%20load%20performance%20%3F'><h3>This plugin improves page load performance ?<\/h3><\/dt>\n<dd><p>No, This plugin in itself does not improve performance by being installed, this plugin only measures time and size of database query.<\/p><\/dd>\n<dt id='this%20plugin%20improves%20database%20performance%20%3F'><h3>This plugin improves database performance ?<\/h3><\/dt>\n<dd><p>No, This plugin in itself does not improve performance by being installed, an administrator should use the dashboard widget to measure, monitor and identify problems.<\/p><\/dd>\n<dt id='must%20database%20query%20cache%20be%20enabled%20%3F'><h3>Must database query cache be enabled ?<\/h3><\/dt>\n<dd><p>No, This plugin measures time and size of a very important database query and these measurements should be valuable to an administrator whether database query cache is enabled or not.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.4<\/h4>\n\n<ul>\n<li>Added wp_options Autoload Query Time<\/li>\n<\/ul>\n\n<h4>1.0.3<\/h4>\n\n<ul>\n<li>Added wp_options Autoload Size<\/li>\n<\/ul>\n\n<h4>1.0.2<\/h4>\n\n<ul>\n<li>Added Database Size<\/li>\n<li>Added Refresh button<\/li>\n<\/ul>\n\n<h4>1.0.1<\/h4>\n\n<ul>\n<li>Added Questions, removed Queries\nQuery cache does not cache statements executed within stored programs.\nQueries differs from Questions in that it also counts statements executed within stored programs.\nQuestions differs from Queries in that it doesn't count statements executed within stored programs. <\/li>\n<li>Added widget button RESET QUERY CACHE\nExecute database command RESET QUERY CACHE.<\/li>\n<\/ul>\n\n<h4>1.0<\/h4>\n\n<ul>\n<li>First release<\/li>\n<\/ul>","raw_excerpt":"Admin dashboard widget measuring MySQL database performance &amp; query cache","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/128942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=128942"}],"author":[{"embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/morisdov"}],"wp:attachment":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=128942"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=128942"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=128942"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=128942"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=128942"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=128942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}