[Phpmyadmin-devel] Solution for poor performance due to querying information_schema

Marc Delisle marc at infomarc.info
Thu Oct 16 15:02:07 CEST 2014

Madhura Jayaratne a écrit :
> On Thu, Oct 9, 2014 at 7:03 PM, Madhura Jayaratne <madhura.cj at gmail.com>
> wrote:
>> Hi Devs,
>> As a possible solution to slowness faced by database servers with
>> thousands of databases due to the usage of information_schema [1], I have
>> started working on putting back the 'DisableIS' configuration. What I did
>> so far can be found at [2]. I will update on the progress.
>> [1] https://wiki.phpmyadmin.net/pma/2014-10_Meeting#Meeting_2
>> [2] https://github.com/madhuracj/phpmyadmin/commits/DisableIS
>> I feel that the pull request [3] for this issue is ready to merge. I've
> tested on a server having more than 5000 databases with DisableIS set to
> true and the performance is quite acceptable.
> [3] https://github.com/phpmyadmin/phpmyadmin/pull/1375

Great. I suggest to merge, then you could ask J.M. for credentials on 
his test server (which points to master) with more databases (or I can 
share with Madhura the credentials that J.M. gave me).

Marc Delisle (phpMyAdmin)

More information about the Developers mailing list