references:
http://dev.mysql.com/doc/refman/4.1/en/server-logs.html
log 的开启注意要相关的global variables 置成on
1)在my.ini里面配置
log_bin=on
general_log=on
//event_scheduler=1
2)运行中,但是server重启后会恢复成默认配置
show global variables like 'general_log'
set global general_log=on
3) 查看log file,其他log直接看
binlog:
show master logs;
mysqlbinlog on.000001
讲binlog转化成txt:
http://www.2cto.com/database/201409/338185.html