title: difference between opened files and open files in mysql
body: <p>In the below status i have opened files count to be '95349'.
  this value is increasing rapidly.</p>
  <p>mysql&gt; <code>show global status like 'open_%';</code></p>
  <p><strong>Open_files               = 721</strong></p>
  <p>Open_streams             = 0</p>
  <p>Open_table_definitions   = 706</p>
  <p>Open_tables              = 741</p>
  <p><strong>Opened_files             = 95349</strong></p>
  <p>Opened_table_definitions = 701</p>
  <p>Opened_tables            = 2851</p>
  <p>also see this.</p>
  <p>mysql&gt;<code>show variables like '%open%';</code></p>
  <p>have_openssl      = DISABLED</p>
  <p>innodb_open_files = 300</p>
  <p><strong>open_files_limit  = 8502</strong></p>
  <p>table_open_cache  = 4096</p>
  <p>and</p>
  <p>max_connection  = 300</p>
  <p>is there any relation to open files and opened files. will there be any performance issues because of increasing opened_files value. This is a server of 8 GD RAM and 500 GB hardisk with processor: Intel(R) Xeon(R) CPU E3-1220 V2 @ 3.10GHz. It is a dedicated mysql server.</p>
  <p>here for the command</p>
  <blockquote>
  <p>ulimit -n;</p>
  </blockquote>
  <p>1024 was the count</p>
  <p>the server is hanging often. using some online tools i have optimised some parameters already. need to know what else should be optimized ? in what case the opened files count will reduce? is it necessary that opened files count should be with in some limit. if so how to find the appropriate limit for my server. if am not clear some where please help me by asking more questions.</p>