Question

Why does phpMyAdmin is very slow on page load and login?

  • Posted December 3, 2014

Hi everybody, I just made a basic LAMP configuration on CentOS 7. So at last, I install phpMyAdmin. When I try to open my address http://my_ip_droplet/phpmyadmin the page comes very slow, about 45 seconds to show login form. So, when I insert into login form my credentials, more 50 seconds to login on phpmyadmin. Why does this slowly happens? I’m using CentOS 7 with 1Gb Ram Droplet. I don’t config any firewall yet. I just made 2Gb swap file like tutorial says and a basic LAMP. Any ideas?

Subscribe
Share

For me, with the Firefox web browser console (accessed with CTRL-SHIFT-K) on http://www.mydomain.com/phpadmin, I can see get_scripts.js (about 1Mb) takes 22 seconds to load…

I have the same problem! any idea?

I’m having the same problem… takes up 5 seconds or more to load the page or login.

is phpMyAdmin configuration file pointing to 127.0.0.1 or you used your domain name as host?

Only on phpMyAdmin.

Are you seeing these slow load times on any other web pages on this droplet or only on phpmyadmin?


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

While I came here looking for something similar, I can give you some pointers:

  • PHPMyAdmin’s file layout is highly inefficient on the network level, latency impact is huge for remote servers. A couple of seconds or more loading time is completely normal over long paths. If you’re far from your server, check out “adminer”. It’s less luxurious, but as fast as it gets.
  • PHPMyAdmin automatically performs certain queries on certain pages. Some of these might simply be very slow within your database layout. Though this only applies to very large databases.

david: That would be 46kb/s on average, which really isn’t that slow for an http connection over a long path. Bandwidth isn’t as clear cut as people think; latency and ramp up time play a big role especially with http. If you’re next to the server that’d indeed be strange.