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
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.
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
the above are the tables that are being called in those slow queries
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.
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?
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.
