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

[Madhura Jayaratne]

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

-- 
Thanks and Regards,

Madhura Jayaratne
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20141016/8730b17f/attachment.html>