Revise my.cnf for best performance

MySQL & MariaDB Other MySQL® Questions
1

Hi all,

Hi have a website with a MyIsam Database with 10 millon records, and 50 tables.

I have an Avg of 600 query by second.

My server is a 2 x Opteron 2352(2 x 4 x 2,1 GHz) with 16 GB ram

This is my.cnf file:

[mysqld]
set-variable=local-infile=0
set-variable=max_connections=600
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
long_query_time = 1
thread_cache_size = 50
log-slow-queries = /var/log/mysql-slow.log
query_cache_type = 1
query_cache_size = 26214400
key_buffer_size = 1500M
table_cache = 400
sort_buffer_size=4M
read_buffer_size=1M

You change any?

Thanks!!!
Giro.

2

There is no general best my.cnf for your hardware. Let someone look at it if you have performance issues. Pm me if interested, or hire someone from percona.