title: Cannot set limit of MySQL open-files-limit from 1024 to 65535
body: <p>I have mysql ver. 5.1.49-3, I am working on linux debian. I am trying to set open-files-limit to 65535. so I edited te my.cnf in /etc/mysql/ </p>
  
  <pre><code>[mysqld]
  open_files_limit = 65535
  [mysqld_safe]
  open_files_limit = 65535
  </code></pre>
  
  <p>then in /etc/security/limit.conf</p>
  
  <pre><code>*   soft    nofile  100000
  *   hard    nofile  200000
  </code></pre>
  
  <p>After restarting mysql service, when I run this command in linux </p>
  
  <pre><code>ps -ef|grep mysql
  </code></pre>
  
  <p>I got 65535. when I log into mysql as root and fetch the value of open-files-limit</p>
  
  <pre><code>show global variables like "%open_files_limit%";
  </code></pre>
  
  <p>I got 1024. Please help. </p>