We've got several hundred InnoDB tables in a database, and we use phpMyAdmin to manage them. Unfortunately, phpMyAdmin does a
SHOW TABLE STATUS query whenever the list of tables is shown, and this seems to dig into each InnoDB table to get an approximate row count.
This seems to lock up the entire database, which subsequently means all other queries to this (busy) database all queue up until the database hits the max users.
SHOW TABLE STATUSbe sped up in a reasonable manner?
- Can phpMyAdmin be easily modified to not do a full
SHOW TABLE STATUSquery, or at least not lock the entire database at once for it?