MySQL
From JoeHacker
Hacks for mysql
Set the fulltext search length.
edit /etc/mysql/conf.d/min_word_size.cnf
[mysqld] ft_min_word_len=2
Tuning
There are a couple of good tuning tools for mysql. These tools are not 100%, but they can help you configure your instance of mysql to work better.
- mysqltuner.pl
- tuning-primer.sh
- phpmyadmin - The Status Tab contains a lot of information on your server and it will put variables in Red that may need to be optimized.