[mysqld] datadir = ... lc_messages_dir=/usr/local/share lc_messages=en_US max_connections = 500 open_files_limit = 32768 # haproxy : 5/2018 MDD bind-address=... server_id=2 bulk_insert_buffer_size=16777216 connect_timeout=60 innodb_strict_mode=OFF lock_wait_timeout = 31536000 # toku tokudb_lock_timeout = 10000 tokudb_create_index_online = OFF tokudb_loader_memory_size = 2G sql_mode="NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" innodb_log_buffer_size = 256M innodb_buffer_pool_size = 10G innodb_io_capacity = 400 max_allowed_packet = 16777216 max_heap_table_size = 1G tmp_table_size = 1G open_files_limit = 32768 innodb_buffer_pool_instances = 10 innodb_flush_log_at_timeout = 10 innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT query_alloc_block_size = 16384 query_cache_size = 1G query_cache_type = ON query_prealloc_size = 24576 sort_buffer_size = 16M