1.查询日志:
- 路径:/etc/my.conf
log=/usr/local/mysql/data/mysql_general.log
重启MySQL:service mysqld restart
2.慢查询日志:
long_query_time=2
slow_query_log=ON
slow_query_log_file=/usr/local/mysql/data/mysql-slow.log
3.错误日志
log_error=/usr/local/mysql/data/mysql-error.log
4.二进制日志
路径:
[root@iZ2zee0nytq6dev0ugui2iZ /]# cd etc/
[root@iZ2zee0nytq6dev0ugui2iZ etc]# vim my.cnf
log-bin=mysql-bin
重启MySQL:service mysqld restart