Question

WP admin page really slow

Posted March 26, 2020 106 views
DigitalOcean Managed MySQL Database

Hi, I have tried few times, and the same issue always presist when on DO.

my setup is, I have DO 2CPU/4G server running Nginx, and with managed Mysql 1G/2CPU for database.

I had the similar setup with exactly same wordpress install, same plugin, same DB on Linode which run 2CPU/4G for web server, and 1CPU/2G for mysql server.

the issue which i am facing right now is, whenever i moved back to DO with managed mysql instance, the wordpress admin page is loading really slow, and especially when open posts, or bulk saving posts. I can easily save 100 posts with no issue when the same setup in Linode, but always timed out in DO because just slow.

I noticed people is reporting the similar issue on this post: https://www.digitalocean.com/community/questions/wordpress-admin-loading-slow-publishing-saving-post-too

I must say, this is not a plugin issue, and the exactly same install ( i used rsync to move in between ) are working fine under Linode.

I like the managed DB, but i really want could be wrong here.

Andy

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.

×
1 answer

I am no expert, but I can see the managed databases use MySQL version 8, which after googling a bit seems to have issues in the case of WordPress specifically.

Have you tried with a regular MySQL server 5.6 or 5.7?

  • Hi Tony, Thank you.

    actually, when i was using Linode with regular mysql. I was using version 8 which has no issue for wordpress.

    so, not entirely sure if the version 8 is the problem, but definitely the managed mysql is making alot different compare with self hosted.

    also, the funny part is, the frontend wordpress seems not impacted at all, and issue only happened in the wp-admin backend process. I am really confused.

    Andy

Submit an Answer