Too many MySQL requests causes the site to go down

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Karachi (GMT+05:00)

Tagged: Setting up custom fields, Setting up custom types, Toolset Blocks, Types plugin, Views, Views plugin

This topic contains 3 replies, has 2 voices.

Last updated by Waqar 5 months, 3 weeks ago.

Assisted by: Waqar.

Author

Posts

April 23, 2024 at 3:33 pm #2693930

Marcel

On an existing site, I've added a CPT with just 2 custom fields; an image field and a URL field. The images are loaded from external URLs, the URL fields point to a page on the same site. There are only 40 posts added in this custom post type.

The site is on a VPS with enough resources, but since I've added Toolset, it keeps going down. According too the hosting, that's because of a LOT of MySQL requests.

I did experience some problems when creating a view; it was created twice and I couldn't edit it anymore. So I deleted both views and created a new one.

April 24, 2024 at 7:41 am #2694047

Waqar

Hi,

Thank you for contacting us and I'd be happy to assist.

The usage and setup details that you've shared shouldn't be causing a VPS server to go down.

Have you checked the server's error logs for any errors/warnings? And did the hosting support provide information about any particular SQL queries?

I'll recommend temporarily enabling the WordPress debugging and checking the server's error logs for any errors or warnings.
( ref: https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/ )

Also, see if the VPS server is configured to meet the minimum server requirements for the Toolset plugins:
https://toolset.com/faq/making-sure-your-site-meets-the-requirements/

regards,
Waqar

April 26, 2024 at 2:55 pm #2694695

Marcel

Did you have time to check on this?

April 29, 2024 at 7:22 am #2694944

Waqar

Thank you for sharing the access details.

I've reviewed your website's existing content, Toolset elements, and settings and couldn't find anything out of place.

As a general observation, I noticed that the 'PHP max input variables' value on the server is set to '1000'.
( you can view this at WP Admin -> Tools -> Site Health -> Info -> Server )

I'll recommend increasing this to a higher value of at least 4000-5000. You can consult your hosting support team to increase that, for you.

If the hosting support team is unable to share more information about the SQL queries, you can also use a third-party plugin like 'Query Monitor', to monitor them on your own.
( ref: https://wordpress.org/plugins/query-monitor/ )

Here are some useful guides on the topic:
hidden link
hidden link

If you find any Toolset queries, slowing things down, please do let us know.

The topic ‘[Closed] Too many MySQL requests causes the site to go down’ is closed to new replies.