Mysql数据库管理-blackhole存储引擎

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>