title: Optimal my.cnf recommendation
body: <p>I'd like to ask anyone with a bit of experience on an opinion of my current <code>my.cnf</code> settings and what optimizations should be done.</p>
  
  <p>Server specs are:</p>
  
  <ul>
  <li>CPU: AMD Opteron™ 3280, 8 Cores, 8x 2.4 GHz</li>
  <li>RAM: 16 GB DDR3</li>
  <li>2x 2,000 GB SATA II-HDD, 7.2k - RAID 1 Software</li>
  <li>Cloudlinux + Cpanel installed</li>
  <li>Apache + Mysql 5.5 + NginxCP + eAccelerator</li>
  </ul>
  
  <p>The current <code>my.cnf</code> file is:</p>
  
  <pre>
  [client]
  port=3306
  socket="/var/lib/mysql/mysql.sock"
  
  [mysqld]
  innodb_additional_mem_pool_size=16M
  innodb_buffer_pool_size=10G
  innodb_file_per_table=1
  innodb_log_buffer_size=4M
  innodb_flush_log_at_trx_commit=2
  log-bin=mysql-bin
  myisam_sort_buffer_size=64M
  expire_logs_days=7
  query_cache_size=128M
  thread_cache_size=12
  max_allowed_packet=15M
  skip-federated
  table_definition_cache=2048
  local-infile=0
  table_cache=8192
  max_connections=60
  read_buffer_size=2M
  slow_query_log=1
  slow_query_log_file="/var/log/slow_queries.log"
  thread_concurrency=16
  sort_buffer_size=2M
  port=3306
  join_buffer_size=16M
  key_buffer_size=600M
  query_cache_limit=10M
  socket="/var/lib/mysql/mysql.sock"
  skip-external-locking
  query-cache-type=1
  long_query_time=5
  default-storage-engine=InnoDB
  tmp_table_size=384M
  max_heap_table_size=384M
  
  [myisamchk]
  read_buffer=2M
  key_buffer=256M
  sort_buffer_size=256M
  write_buffer=2M
  
  [mysqldump]
  max_allowed_packet=16M
  </pre>