【实现】mysql日志

 

 error log

 

show variables like "%log_err%"：

 内容如下

general query log

 show variables like "%general%";

 

 

 

binary log

恢复和主从复制

 

show variables like "%log_bin%";

 mysql> show variables like "%binlog%";

 

mysql> show binary logs;

show binlog events in 'binlog.000005';

 

 

../bin/mysqlbinlog 'binlog.000005':

 

 

恢复：

../bin/mysqlbinlog --start-position=4 --stop-position=14889 binlog.000005 |../bin/mysql -uroot -pabcd1234

 

 slow query log

mysqlvariables like "%slow_query%";

 

 

mysql> show variables like "%long_query_time%";

 mysql> set long_query_time=5; 

 