清除mysql的日志的方法

下面介绍一下关于mysql日志的清除方法,下面不说多,#的行是注释下面的是真实的例子,可供参考.

1. [root@aslibrawww.aslibra.com]#mysql-S/Data/www.aslibra.com/mysql/mysql.sock-uadmin-ppassword
2. WelcometotheMySQLmonitor.Commandsendwith;org.
3. YourMySQLconnectionidis322891
4. Serverversion:5.5.2-m2-logSourcedistribution
6. Type'help;'or'h'forhelp.Type'c'toclearthecurrentinputstatement.

#显示当前所有日志,代码如下:

1. mysql>showmasterlogs;
2. +------------------+------------+
3. |Log_name|File_size|
4. +------------------+------------+
5. |mysql-bin.000001|126|
6. |mysql-bin.000002|1074328576|
7. |mysql-bin.000003|918443740|
8. |mysql-bin.000004|126|
9. |mysql-bin.000005|126|
10. |mysql-bin.000006|109880744|
11. +------------------+------------+
12. 6rowsinset(0.00sec)

#删除日志到某一个,不能超过最后一个,代码如下:

mysql> purge master logs to 'mysql-bin.000027';

ERROR 1373 (HY000):Target log not found in binlog index

#删除日志到最后一个即可,代码如下:

mysql> purge master logs to 'mysql-bin.000006';

Query OK, 0 rows affected (3.80 sec)

#看看现在的情况,代码如下:

1. mysql>showmasterlogs;
2. +------------------+-----------+
3. |Log_name|File_size|
4. +------------------+-----------+
5. |mysql-bin.000006|109884395|
6. +------------------+-----------+
7. 1rowinset(0.00sec)
8. --phpfensi.com

#退出,代码如下:mysql> exit