For small websites or not so popular WordPress blogs a small VPS with only 256MB of RAM should be enough. If you’ve followed this guide to install a Ubuntu web server you need to optimize your server a little bit.
Start installing MySQLtuner
Download the Perl script to your (admin) home directory:
wget http://mysqltuner.pl/mysqltuner.pl
Create also a file nano .my.cnf
and add this code:
[client] user=someusername pass=thatuserspassword
After running MySQLtuner script perl mysqltuner.pl
you should get this warning:
Reduce your overall MySQL memory footprint for system stability
To resolve this an other memory related issues we need to optimize the MySQL database settings. Continue reading Optimize Apache and MySQL for a 256MB VPS