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.

螢幕截圖

  • Active query cache stats
  • Disabled query cache stats
  • Execute database command RESET QUERY CACHE

評價

There are no reviews for this plugin.

貢獻者及開發者

“MyQSL query cache stats” 是一個開源的軟體。以下的人對這個外掛作出了貢獻。

貢獻者

將 MyQSL query cache stats 外掛本地化為台灣繁體中文版。

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

修改日誌

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