long_query_time         = 10
log-slow-queries        = /var/log/mysql/mysql-slow.log
socket = /var/lib/mysql/mysql.sock
safe-show-database
old-password=1
set-variable = max_connections=500
interactive_timeout=100
# ..... wait_timeout default is 600
wait_timeout=1000
connect_timeout=30
thread_cache_size=8
# ..... key_buffer default is 32M
key_buffer=256M
# ..... Join_Buffer default is 8M
join_buffer=512M
max_allowed_packet=512M
# ..... table_cache default is 1024
table_cache=1800
# ..... Sort_Buffer default is 32
sort_buffer=256M
# ..... Record_Buffer default is 8
record_buffer=64M
thread_cache_size=128
max_user_connections=100

# ..... Thread_Concurrecy default is 4
thread_concurrency=6
myisam_sort_buffer_size=64M
max_heap_table_size=256M
tmp_table_size=512M
innodb_buffer_pool_size=724M
# ..... Query_Cache_Limit default is 2M
query_cache_limit=256M
query_cache_size=64M
query_cache_type=1

[mysql.server]
user=mysql

[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 default is 64 64 16 16
[isamchk]
key_buffer=512M
sort_buffer=256M
read_buffer=64M
write_bufer=64M

# myisamchk default is 64 64 16 16
[myisamchk]
key_buffer=512M
sort_buffer=256M
read_buffer=64M
write_buffer=64M

[mysqlhotcopy]
interactive-timeout