Michal Čihař a écrit :
Hi
Dne Wed, 26 Feb 2014 05:37:23 -0500
Marc Delisle <marc(a)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