[client] default-character-set=utf8mb4 socket=/dev/shm/mysql.sock [mysql] default-character-set=utf8mb4 socket=/dev/shm/mysql.sock auto-rehash [mysqld] port=3306 character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' datadir=/program/mysql/data pid-file=/dev/shm/mysql.pid socket=/dev/shm/mysql.sock user=mysql symbolic-links=0 skip-name-resolve # 备注:在5.7版本里date类型字段的默认值不能设为0000-00-00,如果需要允许这种默认值需要sql_mode配置项去掉NO_ZERO_IN_DATE和NO_ZERO_DATE # sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION #========== 错误日志配置 ==========# # log_error_verbosity为错误日志记录级别,可选值:1=错误信息|2=错误信息&告警信息|3=错误信息&告警信息&通知信息 log_error_verbosity=2 log-error=/program/mysql/log/error.log #========== 慢查询日志配置 ==========# # 备注:long_query_time为慢查询时间阈值(单位:秒),该参数可以设置为0.X的小数记录毫秒级慢查询 slow_query_log=ON slow_query_log_file=/program/mysql/log/slow-query.log long_query_time=1 #========== SQL执行日志配置 ==========# # 备注:所有执行过的SQL都会被记录,一般无需开启(除非需要调试),否则日志文件会非常大而严重占用磁盘空间 general_log=OFF general_log_file=/program/mysql/log/general.log [mysqld_safe] socket=/dev/shm/mysql.sock
Copyright © 2024 码农人生. All Rights Reserved