[Phpmyadmin-devel] Performance improvements for servers having large number of databases

Madhura Jayaratne madhura.cj at gmail.com
Mon Nov 3 08:38:19 CET 2014


Hi all,

Today morning I spent some time testing the performance improvements that
were done for the servers having a large number of databases.

My setup has about 5000 databases grouped in to database groups of 20
databases. Navigation items at first level [1] is limited to 50 meaning
that about 1000 databases are loaded in the initial page of navigation.

While loading the initial page,
QA_4_2: 1008 queries executed 1011 times in 1.00407 s
master: 12 queries executed 17 times in 0.51211s

Even though master is about 2 times faster in terms of the query execution
time, the overall time to load the page is dominated by the time taken to
render 1000 nodes in navigation, which is about 8s for master and 11s for
QA_4_2.

However the rendering time can be significantly improved by setting [1] to
a lower value, which currently defaults to 250. If I remember right, this
directive was set to a higher value to prevent navigation from having extra
spaces below [2]. Since this issue is no longer there (now when [1] is set
to, say 50, 50 databases or database groups are displayed) I suggest to set
[1] to a lower value.


[1]
http://docs.phpmyadmin.net/en/latest/config.html#cfg_FirstLevelNavigationItems
[2] https://sourceforge.net/p/phpmyadmin/mailman/message/30077320/

-- 
Thanks and Regards,

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


More information about the Developers mailing list