[client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysql] no-auto-rehash #safe-updates prompt = '\u@\h>' # also can use utf8mb4 default_character_set = utf8 [mysqld] datadir = /var/lib/mysql port = 3306 socket = /var/lib/mysql/mysql.sock skip-external-locking key_buffer = 32M max_allowed_packet = 8M table_open_cache = 256 max_connections = 1024 max_connect_errors = 10000 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 1M thread_cache_size = 256 query_cache_size = 0M query_cache_type = 0 thread_concurrency = 8 tmp_table_size = 64M max_heap_table_size = 64M skip-name-resolve # also can use utf8mb4 character-set-server=utf8 default-storage-engine=InnoDB log-bin=mysql-bin relay-log=relay-mysql-bin binlog_format=mixed log_slave_updates replicate-ignore-db=mysql slow_query_log = 1 long_query_time = 3 log_slow_slave_statements = 1 server-id = innodb_strict_mode innodb_data_file_path = ibdata1:10M:autoextend innodb_data_home_dir = /var/lib/mysql innodb_file_format = Barracuda innodb_file_per_table innodb_buffer_pool_size = 10G innodb_additional_mem_pool_size = 20M innodb_write_io_threads = 8 innodb_read_io_threads = 8 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 128M innodb_log_buffer_size = 16M innodb_log_files_in_group = 2 innodb_flush_method=O_DIRECT innodb_lock_wait_timeout = 120 loose-innodb_large_prefix = 1 loose-innodb_print_all_deadlocks = 1 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 8M sort_buffer_size = 8M read_buffer = 1M write_buffer = 0M [mysqld_safe] open-files-limit = 8192