Hi, I am wondering what is the section of the site is causing that the 4 CPU cores have gone to 100%
The Querys:
SELECT SQL_CALC_FOUND_ROWS wpex_posts.ID FROM wpex_posts WHERE 1=1 AND (((wpex_posts.post_title LIKE '%plain%') OR (wpex_posts.post_excerpt LIKE '%plain%') OR (wpex_posts.post_content LIKE '%plain%'))) AND (wpex_posts.post_password = '') AND wpex_posts.post_type IN ('post', 'page', 'attachment', 'vc4_templates', 'cines', 'funebres') AND ((wpex_posts.post_status = 'publish')) ORDER BY wpex_posts.post_title LIKE '%plain%' DESC, wpex_posts.post_date DESC LIMIT 0, 4
SELECT SQL_CALC_FOUND_ROWS wpex_posts.ID FROM wpex_posts WHERE 1=1 AND (((wpex_posts.post_title LIKE '%Saturday%') OR (wpex_posts.post_excerpt LIKE '%Saturday%') OR (wpex_posts.post_content LIKE '%Saturday%')) AND ((wpex_posts.post_title LIKE '%1%') OR (wpex_posts.post_excerpt LIKE '%1%') OR (wpex_posts.post_content LIKE '%1%')) AND ((wpex_posts.post_title LIKE '%ju%') OR (wpex_posts.post_excerpt LIKE '%ju%') OR (wpex_posts.post_content LIKE '%ju%'))) AND (wpex_posts.post_password = '') AND wpex_posts.post_type IN ('post', 'page', 'attachment', 'vc4_templates', 'cines', 'funebres') AND ((wpex_posts.post_status = 'publish')) ORDER BY (CASE WHEN wpex_posts.post_title LIKE '%Saturday 1 of ju%' THEN 1 WHEN wpex_posts.post_title LIKE '%Saturday%' AND wpex_posts.post_title LIKE '%1%' AND wpex_posts.post_title LIKE '%ju%' THEN 2 WHEN wpex_posts.post_title LIKE '%Saturday%' OR wpex_posts.post_title LIKE '%1%' OR wpex_posts.post_title LIKE '%ju%' THEN 3 WHEN wpex_posts.post_excerpt LIKE '%Saturday 1 of ju%' THEN 4 WHEN wpex_posts.post_content LIKE '%Saturday 1 of ju%' THEN 5 ELSE 6 END), wpex_posts.post_date DESC LIMIT 0
Thanks!!
Hello,
There are many things that can affect the cpu load.
Please follow these topics:
https://forum.tagdiv.com/topic/high-cpu-usage-and-caching-issues/
https://forum.tagdiv.com/topic/100-cpu-when-using-visual-composer-after-site-migration/
Basicaly you need to limit your complex elements on the pages, try not to use visual composer but rather use our own tagdiv composer and make sure you meet the requirements and memory allocation needed.
Thanks.
Hi Bordan, Thanks for your time,
Please I need a specific answer. I need to know if it is posible to know which user actions will generate the next db queries in newspaper.
Thanks
Clicking on pagination, clicking on the ajax filter and requesting more posts, etc.
Simply using a few blocks with pagination and ajax filters will do the trick. Each time a user clicks the pagination depending on the block, 5 posts or more are requested. Ajax filters the same.
Simply using visual composer and not our tagdiv composer increases the load very much as VC is known to be a cpu hog.
There is no specific answer I can provide as each case is particular and not the same applies to all cases.
In your case there could simply be a plugin that creates the massive load and not the theme at all. I cannot say for sure.
Thank you!
