mysql配置文件加如下代码:
log-error="D:/phpStudy/MySQL/logs/error.log"
log="D:/phpStudy/MySQL/logs/mysql.log"
long_query_time=2
log-slow-queries= "D:/phpStudy/MySQL/logs/slowquery.log"
记得在mysql目录下新建logs文件夹,然后mysql重启服务器,就会看到日志文件
mysql配置文件加如下代码:
log-error="D:/phpStudy/MySQL/logs/error.log"
log="D:/phpStudy/MySQL/logs/mysql.log"
long_query_time=2
log-slow-queries= "D:/phpStudy/MySQL/logs/slowquery.log"