Schema upgrade check crashes large multisites

Get Help
,
1

I would post this as a support ticket but I don’t have a GF licence.

I work for a managed WordPress host and we are seeing the schema upgrade check which runs a “SHOW TABLES LIKE” query on every uncached request inside GFWebAPI::requires_schema_upgrade(). This causes large multisites (some of which have many thousands of tables) to run many slow mysql queries at once and then affect all of the sites in the multisite network.

I just wanted to pass this onto your dev team in case it’s useful info for future versions.

2

A less expensive query would be to convert it to SELECT TABLE_NAME AS name FROM information_schema.tables WHERE TABLE_NAME = if that helps.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.