title: MySQL Open Files Limit
body: <p>I am tuning up my MySQL configurations, particularly on open_files_limit. I have set values in etc/security/limits.conf:</p>
  
  <pre><code>*       soft    nofile  100000
  *       hard    nofile  200000
  </code></pre>
  
  <p>then in my.cnf</p>
  
  <pre><code>[mysqld_safe]
  open_files_limit = 65535
  
  [mysqld]
  open_files_limit = 65535
  </code></pre>
  
  <p>After applying the changes I restarted my Apache2 and MySQL Services, I logged-in into MySQL and fetched the open_files_limit, the result is 100000. It is supposed to be 65535. Can anyone help me configure other values in MySQL in order to get the correct result? Thanks</p>