[mysqld]

max_connections=200
open_files_limit=65535
table_open_cache=2048
thread_cache_size=128

# Innodb
innodb_buffer_pool_size=2G
innodb_log_file_size=512M
innodb_flush_method=O_DIRECT
innodb_file_per_table=1
innodb_flush_neighbors=0
innodb_read_io_threads=4
innodb_write_io_threads=4

# ---------------------------------------------------------------------------
# innodb_snapshot_isolation
# Controls whether InnoDB enables full snapshot isolation.
# ---------------------------------------------------------------------------
innodb_snapshot_isolation=0