Webdev

In the folder: /etc/mysql/my.cnf, I set

key_buffer = 32M
query_cache_size = 32M
table_cache = 256
thread_cache_size = 16
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 5
log-queries-not-using-indexes

Restart MySQL: /etc/init.d/mysql restart

To empty a log of a running application do: echo > /var/logs/your.log

MySQLTuner-perl https://github.com/rackerhacker/MySQLTuner-perl

wget http://mysqltuner.com/mysqltuner.pl
chmod +x mysqltuner.pl
./mysqltuner.pl