[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks skip-name-resolve symbolic-links=0 character-set-server=utf8 collation-server=utf8_unicode_ci log-bin=/var/log/mysql/mysql-bin binlog-format=MIXED log-slave-updates expire-logs-days=5 server-id=4 slave_domain_parallel_threads=4 slave_parallel_threads=12 innodb_print_all_deadlocks=ON performance_schema default-storage-engine = InnoDB max_connections = 500 lower_case_table_names=1 query_cache_size = 64M tmp_table_size = 128M max_heap_table_size = 64M thread_cache_size = 4 table_cache = 512 innodb_buffer_pool_size = 8G innodb_log_file_size = 100M innodb_stats_on_metadata = 0 max_allowed_packet = 32M slow_query_log = ON log-slow-slave-statements slave_run_triggers_for_rbr = 1 innodb_read_io_threads = 64 innodb_write_io_threads = 64 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid