Why in mariadb 10.6.11 does copy to tmp table occur when adding a field to the end of a table with default value NULL?
There are two large tables (> 10GB). When adding a field to one of them to the end of the table, copy to tmp table happens, when adding a field to the other one, it happens immediately altering table - you can see it in phpmyadmin in the state tab, state column. Why does this happen? As far as I know, in later versions of mysql and mariadb such queries should be executed without copying data to a temporary table. Both tables are innodb. Example query
ALTER TABLE `mytable` ADD `last_field` VARCHAR(511) NULL DEFAULT NULL AFTER `last_field_now`
Answer Answered by Роман Кистин in this comment.
it's all due to the fulltext index in the table
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.
