Skip Navigation

[Resolved] mysqld_slowquery

This support ticket is created 5 years, 7 months ago. There's a good chance that you are reading advice that it now obsolete.

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
8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 - -
13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 - -

Supporter timezone: America/New_York (GMT-04:00)

Tagged: 

This topic contains 6 replies, has 2 voices.

Last updated by Christian Cox 5 years, 7 months ago.

Assisted by: Christian Cox.

Author
Posts
#1225813

I am trying to: use the plugin on a multisite

Link to a page where the issue can be seen:
in the error logs we are seeing a lot of mysql_slowquery errors like

Query_time: 2.856827 Lock_time: 0.000049 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0
# Bytes_sent: 184
SET timestamp=1554382857;
SHOW TABLES LIKE 'wpsites_62_toolset_associations';

Query_time: 2.130332 Lock_time: 0.000046 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0
# Bytes_sent: 180
SET timestamp=1554382857;
SHOW TABLES LIKE 'wpsites_182_toolset_type_sets';

they burst about 12 at a time every second and make everything run slow

I expected to see:
not errors

Instead, I got:

errors

#1225977

Hi, do you have a multisite staging environment set up where we can run tests without affecting the live site? We'll need to be able to turn plugins on and off, apply a default theme, update your Toolset plugins, and so on to pin down the issue. We have a couple of performance tickets open that address similar issues, so this may be another report of the same problem.

#1226506

Christian, we are not seeing the issue on or dev box, so cannot do your test unfortunately. I've narrowed it down to being something that is happening while an author or admin is editing a page. Seems to happen once, then slowly picks up while the user is sitting on the edit page. at about 3 - 5 minutes we get a disconnect.

wpdb->prefix . toolset_relationships
wpdb->prefix . toolset_type_sets
wpdb->prefix . toolset_associations
wpdb->prefix . toolset_post_guid_id

#1226507

the above are the tables that are being called in those slow queries

#1227363

Well hmm, if I can't replicate the problem on a controlled environment I can't escalate it to my 2nd tier support team for additional investigation. So that's a bit of a disappointment. Instead, I can link this ticket to the work that is being done for the other performance issue with similar messages, and update you when the fix is available for those issues. Or we can try to replicate the problem on a few other multisite setups and see if we have more luck there.

#1227391

It might be important to mention: we have about 1000 sub-sites in that database. We also have a couple of plugins that create their own tables, like the toolset plugs. are you able to test against a large set like that?

#1227897

If the problem is replicable on another box, I can test on any multisite setup you create. But it should really match your production site as closely as possible to ensure we're fixing the right problem. To test, I need SSH access to the server, wp-admin superadmin access, and the ability to turn plugins and themes on and off as needed.