mysql 5.7日志配置_mysql-5.7日志设置

环境windows7  64位

mysql版本：5.7.17

my.ini配置：

[client]

port=3306

default-character-set=utf8

[mysqld]

port=3306

character_set_server=utf8

#解压目录

basedir=D:\mysql-5.7.15-winx64

#解压目录下data目录

datadir=D:\mysql-5.7.15-winx64\data

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#各种日志(查询、错误、慢查询)配置：

#log_bin=D:\mysql-5.7.15-winx64\log\mysql-bin.log

log_error=D:\mysql-5.7.15-winx64\log\mysql.err

long_query_time=1

slow_query_log=ON

slow_query_log_file=D:\mysql-5.7.15-winx64\log\mysql-slow.log

general_log=ON

general_log_file=D:\mysql-5.7.15-winx64\log\log-mysql.log

max_connections=100

table_open_cache=256

query_cache_size=1M

tmp_table_size=32M

thread_cache_size=8

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=128M

innodb_buffer_pool_size=128M

innodb_log_file_size=10M

innodb_thread_concurrency=16

innodb-autoextend-increment=1000

join_buffer_size=128M

sort_buffer_size=32M

read_rnd_buffer_size=32M

max_allowed_packet=32M

explicit_defaults_for_timestamp=true

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

设置完成后重启mysql服务。