Database Reference
In-Depth Information
We can also see the effect in the navigation panel:
Improving fetch speed
Version 3.0 introduced two configuration parameters that have an effect on the speed
of database names retrieval and table counting. The first one is
$cfg['Servers'][$i]['ShowDatabasesCommand'] = 'SHOW DATABASES';
Every time phpMyAdmin needs to obtain the list of databases from the server, it
uses the command listed in this parameter. The default command SHOW DATABASES
is fine in ordinary situations. However, on servers with many databases, speed
improvements can be observed by trying other commands like one of these:
SHOW DATABASES LIKE '#user#\_%'
SELECT DISTINCT TABLE_SCHEMA FROM information_schema.SCHEMA_
PRIVILEGES'
SELECT SCHEMA_NAME FROM information_schema.SCHEMATA
In the first example, #user# is replaced by the current username.
 
Search WWH ::




Custom Search