here is what i am planning on going to for the next reboot:
[mysqld]
socket=/var/lib/mysql/mysql.sock
skip-innodb
skip-locking
set-variable = max_connections=128
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=2M
set-variable = record_buffer=2M
set-variable = sort_buffer=4M
set-variable = table_cache=256
set-variable = thread_cache_size=32
set-variable = thread_stack=128K
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=4M
set-variable = write_buffer=4M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=4M
set-variable = write_buffer=4M
less max_connections because i am not getting over 100.
less table_cache because i'm not getting that many open.
halve the threads because i rarely see more than 30 open.
however, i will double each threads stack size.
double the size of the record,join and sort buffers to maybe not create temp tables.
thoughts?
