[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer = 4096M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 48M
init_connect = 'SET collation_connection = utf8_general_ci' 
init_connect = 'SET NAMES utf8' 
default-character-set = utf8
character-set-server = utf8 
collation-server = utf8_general_ci 
thread_concurrency = 8
log-slow-queries=/var/lib/mysql/mysqld-slow.log
max_connections = 500
thread_cache = 256
wait_timeout = 60
net_read_timeout = 120
net_write_timeout = 120
log-bin=/var/lib/mysql/binlog
expire_logs_days = 3
skip-bdb
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:1024M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 64M
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_file_per_table
innodb_open_files=1024