MySQL: Difference between revisions
From JoeHacker
(Created page with 'Hacks for mysql Set the fulltext search length. edit /etc/mysql/conf.d/min_word_size.cnf [mysqld] ft_min_word_len=2') |
No edit summary |
||
| Line 6: | Line 6: | ||
[mysqld] | [mysqld] | ||
ft_min_word_len=2 | 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. | |||
# [http://rackerhacker.com/mysqltuner/ mysqltuner.pl] | |||
# [http://www.day32.com/MySQL/ tuning-primer.sh] | |||
# [http://www.phpmyadmin.net/home_page/index.php 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. | |||
Latest revision as of 08:21, 28 November 2009
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.
