Mysql数据库管理-blackhole存储引擎_mysql blackhole-优快云博客

本文链接：https://blog.youkuaiyun.com/oradbm/article/details/134402891

文章描述了在MySQL中创建表、插入数据、提交事务以及查看和解析binarylogs中的事件过程，展示了GTID（全球事务标识符）在事务管理中的作用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql> create table test(id int) engine=blackhole;
Query OK, 0 rows affected (0.03 sec)

mysql>
mysql>
mysql> select * from test;
Empty set (0.01 sec)

mysql> insert into test(id ) values (1);
Query OK, 1 row affected (0.01 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from test;
Empty set (0.00 sec)

mysql> show binary logs;
+------------+-----------+-----------+
| Log_name | File_size | Encrypted |
+------------+-----------+-----------+
| log.000001 | 197 | No |
| log.000002 | 197 | No |
| log.000003 | 197 | No |
| log.000004 | 197 | No |
| log.000005 | 197 | No |
| log.000006 | 197 | No |
| log.000007 | 179 | No |
| log.000008 | 2575 | No |
| log.000009 | 709 | No |
+------------+-----------+-----------+
9 rows in set (0.01 sec)

mysql> show binlog events in 'log.000009'
-> ;
+------------+-----+----------------+-----------+-------------+---------------------------------------
----------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info
|
+------------+-----+----------------+-----------+-------------+---------------------------------------
----------------------------+
| log.000009 | 4 | Format_desc | 1 | 125 | Server ver: 8.0.24, Binlog ver: 4
|
| log.000009 | 125 | Previous_gtids | 1 | 196 | 55390eba-d320-11eb-8e31-00ffaabbccdd:1
|
| log.000009 | 196 | Gtid | 1 | 273 | SET @@SESSION.GTID_NEXT= '55390eba-d32
0-11eb-8e31-00ffaabbccdd:2' |
| log.000009 | 273 | Query | 1 | 392 | use `ytt`; create table test(id int) e
ngine=blackhole |
| log.000009 | 392 | Gtid | 1 | 471 | SET @@SESSION.GTID_NEXT= '55390eba-d32
0-11eb-8e31-00ffaabbccdd:3' |
| log.000009 | 471 | Query | 1 | 545 | BEGIN
|
| log.000009 | 545 | Table_map | 1 | 594 | table_id: 87 (ytt.test)
|
| log.000009 | 594 | Write_rows | 1 | 634 | table_id: 87 flags: STMT_END_F
|
| log.000009 | 634 | Query | 1 | 709 | COMMIT
|
+------------+-----+----------------+-----------+-------------+---------------------------------------
----------------------------+
9 rows in set (0.00 sec)

mysql>