Altering column length is consuming double the space at Storage level
Altering the length of an innodb table column takes double the space to perform the change as it is making a copy of the table.We have 1TB table .Is there a way we avoid this. The table is partitioned table.
Answer Answered by just someone in this comment.
check the algorithm option https://mariadb.com/kb/en/alter-table/#algorithm https://mariadb.com/kb/en/innodb-online-ddl-overview/#algorithm
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
