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

December 3, 2014 11.2k views

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?

1 Answer

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.

Have another answer? Share your knowledge.