MySQL Forums
Forum List  »  Chinese

清除master logs的结果消息有误
Posted by: Liu 刘 Yan 研
Date: September 14, 2006 02:25AM

有两个二进制日志文件,用 purge master logs 命令删除了一个,但是显示的是:受影响的行数为 0

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 99 to server version: 5.0.24-community-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show master logs;
+------------------+------------+
| Log_name         | File_size  |
+------------------+------------+
| mysql-bin.000026 | 1073742051 |
| mysql-bin.000027 |  675531614 |
+------------------+------------+
2 rows in set (0.03 sec)

mysql> purge master logs to 'mysql-bin.000027';
Query OK, 0 rows affected (0.31 sec)       <------------- 这里 ---------
mysql> show master logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000027 | 675627704 |
+------------------+-----------+
1 row in set (0.00 sec)

mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
清除master logs的结果消息有误
8449
September 14, 2006 02:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.