Optimize Apache and MySQL for a 256MB VPS
September 1, 2011 at 7:09 am Tags:apache | mysqltuner | prefork | ubuntu | vps
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. Read More…





