[mysqld_safe] flush_caches = ON innodb_sched_priority_cleaner = 20 [client] port = 3306 socket = /tmp/mysql.sock [mysql] default-character-set = utf8 max_allowed_packet = 16M [mysqldump] max_allowed_packet = 16M [mysqld] log-error = /var/mysql/mysqld.log pid-file = /var/run/mysqld/mysqld.pid socket = /tmp/mysql.sock datadir = /var/mysql general_log_file = /var/mysql/general.log slow_query_log_file = /var/mysql/slow.log innodb_numa_interleave = ON relay-log = relay-bin relay_log_info_repository = TABLE relay_log_recovery = ON character-set-filesystem = utf8 default-time-zone = +00:00 log-bin-trust-function-creators = ON explicit_defaults_for_timestamp = ON max_allowed_packet = 16M secure_file_priv = /var/tmp character_set_server = latin1 collation_server = latin1_swedish_ci innodb_autoinc_lock_mode = 1 log_error_verbosity = 3 master_info_repository = FILE default_authentication_plugin=mysql_native_password port = 3306 server-id = 169748531 tmpdir = /var/mysql-tmpdir max_connections = 500 log-bin = mysql-bin binlog_format = ROW performance_schema = ON event_scheduler = ON key_buffer_size = 64M read_rnd_buffer_size = 8M read_buffer_size = 2M sort_buffer_size = 2M max_heap_table_size = 128M tmp_table_size = 128M innodb_strict_mode = ON innodb_stats_auto_recalc = ON innodb_stats_persistent_sample_pages = 40 innodb_log_buffer_size = 8M innodb_log_file_size = 100M innodb_buffer_pool_size = 4096M innodb_buffer_pool_instances = 8 innodb_buffer_pool_load_at_startup = ON innodb_buffer_pool_dump_at_shutdown = ON innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit = 1 innodb_flush_neighbors = 1 innodb_thread_concurrency = 0 innodb_commit_concurrency = 0 table_open_cache = 2000 table_open_cache_instances = 8 innodb_adaptive_hash_index = ON innodb_io_capacity = 400 innodb_write_io_threads = 4 innodb_read_io_threads = 4 innodb_purge_threads = 2 innodb_print_all_deadlocks = ON sync_binlog = 0 sync_binlog = 0