In order to avoid databases crashes or overloads. Which is the ideal configuration of the my.cnf file of the mysql database, for 256 or 512Mb memory sizes hostings running Ubuntu,
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!
Read this post http://digitaloceanvps.blogspot.com/2014/04/best-configuration-for-512mb-1gb-ram.html <br> <br>it works well with my 512mb vps using wordpress
And do not forget about
[mysqld]
performance_schema = OFF
Seems, like starting from 5.6 it is enabled by default. And it is killer of all mem-optimizations inside 512Mb box)))
I believe joomla does include table indexes by default. <br> <br>If you already have SWAP setup and then MySQL should not be crashing out because it should first use up swap. <br> <br>How much swap space did you add and how much is being used when everything is running normally?
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.