简介操作MySQL日志的一些方法

#mysql -u user -p   //user代表你的mysql用户名

Enter password: (输入密码)        //输入密码后就进入mysql的控制台

mysql> show master logs;       //显示mysql日志文件
+------------------+-----------+
| Log_name       | File_size |
+------------------+-----------+
| mysql-bin.000010 | 63328652 |
+------------------+-----------+
1 row in set (0.06 sec)

mysql> show binary logs;        //查看二进制日志文件列表和大小
+------------------+-----------+
| Log_name     | File_size |
+------------------+-----------+
| mysql-bin.000010 | 63355376 |
+------------------+-----------+
1 row in set (0.00 sec)

mysql>show slave hosts     //查看所有连接到master的slave的信息

mysql>show slave status;        //检查从服务器在读取哪个日志

PURGE {MASTER | BINARY} LOGS TO 'log_name'

mysql>purge master logs to 'mysql-bin.000800';  //清楚mysql-bin.000800之前的二进制日志

PURGE {MASTER | BINARY} LOGS BEFORE 'date'

mysql>purge master logs before '2012-12-22 12:12:12'; //删除2012-12-22 12:12:12这时间之前的二进制文件

expire_logs_day=5       //设置日志的过期天数,过了指定的天数,会自动删除

#log-bin=mysql-bin
#binlog_format=mixed