MySQL---慢查询和查询日志配置(my.ini)

slow_query_log=on
slow_query_log_file=E:\MySQL\logquery.log
long_query_time=1
general_log=on
general_log_file=E:\TEMP\mysql.log
log_timestamps=SYSTEM 

 [full my.ini]

[client]
port=3306
default-character-set=utf8

[mysqld]

basedir=C:\MySQL
datadir=C:\MySQL\data
port=3306
max_connections=200
max_connect_errors=10
character-set-server=utf8
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password

slow_query_log=on
slow_query_log_file=C:\MySQL\log\logquery.log
long_query_time=1
general_log=on
general_log_file=C:\MySQL\log\mysql.log
log_timestamps=SYSTEM 

 

posted @ 2020-08-07 17:15  lishidefengchen  阅读(395)  评论(0)    收藏  举报