[mysqld] character-set-server=utf8 port = 3306 datadir=/home/mysql/data socket=/home/mysql/mysql.sock user=mysql skip-name-resolve max_allowed_packet = 1M thread_cache_size = 32 table_cache = 1024 #thread_concurrency = 8 max_connections=256 sort_buffer_size = 4M read_buffer_size = 4M read_rnd_buffer_size = 12M myisam_sort_buffer_size = 96M key_buffer_size = 512M innodb_data_home_dir = /home/mysql/data innodb_data_file_path = ibdata1:2G;ibdata2:2G;ibdata3:10M:autoextend innodb_log_group_home_dir = /home/mysql/data innodb_buffer_pool_size = 1024M innodb_additional_mem_pool_size = 24M innodb_log_buffer_size = 4M innodb_log_file_size = 128M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 0 long_query_time=2 slow-query-log=/home/mysql/logs/slow.log [mysqld_safe] log-error=/home/mysql/logs/mysqld.log pid-file=/home/mysql/logs/mysqld.pid open-files-limit = 4096 [client] port = 3306 socket = /home/mysql/mysql.sock [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout