Debian Codegraph @

mysql-test/suite/storage_engine/parts/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> PARTITION BY HASH(a) PARTITIONS 2;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(2,'d'),(4,'e'),(100,'f'),(101,'g');
4 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
5 INSERT INTO t2 (a,b) SELECT a,b FROM t1;
6 INSERT INTO t1 (a,b) VALUES (3,'c');
7 ALTER TABLE t1 ANALYZE PARTITION p0;
8 Table Op Msg_type Msg_text
9 test.t1 analyze status OK
10 INSERT INTO t2 (a,b) VALUES (4,'d'), (1000,'e');
11 ALTER TABLE t1 ANALYZE PARTITION LOCAL ALL;
12 Table Op Msg_type Msg_text
13 test.t1 analyze status OK
14 INSERT INTO t1 (a,b) VALUES (5,'f'),(50,'g');
15 ALTER TABLE t1 ANALYZE PARTITION NO_WRITE_TO_BINLOG p1,p0;
16 Table Op Msg_type Msg_text
17 test.t1 analyze status OK
18 DROP TABLE t1, t2;
19 DROP TABLE IF EXISTS t1,t2;
20 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
21 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
22 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
23 INSERT INTO t1 (a,b) VALUES (3,'c');
24 ANALYZE TABLE t1;
25 Table Op Msg_type Msg_text
26 test.t1 analyze status OK
27 INSERT INTO t2 (a,b) VALUES (4,'d');
28 ANALYZE NO_WRITE_TO_BINLOG TABLE t2;
29 Table Op Msg_type Msg_text
30 test.t2 analyze status OK
31 INSERT INTO t1 (a,b) VALUES (5,'e');
32 INSERT INTO t2 (a,b) VALUES (6,'f');
33 ANALYZE LOCAL TABLE t1, t2;
34 Table Op Msg_type Msg_text
35 test.t1 analyze status OK
36 test.t2 analyze status OK
37 DROP TABLE t1, t2;
38 CREATE TABLE t1 (a <INT_COLUMN>, <CUSTOM_INDEX>(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
39 INSERT INTO t1 (a) VALUES (1),(2),(4),(7);
40 ANALYZE TABLE t1;
41 Table Op Msg_type Msg_text
42 test.t1 analyze status OK
43 INSERT INTO t1 (a) VALUES (8),(10),(11),(12);
44 ANALYZE TABLE t1;
45 Table Op Msg_type Msg_text
46 test.t1 analyze status OK
47 DROP TABLE t1;