Tell us what you are trying to do? The website is periodically timing out. We host with Kinsta and have an advanced program with them. They asked us to reach out about reducing high CPU usage ideas.
Is there any documentation that you are following? No
Is there a similar example that we can see? No
What is the link to your site? https: carolinalivingchoices.com
Example of the queries: As to the queries, there are a lot of this kind of running at the moment:
SELECT wp_posts[.]ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts[.]ID = wp_postmeta[.]post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts[.]ID = mt1[.]post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts[.]ID = mt2[.]post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts[.]ID = mt3[.]post_id ) INNER JOIN wp_postmeta AS mt4 ON ( wp_posts[.]ID = mt4[.]post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'wpcf-tier-level' AND ( ( mt1.meta_key = 'wpcf-community-type' AND mt1.meta_value = 'Active Adult Communities' ) OR ( ( mt2.meta_key = 'wpcf-villas-condos-cluster-homes' AND mt2.meta_value LIKE '%wpcf-fields-checkboxes-option-693f85d45a0cd5508a48fb113f9330d5-1%' ) OR ( mt2.meta_key = 'wpcf-villas-condos-cluster-homes' AND mt2.meta_value LIKE '%wpcf-fields-checkboxes-option-8d5e9e917c54c3bda5f1a8df701464d6-1%' ) ) OR ( ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-819ce08f3b6b3916dcbea0353468114b-1%' ) OR ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-e93c9668c5ae597e352fe087f6d8c4b1-1%' ) OR ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-ed8d1b86d5d8cb3d6e99078a91d7639e-1%' ) OR ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-1eaa2363f1af6984d78ebec1050a070e-1%' ) OR ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-eea9e3fd10177a0b30f18516578e8700-1%' ) OR ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-4504a389e56e137942c088ba1e1cb13d-1%' ) OR ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-a0a93800ae3d705d535d349e29e37867-1%' ) OR ( mt3.meta_key = 'wpcf-active-adult-community-amenities-search' AND mt3.meta_value LIKE '%wpcf-fields-checkboxes-option-bc0c0ce7b4737e93157ff3696c6ae163-1%' ) ) OR ( ( mt4.meta_key = 'wpcf-active-adult-outdoor-activities' AND mt4.meta_value LIKE '%wpcf-fields-checkboxes-option-cb26bbf3f685d29f435b23fccf606dd3-1%' ) OR ( mt4.meta_key = 'wpcf-active-adult-outdoor-activities' AND mt4.meta_value LIKE '%wpcf-fields-checkboxes-option-6a1b518220275c59034633368c4566ec-1%' ) OR ( mt4.meta_key = 'wpcf-active-adult-outdoor-activities' AND mt4.meta_value LIKE '%wpcf-fields-checkboxes-option-3d6b1b38c57f93f916b02f38d0111747-1%' ) OR ( mt4.meta_key = 'wpcf-active-adult-outdoor-activities' AND mt4.meta_value LIKE '%wpcf-fields-checkboxes-option-9594741c262e1136689c18463973b8a5-1%' ) OR ( mt4.meta_key = 'wpcf-active-adult-outdoor-activities' AND mt4.meta_value LIKE '%wpcf-fields-checkboxes-option-7078f8d22f507af43679bc58bdda182a-1%' ) OR ( mt4.meta_key = 'wpcf-active-adult-outdoor-activities' AND mt4.meta_value LIKE '%wpcf-fields-checkboxes-option-8fd6ba408b4e83ee4edec43300ad0fdd-1%' ) OR ( mt4.meta_key = 'wpcf-active-adult-outdoor-activities' AND mt4.meta_value LIKE '%wpcf-fields-checkboxes-option-49d610c6a210978bcc209c9b3320d2fc-1%' ) ) ) ) AND wp_posts[.]post_type = 'product' AND ((wp_posts[.]post_status = 'publish')) GROUP BY wp_posts[.]ID ORDER BY wp_postmeta.meta_value ASC
They start with wpcf_
Hi there,
The SQL command does not give much info other than there are many inner joins happening with a lot of custom fields.
Would you please provide the Toolset debug info?
https://toolset.com/faq/provide-debug-information-faster-support/
The other thing is to know which page causes this SQL code. Can you provide the URL of the page having the issue?
If it is a slider page, I'd appreciate it if you can turn off the pre-loading feature and see if it eases the CPU burden?
Finally if you have a custom search, please tell us what happens if you deactivate the Ajax loading? Does it fix the issue?
Thanks.
Sorry this went to spam. Please note, I marked this thread as private and its showing public.
URL: hidden link
I don't see any preloading options checked.
Hi there,
It seems that on the page you gave you enabled the Ajax load when clicked on the items in the left side for the custom fields.
Would you please test by setting that to have a search button and page load instead of Ajax?
See if the same issue is happening with CPU there?
Also please test if the same thing happens when there is only Toolset enabled.
- IMPORTANT STEP! Create a backup of your website. Or better approach will be to test this on a copy/staging version of the website to avoid any disruption of a live website.
- Go to "WordPress Dashboard > Plugins" and deactivate all plugins except Toolset and its add-ons.
- Check if you can still recreate the issue.
- If not, re-activate your plugins one by one and check the issue each time to find out the plugin that causes the problem.
Thanks.
