为“ft_min_word_len”设置新值MySQL中的FULLTEXT [英] set new value for "ft_min_word_len " FULLTEXT in mysql

问题描述

我更改为ft_min_word_len= 4 by my-innodb-heavy-4G.ini 位于我的系统路径C：\ Program Files \MySQL\MySQL Server 5.1，但是当我运行时

<$


$ b

我得到了仍然结果

SHOW VARIABLES LIKE'ft_min_word_len'
value = 4 。我在 my.ini 文件中找不到这个变量。所以我也创建了我的逻辑。我复制到 ft_min_word_len 变量并放置在 my.ini 文件中，现在我的结果显示值= 3 。

但它不适用于三个字符搜索。我已重新启动服务器。

我怎样才能够搜索到三个字符的值也是可以的。

解决方案

您应该更改此系统参数，重新启动服务器，然后重新生成所有FULLTEXT索引。

 修理表< TableName>快; 
  

• 使用MySQL更改全文索引最小字长

I changed to "ft_min_word_len" = 4 by my-innodb-heavy-4G.ini located in my system path "C:\Program Files\MySQL\MySQL Server 5.1" , but when i run

SHOW VARIABLES LIKE 'ft_min_word_len'

I got still result value= 4. I did not find this variable in my.ini file. So i have also create a my logic. I copied to ft_min_word_len variable and place in my.ini file and now my result show value=3.

But it is not working for three character search. I've restarted server.

How can i achieve to be able to search three character value also.

解决方案

You should change this system parameter, restart server and then rebuild ALL FULLTEXT indexes.

REPAIR TABLE <TableName> QUICK;

• Change the full text index minimum word length with MySQL

这篇关于为“ft_min_word_len”设置新值MySQL中的FULLTEXT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！