mysql配置文件my.cnf

Tylerdalin

已于 2022-03-22 15:54:28 修改

阅读量2k

点赞数 1

文章标签：运维开发 mysql

于 2022-03-22 15:53:48 首次发布

本文链接：https://blog.youkuaiyun.com/LiuLin_CF/article/details/123662484

版权

本文详细介绍了MySQL的配置文件my.cnf，包括其重要参数设置和对数据库性能的影响。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql配置文件my.cnf

mysql配置文件如下：

[mysqld]
character-set-server=utf8mb4
#skip-grant-tables
log-bin=mysql-bin
binlog-format=ROW
binlog-ignore-db=mysql
server-id=1
user=mysql
port=3306
basedir=/var/log/mysql
datadir=/home/mysql_data
socket=/var/log/mysql/mysql.sock
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names=1
transaction_isolation=READ-COMMITTED
max_connections=2000
max_connect_errors=2000
innodb_buffer_pool_size=12GB     #70% RAM
innodb_file_per_table=1
innodb_log_file_size=500M
innodb_log_buffer_size=500M
innodb_flush_log_at_trx_commit=1
innodb_print_all_deadlocks=1
innodb_flush_method=O_DIRECT
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_io_capacity=5000
innodb_io_capacity_max=20000
innodb_lock_wait_timeout=20000
innodb_large_prefix=on

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid