Debian Codegraph @

mysql-test/suite/storage_engine/analyze_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');
6 ANALYZE TABLE t1;
7 Table Op Msg_type Msg_text
8 test.t1 analyze status OK
9 INSERT INTO t2 (a,b) VALUES (4,'d');
10 ANALYZE NO_WRITE_TO_BINLOG TABLE t2;
11 Table Op Msg_type Msg_text
12 test.t2 analyze status OK
13 INSERT INTO t1 (a,b) VALUES (5,'e');
14 INSERT INTO t2 (a,b) VALUES (6,'f');
15 ANALYZE LOCAL TABLE t1, t2;
16 Table Op Msg_type Msg_text
17 test.t1 analyze status OK
18 test.t2 analyze status OK
19 DROP TABLE t1, t2;
20 CREATE TABLE t1 (a <INT_COLUMN>, <CUSTOM_INDEX>(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
21 INSERT INTO t1 (a) VALUES (1),(2),(4),(7);
22 ANALYZE TABLE t1;
23 Table Op Msg_type Msg_text
24 test.t1 analyze status OK
25 INSERT INTO t1 (a) VALUES (8),(10),(11),(12);
26 ANALYZE TABLE t1;
27 Table Op Msg_type Msg_text
28 test.t1 analyze status OK
29 DROP TABLE t1;