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服务。

转载于:https://www.cnblogs.com/-lanfenglanmeng/p/8149906.html