You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
37 lines
1.1 KiB
37 lines
1.1 KiB
[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
|
|
|