• Resolved Apfelbiss

    (@apfelbiss)


    Hello,

    I have already had slow loading times twice today due to almost 100% CPU utilization according to phpMyAdmin.

    After a PHP reset, the load went back down to the normal level of approx. 20 to 40%.

    Previously phpMyAdmin showed me processes like this, that seem to be connected to Booster for WooCommerce (because of the mentioned „wcj“):

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta AS wcj_sku ON (wp_posts.ID = wcj_sku.post_id) WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (7) ) AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (8) ) ) AND (((wp_posts.post_title LIKE '%ekg%') OR (wcj_sku.meta_key = '_sku' AND CAST(wcj_sku.meta_value AS CHAR) LIKE '%ekg%') OR (wp_posts.post_excerpt LIKE '%ekg%') OR (wp_posts.post_content LIKE '%ekg%')) AND ((wp_posts.post_title LIKE '%gerät%') OR (wcj_sku.meta_key = '_sku' AND CAST(wcj_sku.meta_value AS CHAR) LIKE '%gerät%') OR (wp_posts.post_excerpt LIKE '%gerät%') OR (wp_posts.post_content LIKE '%gerät%')) AND ((wp_posts.post_title LIKE '%zuhause%') OR (wcj_sku.meta_key = '_sku' AND CAST(wcj_sku.meta_value AS CHAR) LIKE '%zuhause%') OR (wp_posts.post_excerpt LIKE '%zuhause%') OR (wp_posts.post_content LIKE '%zuhause%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 1

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta AS wcj_sku ON (wp_posts.ID = wcj_sku.post_id) WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (7) ) AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (8) ) ) AND (((wp_posts.post_title LIKE '%jaune%') OR (wcj_sku.meta_key = '_sku' AND CAST(wcj_sku.meta_value AS CHAR) LIKE '%jaune%') OR (wp_posts.post_excerpt LIKE '%jaune%') OR (wp_posts.post_content LIKE '%jaune%')) AND ((wp_posts.post_title LIKE '%vaste%') OR (wcj_sku.meta_key = '_sku' AND CAST(wcj_sku.meta_value AS CHAR) LIKE '%vaste%') OR (wp_posts.post_excerpt LIKE '%vaste%') OR (wp_posts.post_content LIKE '%vaste%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 1

    Can the cause be found and corrected on the basis of this information?

    Thank you in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor David G

    (@gravid7)

    Hi @apfelbiss,

    Thanks for reaching out to us.

    This could be a memory issue. You can try to increase memory by adding the below code to the wp-config.php file.
    define( ‘WP_MEMORY_LIMIT’, ‘1024M’ );

    This will allocate more memory to WordPress and may help improve performance.

    Plugin Contributor David G

    (@gravid7)

    Hi @apfelbiss,

    I haven’t heard back from you, so I believe the issue has been resolved.

    I’m marking this topic complete, please feel free to open a new thread for any further queries.

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

The topic ‘Slow load time due to certain PHP processes?’ is closed to new replies.