title: MySQL my.cnf -- open-files-limit causing CPU Overload
body: <p>I got this server <strong>Intel Xeon Quadcore E3-1230v2 with 8GBs of DDR3 RAM</strong> Round the clock I see that this server is running out of CPU. It looks badly overloaded. After observing "<em>Daily Process Log</em>" I realized that below process is eating 25% of the CPU resources &amp; there were three such processes (technically errors). Below is the process (error):</p>
  
  <blockquote>
    <p>/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --log-error/var/lib/mysql/server.yacart.com.err --<strong>open-files-limit16384</strong> --pid-file/var/lib/mysql/server.yacart.com.pid</p>
  </blockquote>
  
  <p>As visible in the above error, It appears something is wrong with <strong>open-files-limit16384</strong>, I tried increasing open-files-limit in my.cnf to 16384 but in vain. Below is how my my.cnf now looks like:</p>
  
  <pre><code>[mysqld]  
  innodb_file_per_table=1  
  local-infile=0  
  open_files_limit=9978
  </code></pre>
  
  <p>Can anyone advise me a good configuration for my my.cnf ? Which would help me get rid of CPU overload?</p>
  
  <p>There is a GoogleBot like robot script I am running in slave servers to mine data from internet. Its crawling the entire internet. When I shutdown this script, everything gets in order. I wonder if there is a fix I could apply to this script?</p>
  
  <p>This robot program has got about 40 databases, each with a size of 50 - 800 MBs, total DB size of about 14 GBs so far &amp; I expect this to shoot upto 500 GBs in future. At one point (whole day long) only ONE DB is used. Next day, I use next DB &amp; so on. I was thinking of increasing RAM once the biggest DB reaches 2 GBs. Currently RAM does not seem to be an issue at all.</p>
  
  <p>Thanks in advance for any help you guys can offer.</p>
  
  <p>regards,</p>
  
  <p>Sam</p>