CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT, ALGORITHM=INSTANT; INSERT INTO t1 VALUES (1,1); SELECT * FROM t1; c1 c2 1 1 DROP TABLE t1; # Redundant: CREATE TABLE t1_redundant (c1 INT) ROW_FORMAT=REDUNDANT, ENGINE=INNODB; ALTER TABLE t1_redundant ADD COLUMN c2 INT, ALGORITHM=INSTANT; INSERT INTO t1_redundant VALUES (1,1); SHOW CREATE TABLE t1_redundant; Table Create Table t1_redundant CREATE TABLE `t1_redundant` ( `c1` int DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT SELECT * FROM t1_redundant; c1 c2 1 1 CHECK TABLE t1_redundant; Table Op Msg_type Msg_text test.t1_redundant check status OK DROP TABLE t1_redundant; # Compact: CREATE TABLE t1_compact (c1 INT) ROW_FORMAT=COMPACT, ENGINE=INNODB; ALTER TABLE t1_compact ADD COLUMN c2 INT, ALGORITHM=INSTANT; INSERT INTO t1_compact VALUES (1,1); SHOW CREATE TABLE t1_compact; Table Create Table t1_compact CREATE TABLE `t1_compact` ( `c1` int DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT SELECT * FROM t1_compact; c1 c2 1 1 CHECK TABLE t1_compact; Table Op Msg_type Msg_text test.t1_compact check status OK DROP TABLE t1_compact; # Dynamic: CREATE TABLE t1_dynamic (c1 INT) ROW_FORMAT=DYNAMIC, ENGINe=INNODB; ALTER TABLE t1_dynamic ADD COLUMN c2 INT, ALGORITHM=INSTANT; INSERT INTO t1_dynamic VALUES (1,1); SHOW CREATE TABLE t1_dynamic; Table Create Table t1_dynamic CREATE TABLE `t1_dynamic` ( `c1` int DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC SELECT * FROM t1_dynamic; c1 c2 1 1 CHECK TABLE t1_dynamic; Table Op Msg_type Msg_text test.t1_dynamic check status OK DROP TABLE t1_dynamic;