WordPress.org
Get WordPress

Plugin Directory

Changeset 2982947


Ignore:
Timestamp:
10/24/2023 09:49:50 AM (2 years ago)
Author:
morisdov
Message:

readme.txt

Location:
mysql-query-cache-stats
Files:
3 edited

Legend:

Unmodified
Added
Removed

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

    r2982487 r2982947  
    1515
    1616= Why =
    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.
     17Database 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 performing database resulting in slow site.
    1818
    1919= How =
    … …  
    2828
    2929'Options Autoload Query Time' is measured in milliseconds (ms)
    30 * 0 ms - great performance below one millisecond
    31 * 1-2 ms - good performance
    32 * 3-5 ms - OK performance
    33 * 50+ ms - poor performance should be investigated
     30 0 ms - great performance below one millisecond
     31 1-2 ms - good performance
     32 3-5 ms - OK performance
     33 50+ ms - poor performance should be investigated
    3434
    3535= Size Metrics =
    … …  
    3737'Options Autoload Size' is measured in Bytes
    3838If you have the control to enable the database server wide query cache - configure query_cache_limit to be larger than `Options Autoload Size`
    39 * 20,000 Bytes - freshly installed clean wordpress site
    40 * 30,000 Bytes - small wordpress site
    41 * 50,000 Bytes - medium wordpress site
    42 * 250,000 Bytes - large wordpress site
    43 * 2,000,000+ Bytes - too large should be investigated
     39 20,000 Bytes - freshly installed clean wordpress site
     40 30,000 Bytes - small wordpress site
     41 50,000 Bytes - medium wordpress site
     42 250,000 Bytes - large wordpress site
     43 2,000,000+ Bytes - too large should be investigated
    4444( `all above are rough metrics` )
    4545
Note: See TracChangeset for help on using the changeset viewer.