Re: Need Help with Fulltext Min_Word_Len AND resetting the Query Cache ???

[Ingo Strüwing]

1. See http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html and http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

SET GLOBAL ft_min_word_len=3; should do the trick. You need SUPER privilege.

Note: FULLTEXT indexes must be rebuilt after changing this variable. Use REPAIR TABLE tbl_name QUICK.

2. See http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html

SET GLOBAL query_cache_size = 0; should do the trick. You need SUPER privilege.

Both above mentioned settings should also be doable in a configuration file.

3. Regarding the compressed tables I don't know a general answer. I suspect it depends on your data and queries as well as on the CPU power to disk performance relationship. I have too little experience in performance questions. I suggest to benchmark it yourself with your application.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com