MySQL

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.

1. mysqltuner.pl
2. tuning-primer.sh
3. 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.