在mysql安装目录(C:/MySQL/MySQL Server 5.0)下mysql.ini添加如下几行配置信息:
log-error="C:/MySQL/MySQL Server 5.0/logs/error.log"
log="C:/MySQL/MySQL Server 5.0/logs/mysql.log"
long_query_time=2
log-slow-queries= "C:/MySQL/MySQL Server 5.0/logs/slowquery.log"
查看MySQL日志的相关状态:
mysql>show variables like ‘log%’;