清除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的结果消息有误
10645
September 14, 2006 02:25AM
7066
October 04, 2006 02:43AM
7249
October 08, 2006 10:50PM
7011
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.