清除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>
Subject
Views
Written By
Posted
清除master logs的结果消息有误
9386
September 14, 2006 02:25AM
6457
October 04, 2006 02:43AM
6585
October 08, 2006 10:50PM
6405
October 18, 2006 11:47PM
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.