[Phpmyadmin-devel] Solution for poor performance due to querying information_schema
madhura.cj at gmail.com
Thu Oct 16 15:19:45 CEST 2014
On Thu, Oct 16, 2014 at 6:32 PM, Marc Delisle <marc at infomarc.info> wrote:
> 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 , I
> >> started working on putting back the 'DisableIS' configuration. What I
> >> so far can be found at . I will update on the progress.
> >>  https://wiki.phpmyadmin.net/pma/2014-10_Meeting#Meeting_2
> >>  https://github.com/madhuracj/phpmyadmin/commits/DisableIS
> >> I feel that the pull request  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.
> >  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).
Thanks and Regards,
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Developers