1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
SET SESSION debug= '+d,skip_dd_table_access_check';
CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a char(10));
INSERT INTO t1 VALUES(1, 'aa');
INSERT INTO t1 VALUES(2, 'bb');
SELECT options FROM mysql.tables WHERE name LIKE "%t1%";
options
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;
ALTER TABLE t1 ADD b VARCHAR(20), ALGORITHM=INSTANT;
SELECT options FROM mysql.tables WHERE name LIKE "%t1%";
options
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;
DROP TABLE t1;
CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a char(10));
INSERT INTO t1 VALUES(1, 'aa');
INSERT INTO t1 VALUES(2, 'bb');
SELECT options FROM mysql.tables WHERE name LIKE "%t1%";
options
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;
ALTER TABLE t1 ADD b VARCHAR(20), ALGORITHM=COPY;
SELECT options FROM mysql.tables WHERE name LIKE "%t1%";
options
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;
DROP TABLE t1;
CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a char(10));
INSERT INTO t1 VALUES(1, 'aa');
INSERT INTO t1 VALUES(2, 'bb');
SELECT options FROM mysql.tables WHERE name LIKE "%t1%";
options
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;
ALTER TABLE t1 ADD b VARCHAR(20), ALGORITHM=INPLACE;
SELECT options FROM mysql.tables WHERE name LIKE "%t1%";
options
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;
DROP TABLE t1;
|
