title: my.cnf MySQL perfomance for 5GB MYISAM table
body: <p>I Have a dedicated server -  Intel Xeon L5320 with 8GB of RAM and 2 x 500GB 7200RMP HDD </p>
  
  <p>I need to optimize mysql to cope with a large 5Gb MyISAM table + around 25 - 30 smaller databases currently it looks like this:</p>
  
  <pre><code>key_buffer = 3G
  thread_cache_size = 16
  table_cache = 8192
  query_cache_size = 512M
  </code></pre>
  
  <p>As it is the server really struggles and I get continues tmp disk full warnings could you please help me out / suggest the best my.cnf configuration for my server and or any other settings changes that would improve performance.</p>
  
  <p>Thanks in advance</p>