######### # SETUP # ######### # Stop the running the server # Copy and unzip the datadir. # Restart the server against the unzipped datadir # restart: --datadir=DATADIR --innodb-page-size=16k ############################################## # Test instant ADD COLUMN for REDUNDANT format ############################################## ######### # SETUP # ######### # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS test/t1_redundant 7 3 0 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT id 0 6 1283 0 c1 1 13 16711934 0 c2 2 13 16711934 0 c3 3 13 16711934 1 SELECT * FROM t1_redundant; id c1 c2 c3 1 r0c0 r1c2 r1c3 3 r3c1 r3c2 r3c3 ########### # CLEANUP # ########### DROP TABLE t1_redundant; ############################################ # Test instant ADD COLUMN for DYNAMIC format ############################################ ######### # SETUP # ######### # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS test/t1_dynamic 7 3 0 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT id 0 6 1283 0 c1 1 13 16711934 0 c2 2 13 16711934 0 c3 3 13 16711934 1 SELECT * FROM t1_dynamic; id c1 c2 c3 1 r0c0 r1c2 r1c3 3 r3c1 r3c2 r3c3 ########### # CLEANUP # ########### DROP TABLE t1_dynamic; ############################################ # Test instant ADD COLUMN for COMPACT format ############################################ ######### # SETUP # ######### # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS test/t1_compact 7 3 0 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT id 0 6 1283 0 c1 1 13 16711934 0 c2 2 13 16711934 0 c3 3 13 16711934 1 SELECT * FROM t1_compact; id c1 c2 c3 1 r0c0 r1c2 r1c3 3 r3c1 r3c2 r3c3 ########### # CLEANUP # ########### DROP TABLE t1_compact; ########### # CLEANUP # ########### # Shutdown server # Remove copied files # Restarting server to restore server state # restart