New Release: Urgent Performance issues

  • Resolved justin-bigscoots

    (@justin-bigscoots)


    4 years, 9 months ago

    We’ve noticed on at least 20-30 sites huge performance issues being caused by the newest release of cache enabler.

    Example of some of the slow logs:

    script_filename = /home/nginx/domains/domain.com/public/wp-admin/post.php
[0x00007fe1f9415340] mysqli_query() /home/nginx/domains/domain.com/public/wp-includes/wp-db.php:2056
[0x00007fe1f94152d0] _do_query() /home/nginx/domains/domain.com/public/wp-includes/wp-db.php:1945
[0x00007fe1f94151f0] query() /home/nginx/domains/domain.com/public/wp-includes/wp-db.php:2657
[0x00007fe1f9415130] get_col() /home/nginx/domains/domain.com/public/wp-includes/class-wp-query.php:3024
[0x00007fe1f9414a50] get_posts() /home/nginx/domains/domain.com/public/wp-includes/class-wp-query.php:3465
[0x00007fe1f94149e0] query() /home/nginx/domains/domain.com/public/wp-includes/class-wp-query.php:3576
[0x00007fe1f9414970] __construct() /home/nginx/domains/domain.com/public/wp-includes/rewrite.php:632
[0x00007fe1f9414740] url_to_postid() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler_disk.class.php:229
[0x00007fe1f94145b0] cache_iterator() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:925
[0x00007fe1f9414510] get_cache_size() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:268
[0x00007fe1f9414410] on_cache_created_cleared() /home/nginx/domains/domain.com/public/wp-includes/class-wp-hook.php:303
[0x00007fe1f9414330] apply_filters() /home/nginx/domains/domain.com/public/wp-includes/class-wp-hook.php:327
[0x00007fe1f94142c0] do_action() /home/nginx/domains/domain.com/public/wp-includes/plugin.php:470
[0x00007fe1f94141b0] do_action() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler_disk.class.php:470
[0x00007fe1f94140b0] fire_cache_cleared_hooks() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler_disk.class.php:241
[0x00007fe1f9413f20] cache_iterator() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:2125
[0x00007fe1f9413e90] clear_page_cache_by_url() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1842
[0x00007fe1f9413df0] clear_term_archive_cache() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1736
[0x00007fe1f9413d50] clear_post_terms_archives_cache() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1599
[0x00007fe1f9413cd0] clear_post_cache() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:2152

    This is causing memory leaks in PHP processes and huge CPU spikes in MySQL

    Will provide more info soon.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter justin-bigscoots

    (@justin-bigscoots)

    4 years, 9 months ago

    It seems to be from these functions, seeing massssive issues from them:

        297 wp_count_terms() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1246
    303 clear_taxonomies_archives_cache_by_post_id() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1199
    304 clear_associated_cache() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1441
    304 clear_cache_on_post_save() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:974
    742 wp_count_terms() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1241
    782 clear_taxonomies_archives_cache_by_post_id() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1194
    783 clear_associated_cache() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1431
    784 clear_cache_on_post_save() /home/nginx/domains/domain.com/public/wp-content/plugins/cache-enabler/inc/cache_enabler.class.php:1009
    Anonymous User 16850768

    (@anonymized-16850768)

    4 years, 9 months ago

    Thanks for the detailed information, @justin-bigscoots. Let me look into this. I believe I notice a performance improvement that may be applicable here, but I’ll need to run some tests to confirm this.

    Question. Are the second set of logs shared from the 1.8 branch? I ask because Cache_Enabler::clear_cache_on_post_save() no longer calls Cache_Enabler::clear_associated_cache() since it’s been deprecated.

    Anonymous User 16850768

    (@anonymized-16850768)

    4 years, 9 months ago

    I did find an issue that this may be related to. It will be fixed and released shortly. Please let me know if it does.

    Thread Starter justin-bigscoots

    (@justin-bigscoots)

    4 years, 9 months ago

    Some more info… Noticing these queries becoming very taxing as well:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
    wp_term_relationships.term_taxonomy_id IN (48)
    ) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date

    This isn’t a CE specific query but I believe you are calling a function that triggers it from wp core.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘New Release: Urgent Performance issues’ is closed to new replies.