[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysql] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqladmin] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlcheck] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqldump] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlimport] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlshow] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [myisamchk] character-sets-dir=/usr/share/mysql/charsets [myisampack] character-sets-dir=/usr/share/mysql/charsets [mysqld_safe] err-log = /var/log/mysql/mysql.err [mysqld] character-set-server = utf8 user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql skip-external-locking key_buffer_size = 16M max_allowed_packet = 60M table_open_cache = 800 sort_buffer_size = 512K net_buffer_length = 16K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M lc_messages_dir = /usr/share/mysql lc_messages = en_US bind-address = 0.0.0.0 log-bin = mysqld-bin relay-log = mysqld-relay-bin server-id = 5 sync_binlog = 1 binlog_checksum = CRC32 master_verify_checksum = 1 slave_sql_verify_checksum = 1 binlog_format = row expire_logs_days = 1 slave_parallel_threads = 20 max_connections = 1500 max_connect_errors = 500 tmp_table_size = 1G max_heap_table_size = 1G innodb_checksum_algorithm = crc32 innodb_log_checksum_algorithm = crc32 innodb_flush_method = O_DIRECT tmpdir = /tmp/ innodb_buffer_pool_size = 40000M innodb_data_file_path = ibdata1:10M:autoextend innodb_log_file_size = 48M innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_file_per_table innodb_file_format = Barracuda [mysqldump] quick max_allowed_packet = 16M [mysql] [isamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer_size = 2M write_buffer_size = 2M [mysqlhotcopy] interactive-timeout [mariadb]