[MDEV-14317] When ALTER TABLE is aborted, do not write garbage pages to data files Created: 2017-11-07  Updated: 2017-11-20  Resolved: 2017-11-20

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.11
Fix Version/s: 10.2.11

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: ddl, performance

Issue Links:
Relates
relates to MDEV-14310 Possible corruption by table-rebuildi... Closed

 Description   

Fixing the potential corruption bug MDEV-14310 will reduce the performance of ALTER TABLE when the operation fails or is interrupted.
There is no reason to write pages that would be freed as part of rolling back the operation.

Maybe there should be a separate flush list for the pages for which redo logging has been disabled. Then the FlushObserver could simply leave buf_pool_t::flush_list alone.
Generated at Thu Feb 08 08:12:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.