binlog日志相关的一些语句

来源：互联网发布：杨浦区人口普查数据编辑：程序博客网时间：2024/06/05 03:39

mysql> show binlog events;
+-------------------+-----+-------------+-----------+-------------+----------------------------------------+
| Log_name          | Pos | Event_type  | Server_id | End_log_pos | Info                                   |
+-------------------+-----+-------------+-----------+-------------+----------------------------------------+
| master-bin.000001 |   4 | Format_desc |         1 |         106 | Server ver: 5.1.69-log, Binlog ver: 4  |
| master-bin.000001 | 106 | Query       |         1 |         194 | use `test`; insert into t1 values(11)  |
| master-bin.000001 | 194 | Query       |         1 |         283 | use `test`; insert into t1 values(112) |
| master-bin.000001 | 283 | Query       |         1 |         357 | use `test`; truncate t1                |
| master-bin.000001 | 357 | Query       |         1 |         445 | use `test`; insert into t1 values (3)  |
| master-bin.000001 | 445 | Query       |         1 |         534 | use `test`; insert into t1 values (32) |
| master-bin.000001 | 534 | Rotate      |         1 |         578 | master-bin.000002;pos=4                |
+-------------------+-----+-------------+-----------+-------------+----------------------------------------+
7 rows in set (0.00 sec)

mysql>

mysql> show binlog events in 'master-bin.000002';
+-------------------+-----+-------------+-----------+-------------+---------------------------------------+
| Log_name          | Pos | Event_type  | Server_id | End_log_pos | Info                                  |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------+
| master-bin.000002 |   4 | Format_desc |         1 |         106 | Server ver: 5.1.69-log, Binlog ver: 4 |
+-------------------+-----+-------------+-----------+-------------+---------------------------------------+
1 row in set (0.00 sec)

mysql> flush logs;//产生新的binlog文件

==========================

mysql> show binary logs;
+-------------------+-----------+
| Log_name          | File_size |
+-------------------+-----------+
| master-bin.000001 |       578 |
| master-bin.000002 |       196 |
+-------------------+-----------+
2 rows in set (0.00 sec)

mysql>

mysql> show binlog events from 194;
+-------------------+-----+------------+-----------+-------------+----------------------------------------+
| Log_name          | Pos | Event_type | Server_id | End_log_pos | Info                                   |
+-------------------+-----+------------+-----------+-------------+----------------------------------------+
| master-bin.000001 | 194 | Query      |         1 |         283 | use `test`; insert into t1 values(112) |
| master-bin.000001 | 283 | Query      |         1 |         357 | use `test`; truncate t1                |
| master-bin.000001 | 357 | Query      |         1 |         445 | use `test`; insert into t1 values (3)  |
| master-bin.000001 | 445 | Query      |         1 |         534 | use `test`; insert into t1 values (32) |
| master-bin.000001 | 534 | Rotate     |         1 |         578 | master-bin.000002;pos=4                |
+-------------------+-----+------------+-----------+-------------+----------------------------------------+
5 rows in set (0.00 sec)

mysql>

reset master;

show master status;

show slave status;

阅读全文

0 0