9 Oct
2014
9 Oct
'14
4:33 p.m.
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
--
Thanks and Regards,
Madhura Jayaratne
16 Oct
16 Oct
3:34 p.m.
New subject: [Phpmyadmin-devel] Solution for poor performance due to querying information_schema
On Thu, Oct 9, 2014 at 7:03 PM, Madhura Jayaratne <madhura.cj(a)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
4:02 p.m.
New subject: [Phpmyadmin-devel] Solution for poor performance due to querying information_schema
Madhura Jayaratne a écrit :
On Thu, Oct 9, 2014 at 7:03 PM, Madhura Jayaratne
<madhura.cj(a)gmail.com>
wrote:
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)
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
4:19 p.m.
New subject: [Phpmyadmin-devel] Solution for poor performance due to querying information_schema
On Thu, Oct 16, 2014 at 6:32 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Madhura Jayaratne a écrit :
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).
Done.
--
Thanks and Regards,
Madhura Jayaratne
On Thu, Oct 9, 2014 at 7:03 PM, Madhura Jayaratne
<madhura.cj(a)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
3623
days inactive
3630
days old
3 comments
2 participants
participants (2)
-
Madhura Jayaratne -
Marc Delisle