Question

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

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?

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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.