I've learnt that InnoDB mini transaction never rolls back (see this). It is mentioned that operations such as B tree insertion is a mini transaction. What makes me confused is that when inserting a new entry into B tree, we have to read the block from disk to memory and allocate new block when splitting is necessary. In those scenarios, errors could happen during insertion (e.g. there is no sufficient space in buffer pool or disk so reading from disk to memory and allocating new block are impossible). If mini transaction is not allowed to roll back, how to undo the partial modifications made by the operation when the errors mentioned happen?
0 Answers
Related