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