'ft_min_word_len'에 해당하는 글 1건


Normally it is not recommended to change variables that control MySQL fulltext index behaviour
(such as ft_min_word_len or ft_max_word_len) but if you really need to...

MySQL config file would usually be found on Windows under C:\Windows\my.ini and on Linux under
/etc/my.cnf Edit the file and add

[mysqld]
ft_min_word_len = 3

The default value is 4 and the above will change it to 3. You can change ft_max_word_len in
the same manner:

[mysqld]
ft_max_word_len = 150

After changing the variable(s) in config file restart MySQL server and you're done. You can
then check the values in phpMyAdmin under "Show MySQL system variables" to make sure your
changes have taken place.

저작자 표시 비영리 변경 금지
신고
크리에이티브 커먼즈 라이선스
Creative Commons License

'서버관리' 카테고리의 다른 글

How Many Open Files?  (0) 2011.03.10
fam 이 무엇인가?  (0) 2011.03.09
[MYSQL] How to change ft_min_word_len variable  (0) 2011.03.09
find: missing argument to `-exec'  (0) 2011.03.07
vim 한글 인코딩 설정  (0) 2011.03.07
vi 영역 접고, 펴기  (0) 2011.03.07

WRITTEN BY
김병국
유용했던 자료를 기록해 두었습니다. 도움이 되시길~~~ Welcome! I started this blog as a way to give back to all of the other system administrators who have taught me something in the past. Writing these posts brings me a lot of enjoyment and I hope you fun

받은 트랙백이 없고 , 댓글이 없습니다.
secret