I tried using strace, but there is just too much output:
strace $(pidof "php-fpm" | sed 's/([0-9]*)/-p \1/g')
Running phpMyAdmin 4.2.0 with libmysql - mysqlnd 5.0.10 and MySQL 5.6.17. PHP version 5.4.28 using nginx. Loading the dashboard page takes literally takes over 20 seconds. Even refreshing it. All the rest of the pages inside of phpMyAdmin are fine though.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Making a copy of a simple EZPublish database in version 4.1.14 less than 30 seconds.
In version 4.2.1 nearly 5 minutes. I had to increase the maximum execution time for php scripts.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have lots of databases in our DB instance > 3000. Perhaps phpMyAdmin changed some of the logic in the dashboard (after login) to pull information from each database, causing the slowdown?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i notices it uses information schema even if expanding one database?? why not use show tables that is 100x faster? it scans through all databases every time
also can i turn off routines in database free? it slows down too. it ok to have routines only in right page
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Any update of fix for this? Running the latest version 4.2.6 but loading after logging in takes around 30 seconds. We are approaching 4,000 databases now.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
@freeman, I already have a script to generate databases and tables; what I would like is a script to generate grants (privileges) that are representative of your situation.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I guess it just is connected to number of db. I usually use root user, I need to see all databases (about 5000). On notebook with few databases it's fine (even with unnecesary db tree refreshes as I said earlier)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We also only use root which has access to all databases (secured with iptables). After log-in form, takes like 20-30 seconds to load the index (dashboard). The load on php-fpm during this time is nearly 100%.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Also, confirm its using near 100% cpu in the php-fpm worker during this time.
Hi,
I cannot reproduce this problem. Please describe your server environment (MySQL server version, PHP version).
Also, please try on http://demo.phpmyadmin.net (stable version) as this server is also using FPM.
Last edit: Marc Delisle 2014-05-10
I tried using strace, but there is just too much output:
strace $(pidof "php-fpm" | sed 's/([0-9]*)/-p \1/g')
Running phpMyAdmin 4.2.0 with libmysql - mysqlnd 5.0.10 and MySQL 5.6.17. PHP version 5.4.28 using nginx. Loading the dashboard page takes literally takes over 20 seconds. Even refreshing it. All the rest of the pages inside of phpMyAdmin are fine though.
Actually managed to see, a ton of the following:
sendto(12, "|\0\0\0\3SELECT COUNT() FROM `phpmy"..., 128, MSG_DONTWAIT, NULL, 0) = 128
poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
recvfrom(12, "\1\0\0\1\1\36\0\0\2\3def\0\0\0\10COUNT()\0\f?\0\25\0\0"..., 64, MSG_DONTWAIT, NULL, NULL) = 63
Looks like selecting from the phpMyAdmin database, a lot of times. Thousands.
Making a copy of a simple EZPublish database in version 4.1.14 less than 30 seconds.
In version 4.2.1 nearly 5 minutes. I had to increase the maximum execution time for php scripts.
We have lots of databases in our DB instance > 3000. Perhaps phpMyAdmin changed some of the logic in the dashboard (after login) to pull information from each database, causing the slowdown?
Yes
it's really slow for me too. I have also 5000 databases
i notices it uses information schema even if expanding one database?? why not use show tables that is 100x faster? it scans through all databases every time
also can i turn off routines in database free? it slows down too. it ok to have routines only in right page
any response? this is serious bug
At the moment we also do not upgrade to 4.2.x because of that bug.
We are in the process of installing a test server to be able to reproduce this problem and prepare the correct fix.
Any update of fix for this? Running the latest version 4.2.6 but loading after logging in takes around 30 seconds. We are approaching 4,000 databases now.
Sorry, still waiting for the person in charge of setting up a test server.
you can write a script to generate databases in 15 minutes. can you test it on your notebook? thanks
also navigation frame reloads sometimes for no reason
it happened now when i clicked edit rows button
it reloads navigation frame when deleting triggers and trigger node is NOT expanded, so it's not needed
Last edit: freeman 2014-07-24
Any update on this? phpMyAdmin is almost unusable with a lot of databases.
@freeman, I already have a script to generate databases and tables; what I would like is a script to generate grants (privileges) that are representative of your situation.
Marc,
Our setup is mainly 1 user per database, so simply could do something like:
http://public.recipes/z5D1CQ
Note, I did not test this, but the idea should be right.
To all,
does the slow behavior happen for every user, or just for a user having access to all of these databases?
I guess it just is connected to number of db. I usually use root user, I need to see all databases (about 5000). On notebook with few databases it's fine (even with unnecesary db tree refreshes as I said earlier)
Please tell me what happens in terms of delays, for a non-root user connecting to the server with about 5000 databases.
We also only use root which has access to all databases (secured with iptables). After log-in form, takes like 20-30 seconds to load the index (dashboard). The load on php-fpm during this time is nearly 100%.
Justin, how does it perform for a non-root user?