asked on

Advice on my.cnf

Hello,

Im tweaking my.cnf for a HEAVY traffic website, im pasting the code below, any advices on it?

Server:
CPU E5310 (dual quad core, 8cpu)
8GB RAM
Using CentOS and Mysql5

[mysqld]
skip-locking
skip-innodb
max_connections = 2500
key_buffer = 256M
max_allowed_packet = 8M
table_cache = 2048
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 32M
thread_cache_size = 256
query_cache_size = 128M
query_cache_type = 1
query_cache_limit= 1M
thread_concurrency= 16
wait_timeout=20
interactive_timeout=10
connect_timeout=10
join_buffer=1M
 
[mysqldump]
quick
max_allowed_packet = 16M
 
[mysql]
no-auto-rehash
 
[usamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
 
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

Open in new window

Umesh

Is this server dedicated to MySQL?

I see MySQL's minimum required memory for this my.cnf is 10256MB(10GB) and you have 8GB RAM.. don't you think max_connection is too high?

epagos7

ASKER

no, its not mysql dedicated, the server also acts as HTTP server.

Ive increased Max connections to that number because i got a lot of rejected mysql connections in the past, should i lower it?

Umesh

If its not dedicated then the way you have assigned the memory to MySQL parameters is dangerous..

I suggest you to run MySQL tuner script and see what it suggest

http://wiki.mysqltuner.com/MySQLTuner

epagos7

ASKER

i just executed that perl script, it seems my query efficiency is 0% since its not using any cache... how can i make mysql to read from cache?

epagos7

ASKER

i forgot, a LOT of the Selects that the script is making to mysql have always the same result, so i assume caching wont be a problem

epagos7

ASKER

Also i see: 'Connections Aborted: 27%'

ASKER CERTIFIED SOLUTION

Umesh

membership