MySQL

From JoeHacker
Jump to: navigation, search

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.