WordPress.org
Get WordPress

Plugin Directory

Changeset 2656208


Ignore:
Timestamp:
01/11/2022 11:21:01 PM (4 years ago)
Author:
morisdov
Message:

readme.txt

File:
1 edited

Legend:

Unmodified
Added
Removed

  • mysql-query-cache-stats/trunk/readme.txt

    r2644728 r2656208  
    1212
    1313== Description ==
    14 Admin dashboard widget monitoring of [query cache](https://mariadb.com/resources/blog/flexible-mariadb-server-query-cache) performance statistics - to optimize sizing of query cache memory amount and other related configurable settings.
    15 Monitor `Options Autoload Size` growth, ensure fit into `Query_cache_limit`.
    16 Understand when `Qcache_lowmem_prunes` occur.
     14Admin dashboard widget monitoring of [query cache](https://mariadb.com/resources/blog/flexible-mariadb-server-query-cache) performance statistics - to optimize sizing configuration and highlight bottlenecks.
     15
     16Query 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.
     17
     18Heavy plugins might increase very significantly this query result size.
     19Poorly written plugins have been found to constantly increase this query result size.
     20Oversized 'Options Autoload Size' result is a top factor in slow wordpress sites and the potential cause of sudden performance degradation.
     21
     22Monitor 'Options Autoload Size' fits into both 'Query_cache_size' and 'Query_cache_limit'.
     23Monitor when 'Qcache_lowmem_prunes' occur.
     24
    1725
    1826== Screenshots ==
Note: See TracChangeset for help on using the changeset viewer.