[mysqld]
# 跨库多表连接查询
federated = 1
# 设置3306端口
port = 3306
# 允许最大连接数
max_connections = 2000
# 创建新表时将使用的默认存储引擎
default-storage-engine = INNODB
# 不区分大小写
lower_case_table_names = 1
# 禁止域名解析
skip-name-resolve = 1
# 记录错误日志
log_error = /var/log/mysql/error.log
# 指定传输数据包大小
max_allowed_packet = 1024M
# 客户端高并发等待连接队列
back_log = 2048
# 移除 SQL92(ONLY_FULL_GROUP_BY) 标准使用GROUP BY函数查出来的列必须在包含在 GROUP BY 中
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
# 日志保留30天
expire_logs_days = 30
# 记录查询日志
slow_query_log_file = /var/log/mysql/mysql-slow.log
# 启用慢查询日志记录
slow_query_log = 1
# 指定超过1秒为慢查询
long_query_time = 1
# 缓冲池大小
innodb_buffer_pool_size = 2G
# I/O 写入的线程数量
innodb_write_io_threads = 8
# I/O 读取的线程数量
innodb_read_io_threads = 24
# 缓冲池的实例数
innodb_buffer_pool_instances=32