查看mysql最早的binlog檔案編號

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)