[mysqld]
socket = /var/lib/mysql/mysql.sock
safe-show-database
max_connections=200
connect_timeout=30
key_buffer=2048M
join_buffer=32M
innodb_file_per_table
max_allowed_packet=16M
table_cache=24576
innodb_buffer_pool_size=256M
sort_buffer=32M
record_buffer=8M
thread_cache_size=64
max_user_connections=50
concurrent_insert=2
thread_concurrency=8
myisam_sort_buffer_size=64M
query_cache_limit=2M
query_cache_size=128M
query_cache_type=1
long_query_time=2
tmp_table_size=256M
join_buffer_size=4M
read_buffer_size=4M
sort_buffer_size=4M
query_prealloc_size = 65536
query_alloc_block_size = 131072
max_heap_table_size = 256M
tmpdir=/dev/shm
collation_server=utf8_unicode_ci
character_set_server=utf8
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=32M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_bufer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout