Debian Codegraph @

mysql-test/suite/storage_engine/optimize_table.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
4 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
5 INSERT INTO t1 (a,b) VALUES (3,'c'),(4,'d');
6 OPTIMIZE TABLE t1;
7 Table Op Msg_type Msg_text
8 test.t1 optimize status OK
9 INSERT INTO t2 (a,b) VALUES (4,'d');
10 OPTIMIZE NO_WRITE_TO_BINLOG TABLE t2;
11 Table Op Msg_type Msg_text
12 test.t2 optimize status OK
13 INSERT INTO t2 (a,b) VALUES (5,'e');
14 INSERT INTO t1 (a,b) VALUES (6,'f');
15 OPTIMIZE LOCAL TABLE t1, t2;
16 Table Op Msg_type Msg_text
17 test.t1 optimize status OK
18 test.t2 optimize status OK
19 OPTIMIZE TABLE t1, t2;
20 Table Op Msg_type Msg_text
21 test.t1 optimize status Table is already up to date
22 test.t2 optimize status Table is already up to date
23 DROP TABLE t1, t2;
24 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, <CUSTOM_INDEX> (a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
25 INSERT INTO t1 (a,b) VALUES (1,'a'),(100,'b'),(2,'c'),(3,'d');
26 OPTIMIZE TABLE t1;
27 Table Op Msg_type Msg_text
28 test.t1 optimize status OK
29 DROP TABLE t1;