[Phpmyadmin-devel] mysql.host is obsolete

[Marc Delisle]

Michal Čihař a écrit :
> Hi
> 
> Dne Wed, 26 Feb 2014 05:37:23 -0500
> Marc Delisle <marc at infomarc.info> napsal(a):
> 
>> We have at least one bug report active, from a user who has poor
>> performance with a huge number of databases / tables. He suggests to
>> reinstate the SHOW DATABASES logic.
> 
> I guess you mean bug #4243 [1]. In this case, I'd rather use the UNION
> select he suggests than going back to the SHOW DATABASES...
> 
> [1]: https://sourceforge.net/p/phpmyadmin/bugs/4243/

Agreed for this case, so feel free to merge your pull requests.

In the long term, I expect that all performance problems of 
information_schema will disappear (or at least that SHOW DATABASES is 
not faster...).

In bug #4243 the user is running MySQL 5.5. The last feedback I got from 
the admin of db4free.net is that he could not trigger information_schema 
performance problems, but he was running MySQL 5.6.


-- 
Marc Delisle
http://infomarc.info | http://phpmyadmin.net