I had some WordPress performance issues over the weekend. The website was performing so poorly that connections timed out. I traced the problem to some changes I made in the MySQL configuration. I want to spend more time learning about that so that I can find tune thing. To recover, I created a new Digital Ocean VPS and copied the default MySQL configuration to my VPS. The website performance returned.
By the time I had things squared away, my mind was soon in tweaker mode, so I made sure APCu Object Cache for PHP7 was installed, then I installed and configured the WP LCache and W3 Total Cache plugins.
There are still some issues I want to work on fixing:
- render-blocking CSS and JavaScript
- MySQL read performance
John Saddington
10th April 2019 at 9:04 AMhere's how long it took to load your site from a link via email and then for a comment to register and load: https://www.dropbox.com/s/bgc1kkld0usr6dt/test.mp4?dl=0
you can still tell it's a bit slow...
Khürt Williams
10th April 2019 at 11:54 AMThanks John. I wonder if that is a function of MySQL or Apache. I'll keep at it. I am using a Ubuntu 18.04 Digital Ocean droplet with 2 vCPUs
4GB / 50GB Disk.
John Saddington
10th April 2019 at 9:02 AMThis is a quick comment test...