show binary logs

语法

show binary logs;

作用
列出当前所有的binlog文件

示例

mysql> show binary logs;
+------------------+------------+
| Log_name         | File_size  |
+------------------+------------+
| mysql-bin.002762 | 1074070000 |
| mysql-bin.002763 | 1075937977 |
| mysql-bin.002764 | 1075803218 |
| mysql-bin.002765 | 1074514660 |
| mysql-bin.002766 | 1074370025 |
| mysql-bin.002767 | 1074153297 |
| mysql-bin.002768 | 1075268101 |
| mysql-bin.002769 | 1075422206 |
....
| mysql-bin.003332 | 1084521601 |
| mysql-bin.003333 | 1086691471 |
| mysql-bin.003334 |  197777189 |
+------------------+------------+
573 rows in set (0.34 sec)