rendered paste body[mysqld]
query_cache_limit=8M
query_cache_size=64M
query_cache_type=1
max_connections=900
interactive_timeout=60
wait_timeout=90
connect_timeout=30
thread_cache_size=256
key_buffer=32M
join_buffer=2M
max_allowed_packet=32M
table_cache=4096
record_buffer=2M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size = 4M
max_connect_errors=90
myisam_sort_buffer_size=64M
#log-bin
thread_concurrency = 4
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/db/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/db/mysql/innodblogs/
innodb_log_arch_dir = /var/db/mysql/innodblogsarchive/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 32M
innodb_additional_mem_pool_size = 10M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 24M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50