Changeset 2982469
- Timestamp:
- 10/23/2023 08:32:00 AM (2 years ago)
- File:
-
- 1 edited
-
mysql-query-cache-stats/trunk/readme.txt (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
mysql-query-cache-stats/trunk/readme.txt
r2982465 r2982469 14 14 Admin dashboard widget measuring and monitoring MySQL / MariaDB [query cache](https://mariadb.com/resources/blog/flexible-mariadb-server-query-cache "MariaDB Query Cache") performance & statistics - to optimize sizing configuration and highlight bottlenecks. 15 15 16 ** Why ** 16 = Why = 17 17 Database Query for [Options Autoload](https://kinsta.com/knowledgebase/wp-options-autoloaded-data/#what-is-the-wp_options-table "What is the wp_options table") is repeatedly executed for each WP page load and its poor performance has been identified as a good indicator for a poorly peforming database resulting in slow site. 18 18 19 ** How ** 19 = How = 20 20 * Use dashboard widget to measure and monitor `Options Autoload Query Time` 21 21 * Use dashboard widget to measure and monitor `Options Autoload Query Size` … … 25 25 Poorly written plugins causing WP performance degradation have been found to constantly increase this query result size. 26 26 27 ** Time Metrics ** 27 = Time Metrics = 28 28 29 `Options Autoload Query Time`is measured in milliseconds (ms)29 'Options Autoload Query Time' is measured in milliseconds (ms) 30 30 * 0 ms - great performance below one millisecond 31 31 * 1-2 ms - good performance … … 33 33 * 50+ ms - poor performance should be investigated 34 34 35 ** Size Metrics ** 35 = Size Metrics = 36 36 37 `Options Autoload Size`is measured in Bytes37 'Options Autoload Size' is measured in Bytes 38 38 If you have the control to enable the database server wide query cache - configure query_cache_limit to be larger than `Options Autoload Size` 39 39 * 20,000 Bytes - freshly installed clean wordpress site
Note: See TracChangeset
for help on using the changeset viewer.