title: mysql ft_min_word_len change on ubuntu does not work
body: <p>I am trying to implement the full test search. And for this the first thing I did change the value of <code>ft_min_word_len = 2</code> on /etc/mysql/my.cnf as</p>
  
  <pre><code>[mysqld]
  #
  # * Basic Settings
  #
  
  #
  # * IMPORTANT
  #   If you make changes to these settings and your system uses apparmor, you may
  #   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
  #
  ft_min_word_len = 2
  </code></pre>
  
  <p>Now Saved that and restarted the server.
  I am aware that if I already have an index with FULLTEXT in a table I will need to drop the indexes and rebuilt, or repair the table.
  But I have created the table as </p>
  
  <pre><code>create table 
  `comments` 
  (   `id` int(11), 
      `comment` varchar(200), 
      `iduser` int(11) , 
      `date_added` datetime
  ) 
  ENGINE=MyISAM;
  
  ALTER TABLE comments
  ADD FULLTEXT INDEX comment_index
  (comment);
  </code></pre>
  
  <p>Then in the above table I have some comments added manually. </p>
  
  <p>When I try to search something as </p>
  
  <pre><code>SELECT * FROM comments where MATCH (comment) AGAINST ('the') ; // "the" is very common word of length to see my test result
  </code></pre>
  
  <p>It returns 0 rows.</p>
  
  <p>However if I set AGAINST with a word length of 4 it works.</p>
  
  <p>I tried to check the ft_ variables as </p>
  
  <pre><code>mysql&gt;  show variables like 'ft_%';
  +--------------------------+----------------+
  | Variable_name            | Value          |
  +--------------------------+----------------+
  | ft_boolean_syntax        | + -&gt;&lt;()~*:""&amp;| |
  | ft_max_word_len          | 84             |
  | ft_min_word_len          | 2              |
  | ft_query_expansion_limit | 20             |
  | ft_stopword_file         | (built-in)     |
  +--------------------------+----------------+
  </code></pre>
  
  <p>Interesting thing is in <code>/etc/mysql/my.cnf</code> I can only see <code>ft_min_word_len</code> but the <code>ft_max_word_len</code> is not there and more importantly the search less than length 4 does not work atall.</p>
  
  <p>This is making me crazy and not sure if there is some other config which is over writing everything and seems like not able locate them either.</p>
  
  <p>Any help would be appreciated. </p>
  
  <p>Mysql Version in my development machine is </p>
  
  <pre><code>mysql  Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (i686) using readline 6.2  
  </code></pre>