Developers require database access to a significant number of databases, each with 220+ tables, and currently they are provided this using phpMyAdmin 18.104.22.168. Initial load is very slow, puts some load on the database cluster beneath, and runs lots of (needless)
SHOW TABLES FROM x queries to gather data for every table in every datbase. Developers do not require this information in the left hand navigation pane, however this information is still required when they select that database.
There are various options available for configuring the installation, however none of them are obviously tailored to handle a colossal number of databases.
Can anybody recommend options on tuning phpMyAdmin to deal with many tables (
$cfg['ShowStats'] = false;is the only obvious one)?
Is there any equivalent to phpMyAdmin tailored to very large deployments? Perhaps caching table meta data (there are memcached instances available) or not outputting such verbose information?
Does phpMyAdmin 22.214.171.124 suffer the same sluggish performance? Upgrading is a possibility.