[client] port = 9999 socket = /home/gao/mysql/data9999/mysql.sock [mysqld] # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 lower_case_table_names=1 port = 9999 socket = /home/gao/mysql/data9999/mysql.sock basedir = /home/gao/mysql datadir = /home/gao/mysql/data9999 skip-external-locking skip-name-resolve key_buffer_size = 512M thread_cache_size = 3000 max_connections = 20480 server-id = 3 #log-bin innodb_log_file_size = 4G innodb_log_buffer_size = 256M innodb_buffer_pool_size = 30G innodb_buffer_pool_instances = 1 innodb_flush_log_at_trx_commit = 0 innodb_file_per_table=1 innodb_locks_unsafe_for_binlog = 1 innodb_thread_concurrency = 64 innodb_flush_method= O_DIRECT innodb_io_capacity=600 innodb_read_io_threads=16 innodb_write_io_threads=16 innodb_support_xa=0 innodb_change_buffering=all innodb_checksum_algorithm=none innodb_doublewrite = false max_prepared_stmt_count=1048576 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M