mysql_conf.txt

#skip-name-resolve
#skip-locking
skip-external-locking
key_buffer = 384M
max_allowed_packet = 100M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
query_cache_size = 256M
thread_concurrency = 16
key_buffer_size = 16M
thread_stack = 192K
thread_cache_size = 16

innodb_data_file_path = ibdata1:2000M;ibdata2:2000M:autoextend
#innodb_log_group_home_dir = /usr/local/var/
innodb_buffer_pool_size = 4G
innodb_additional_mem_pool_size = 32M
innodb_log_file_size = 100M
innodb_thread_concurrency = 4
innodb_table_locks = 0
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

expire_logs_days        = 10
max_binlog_size         = 100M