By Moin Shaikh
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 ,
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!
This comment has been deleted
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
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
Hope that this helps!
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.