Monitoring progress and temporal memory usage of Online DDL in InnoDB

http://ift.tt/1vR6dyT

Introduction Online DDL is a new feature in MariaDB 10.0. Online DDL is processed through below 4 tasks in sequence. InnoDB::ha_prepare_inplace_alter_table(..) InnoDB::ha_inplace_alter_table(..) InnoDB::ha_commit_inplace_alter_table(..) mysql_rename_table(..) InnoDB storage engine allocates temporal memory buffer for transaction logging in phase 1 where row changes during this phase are logged. Size of this buffer is at start sort_buffer_size and it… Continue reading →

from The MariaDB Blog http://ift.tt/1pKKMuy