suggestion for speed, performance, server optimization .

Question

hi,i have a website which was 512Mb Droplet , it had 700,0000 post all imported using data feeds of products. the website database use to crash often , so i upgraded on 1Gb droplet. But the problem are still the same, website is slow takes too long to load Wordpress Admin panel more slow.*importing more products is still slow (previously it used to import 500 products in 1 minute now it takes more then 15min for it )*database crashes (before it used to crash 5 times a day ,now 2 times a day). this are some of the problems i am facing , cant afford higher droplet .being a student , i am tight on budget :( So guys please help me out by recommending best practice, solutions , plugin, advice regarding this. Thanks in advance ,

Moin Shaikh · Answer

This comment has been deleted

alexdo · Answer

Hello there,

I came across this question in 2023 and will update the answer since it’s a hot topic.

I will personally recommend to make sure that a SWAP space is added on the droplet and that the MySQL database is optimized and there is a caching (either a cache plugin or server level caching like redis)

https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-20-04

If the database is huge in size or generally busy with requests you can use the MySQL tuner script to optimize the database performance

https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mariadb-configuration-for-increased-performance-and-stability

We have a tutorial on how to optimize WordPress on Ubuntu 20.04 which you can check here

https://www.digitalocean.com/community/tutorials/how-to-optimize-wordpress-on-ubuntu-20-04

Another really useful article

https://www.digitalocean.com/community/tutorials/how-to-optimize-a-wordpress-installation-before-troubleshooting

Hope that this helps!