Database Query Limit Hit When Multiple Admins Using Cornerstone

Support
#1

Hi,

When training a client using the Cornerstone editor, we had 4 admins using the Cornerstone editor at once, which caused our site to go down. We have a WP package from NetFirms hosting, with a 150k per hour query limit on the database. That limit was reached, and the database disappeared, causing a Wordpress install page to appear.

I believe the install page has to do with the host, but I’m unsure how to replicate or test this issue in a way that we can confirm the issue has been resolved.

Several other posts did suggest raising the PHP limit, but I am unsure if this the same as a database query limit.

Has this issue been raised before, and would changing the PHP memory limit have any effect on the database query limit? The host, of course, said nothing could be done on their end to increase the database query limit, or do much of anything else.

Until this, we had no issues with the editor in any capacity.

Happy to provide credentials to confirm any settings needing to feel confident this is resolved.

Thanks!

#2

Hello There,

Thanks for writing in! This issue is somehow tied up to your hosting features and limitations. Please review this WordPress tips how you may optimize your site especially if you have have high traffic or server queries going on at any given span of time. Please check this out: https://codex.wordpress.org/High_Traffic_Tips_For_WordPress

Hope this helps.

#3

Can you confirm that the Cornerstone page builder does query the database frequently while a page is being updated and could be contributing to us hitting our host’s db query maximum?

Also, can you recommend a tool that would allow us to capture and review the database queries that are being run while we’re updating pages with Cornerstone? I’ve tried using the Query Monitor plugin, but that doesn’t seem to report AJAX-based db queries, which I suspect are running as the page is being updated.

What’s most surprising to us is that we’re running into our host’s db query limit with only 1 or 2 admins updating pages - the site isn’t even live and receiving public visitors yet.

Have any other users run into this issue before?

Thank you.

#4

Hi there,

I don’t see any issue like this from other hosts, which I think your host limit is just too low. Are you on shared hosting?

Any plugin or theme could do a database query, and it’s done by Wordpress (plugins and theme only use the resources provided by Wordpress).

Example, what cornerstone need is to pull the post_meta needed to generate cornerstone preview (read query), then another database query when it saves it (update query). But yes, every action you did as user will always trigger queries (even by just loading a page, widget, etc.), which reflects on how many queries you’re doing, but if your host is going to limit you because of that then that also means you shouldn’t do anything at all :frowning: You should check another host :slight_smile:

You can also try cache plugin that offers object and database caching, that should at least lessen database queries.

Thanks!