Mysql rollback insert causes IBD file to increase ' one times '

a simple test:

Start Transaction;insert into TB1 values (3, repeat (' a ', 65000), ' X ', 1);--commit;rollback;

tb1.ibd, respectively, in before you insert, roll back the size of the file before the rollback:

Someone in QQ group asked why.

---------------------------------------

In fact, the reason is simple:

131072-98304=163840-131072=32768
So: Roll back insert = delete + re-insert, and delete refers to set Flag,so ... Content increases by one-fold.

The rollback of the insert operation is to delete the previously inserted value, then insert it again, and delete is the tombstone, which is to set a flag, without a real delete. That's the reason.

Mysql rollback insert causes IBD file to increase ' one times '