MySQL Log configuration

#################### #shijl: 20150410:my.ini#######################

#记录所有sql语句

Log=e:/phpstudy/mysql/log/query.log

#记录数据库启动关闭信息, and error messages that are generated during the run

Log-error=e:/phpstudy/mysql/log/error.log

# All SQL statements except the SELECT statement are logged into the log and can be used to recover data files

Log-bin=e:/phpstudy/mysql/log/log

#记录查询慢的sql语句

Log-slow-queries=e:/phpstudy/mysql/log/slow.log

#慢查询时间

Long_query_time=5

###############################################################

This article is from the "Half City" blog, please be sure to keep this source http://vabc1314.blog.51cto.com/2164199/1630782

MySQL Log configuration