[Phpmyadmin-devel] testing master on a server with many databases

Madhura Jayaratne madhura.cj at gmail.com
Mon Oct 20 11:31:17 CEST 2014


On Sun, Oct 19, 2014 at 5:34 PM, Marc Delisle <marc at infomarc.info> wrote:

> Hi,
>
> With current master (8785ea0) I made some tests on a MySQL 5.5.37 server
> containing about 81000 databases and about 81000 users.
>
> In the mysql.db tables there are about 81000 grant entries; each one
> grants some wildcard access to databases starting with a certain pattern.
>
> I tested with root, since the reports we got about the server being slow
> seem to be occurring for root.
>
> Good news
> ---------
>
> First, the login. It takes about 7 seconds before seeing the initial
> page after login.
>
> In the navi panel, there is a db page selector with 107 page numbers.
> Going to any page takes about 7 seconds. Opening a db takes about 4
> second (each db seems to contain about 31 tables).
>
> Browsing tables, grid editing, searching inside a table behave normally.
>
> Using Server > Databases works correctly, including switching pages.
>
>
> Problems
> --------
>
> Going to a MyISAM table, Structure, and trying to change a column's
> structure takes 30 seconds before seeing the dialog for this column.
> Switching this table to InnoDB does not help.
>
> Database filter: I got mixed results. Sometimes it works (after about 10
> seconds) but sometimes it stalls and does not find anything. I could not
> find a consistent way to reproduce.
>

There was a UI problem which caused the throbber to be removed before
searching has finished and I suspect the above problem is due to that. The
problem is fixed with [1]. Can you try with again with the commit.

[1]
https://github.com/phpmyadmin/phpmyadmin/commit/d2aec03f2b0ef8bfc8d45fe582b9580ce14bf29f


-- 
Thanks and Regards,

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


More information about the Developers mailing list