High CPU USAGE?

disable most of the plugins

“Most plugins”? Which were left? Just Query Monitor? I may be wrong, but I think Query Monitor itself can increase CPU utilization. I recommend using cPanel to monitor resource utilization and deactivate all plugins. Also switch to one of the default Twenty* themes as a theme can also increase CPU utilization.

In basically its out of the box state, your site shouldn’t require excessive CPU resource. Restore your normal theme and plugins, one at a time, checking resource utilization after each. When the problem recurs, the last activated module is the likely cause. Either seek further assistance through that module’s dedicated support channel, or find an alternative plugin, or do without.

@bcworkz

View post on imgur.com

Check this image from Resource usage

All that really shows @qnkov is that your site’s using a lot of resources, which you already mentioned.

Have you tried any of the steps that bcworkz suggested?

If so, what was the result of each step?

The problem is that everything is so random. It works perfectly, then it does not. I’ve deactived all plugins and the site was working perfectly. I’ve reactived them, it worked again perfectly. Then i’ve got message from the hosting provider with that:

Hello,

The lines we observe are:

[Warning] Aborted connection 8440202 to db: 'mydb' user: 'myuser' host: 'localhost' (Query execution was interrupted (max_statement_time exceeded))
Aborted connection 8441215 to db: 'mydb' user: 'myuser' host: 'localhost' (Got an error writing communication packets)

The case study comes from a database query execution time limit. Due to this PHP processes are not closed and CPU consumption is raised.
I'm attaching some of the statements that reached max_statement_time:


SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
                                         FROM wp_posts LEFT JOIN wp_term_relationships tr ON wp_posts.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN wp_terms t ON t.term_id = tt.term_id INNER JOIN wp_postmeta AS unique_postmeta_selector ON (wp_posts.ID = unique_id)
postmeta_selector.post_id)
                                         WHERE 1=1 AND ( (unique_postmeta_selector.meta_value LIKE '%sword art online%' AND unique_postmeta_selector.meta_key = 'ero_japanese') OR ((wp_posts.post_title LIKE '%sword%') OR (0 LIKE '%sword%') OR (0 LIKE '%sword%')) AND ((wp_posts.post_title LIKE '%art%') OR (0 LIKE '%
art%') OR (0 LIKE '%art%')) AND ((wp_posts.post_title LIKE '%online%') OR (0 LIKE '%online%') OR (0 LIKE '%online%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'anime' AND (wp_posts.post_status = 'publish'))) OR ((tt.taxonomy = 'post_tag' AND (t.name LIKE '%sword art online%' OR t.slug LIKE '%s
word art online%')) AND wp_posts.post_status = 'publish' AND wp_posts.post_type = 'anime')
                                         GROUP BY wp_posts.ID
                                         ORDER BY (CASE WHEN wp_posts.post_title LIKE '%sword art online%' THEN 1 WHEN wp_posts.post_title LIKE '%sword%' AND wp_posts.post_title LIKE '%art%' AND wp_posts.post_title LIKE '%online%' THEN 2 WHEN wp_posts.post_title LIKE '%sword%' OR wp_posts.post_title LIKE '%art%' OR w
p_posts.post_title LIKE '%online%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%sword art online%' THEN 4 WHEN wp_posts.post_content LIKE '%sword art online%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
                                         LIMIT 0, 12;


SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
                                         FROM wp_posts LEFT JOIN wp_term_relationships tr ON wp_posts.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN wp_terms t ON t.term_id = tt.term_id INNER JOIN wp_postmeta AS unique_postmeta_selector ON (wp_posts.ID = unique_postmeta_selector .post_id)
                                         WHERE 1=1 AND ( (unique_postmeta_selector.meta_value LIKE '%sword art online%' AND unique_postmeta_selector.meta_key = 'ero_japanese') OR ((wp_posts.post_title LIKE '%sword%') OR (0 LIKE '%sword%') OR (0 LIKE '%sword%')) AND ((wp_posts.post_title LIKE '%art%') OR (0 LIKE '%art%') OR (0 LIKE '%art%')) AND ((wp_posts. post_title LIKE '%online%') OR (0 LIKE '%online%') OR (0 LIKE '%online%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'anime' AND (wp_posts.post_status = 'publish'))) OR ((tt.taxonomy = 'post_tag' AND (t.name LIKE '%sword art online%' OR t.slug LIKE '%sword art online%')) AND wp_posts .post_status = 'publish' AND wp_posts.post_type = 'anime')
                                         GROUP BY wp_posts.ID
                                         ORDER BY (CASE WHEN wp_posts.post_title LIKE '%sword art online%' THEN 1 WHEN wp_posts.post_title LIKE '%sword%' AND wp_posts.post_title LIKE '%art%' AND wp_posts.post_title LIKE '%online%' THEN 2 WHEN wp_posts.post_title LIKE '%sword%' OR wp_posts.post_title LIKE '%art%' OR wp_posts.post_title LIKE '%online%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%sword art online%' THEN 4 WHEN wp_posts.post_content LIKE '%sword art online%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
                                         LIMIT 0, 12;


SELECT wp_posts.ID
                         FROM wp_posts LEFT JOIN wp_term_relationships tr ON wp_posts.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN wp_terms t ON t.term_id = tt.term_id INNER JOIN wp_postmeta AS unique_postmeta_selector ON (wp_posts.ID = unique_postmeta_selector .post_id)
                         WHERE 1=1 AND ( (unique_postmeta_selector.meta_value LIKE '%Tower %' AND unique_postmeta_selector.meta_key = 'ero_japanese') OR ((wp_posts.post_title LIKE '%Tower%') OR (0 LIKE '%Tower%') OR ( 0 LIKE '%Tower%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type = 'anime' AND ((wp_posts.post_status = 'publish')) OR ((tt.taxonomy = 'post_tag' AND (t.name LIKE '%Tower %' OR t.slug LIKE '%Tower %')) AND wp_posts.post_status = 'publish' AND wp_posts.post_type = 'anime')
                         GROUP BY wp_posts.ID
                         ORDER

And in the end i think it’s my theme codding, which may doing that? Can you tell me what u think and what we could do to fix this, if the theme’s developer tells me it’s not on his side?

• This reply was modified 10 months ago by qnkov.

All I can say with the information provided is that the issue definitely doesn’t happen in WordPress by itself.

That means it’s either caused by your plugins or your theme.

The only way to know for sure is to keep all plugins off for the average reproduction period. That means, if it takes a day, that you leave all plugins off for a day.

If the problem doesn’t return, then one of your plugins is causing it. You’ll need to reactivate them individually, a day at a time, until you find the one causing the problem.

If the problem returns with all plugins off, that means it’s your theme.

@macmanx

I’ve got another respond from the hosting providers:

The case is mostly caused by the “SQL_CALC_FOUND_ROWS” query. I see it used in the following plugins:

mycred, ultimate-member, w3-total-cache and wordfence. From these we can exclude (for now) w3-total-cache and wordfence, because many other customers use them and we have not observed a similar case with them.

It is quite possible that the case occurs either during higher traffic or during the execution of a certain function. From cPanel -> Resource usage you can monitor the resources, currently almost none are being used (I guess from the plug-ins being turned off).

What I can recommend you is when there is more traffic to turn off the plugins 1 by 1 (by waiting a few minutes) and monitor the resource statistics.

What i can say is, that i’m using only Ultimate member last version + wordpress last version. I will ask anyway in ultimate member forum, but if you guys can give me ideas, im reading.

Excellent, noting that thread is at https://www.ads-software.com/support/topic/high-cpu-usage-59/