1 查看mysql最早的binlog文件编号
mysql> show binlog events limit 10;
+------------------+-----+-------------+-----------+-------------+----------------------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+------------------+-----+-------------+-----------+-------------+----------------------------------------------------------------------+
| mysql-bin.000064 | 4 | Format_desc | 15212446 | 106 | Server ver: 5.1.48-log, Binlog ver: 4 |
| mysql-bin.000064 | 106 | Query | 15212446 | 190 | BEGIN |
| mysql-bin.000064 | 190 | Table_map | 15212446 | 284 | table_id: 1171814880 (tmall_inventory_0053.ipm_trade_inventory_0857) |
| mysql-bin.000064 | 284 | Write_rows | 15212446 | 392 | table_id: 1171814880 flags: STMT_END_F |
| mysql-bin.000064 | 392 | Xid | 15212446 | 419 | COMMIT /* xid=2428528478 */ |
| mysql-bin.000064 | 419 | Query | 15212446 | 503 | BEGIN |
| mysql-bin.000064 | 503 | Table_map | 15212446 | 597 | table_id: 1171814880 (tmall_inventory_0053.ipm_trade_inventory_0857) |
| mysql-bin.000064 | 597 | Write_rows | 15212446 | 705 | table_id: 1171814880 flags: STMT_END_F |
| mysql-bin.000064 | 705 | Xid | 15212446 | 732 | COMMIT /* xid=2428528480 */ |
| mysql-bin.000064 | 732 | Query | 15212446 | 816 | BEGIN |
+------------------+-----+-------------+-----------+-------------+----------------------------------------------------------------------+
10 rows in set (0.02 sec)