By agencia82
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?
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!
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.