Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_table_flag_auto_recalc.result

raw
1 CREATE TABLE test_ps_auto_recalc (a INT, PRIMARY KEY (a)) ENGINE=INNODB;
2 SHOW CREATE TABLE test_ps_auto_recalc;
3 Table test_ps_auto_recalc
4 Create Table CREATE TABLE `test_ps_auto_recalc` (
5 `a` int NOT NULL,
6 PRIMARY KEY (`a`)
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
8 SELECT create_options FROM information_schema.tables
9 WHERE table_name='test_ps_auto_recalc';
10 CREATE_OPTIONS
11 ALTER TABLE test_ps_auto_recalc STATS_AUTO_RECALC=1;
12 # restart
13 SHOW CREATE TABLE test_ps_auto_recalc;
14 Table test_ps_auto_recalc
15 Create Table CREATE TABLE `test_ps_auto_recalc` (
16 `a` int NOT NULL,
17 PRIMARY KEY (`a`)
18 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_AUTO_RECALC=1
19 SELECT create_options FROM information_schema.tables
20 WHERE table_name='test_ps_auto_recalc';
21 CREATE_OPTIONS stats_auto_recalc=1
22 DROP TABLE test_ps_auto_recalc;
23 CREATE TABLE test_ps_auto_recalc (a INT, PRIMARY KEY (a)) ENGINE=INNODB
24 STATS_AUTO_RECALC=default;
25 SHOW CREATE TABLE test_ps_auto_recalc;
26 Table test_ps_auto_recalc
27 Create Table CREATE TABLE `test_ps_auto_recalc` (
28 `a` int NOT NULL,
29 PRIMARY KEY (`a`)
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
31 SELECT create_options FROM information_schema.tables
32 WHERE table_name='test_ps_auto_recalc';
33 CREATE_OPTIONS
34 DROP TABLE test_ps_auto_recalc;
35 CREATE TABLE test_ps_auto_recalc (a INT, PRIMARY KEY (a)) ENGINE=INNODB
36 STATS_AUTO_RECALC=0;
37 # restart
38 SHOW CREATE TABLE test_ps_auto_recalc;
39 Table test_ps_auto_recalc
40 Create Table CREATE TABLE `test_ps_auto_recalc` (
41 `a` int NOT NULL,
42 PRIMARY KEY (`a`)
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_AUTO_RECALC=0
44 SELECT create_options FROM information_schema.tables
45 WHERE table_name='test_ps_auto_recalc';
46 CREATE_OPTIONS stats_auto_recalc=0
47 ALTER TABLE test_ps_auto_recalc STATS_AUTO_RECALC=1;
48 # restart
49 SHOW CREATE TABLE test_ps_auto_recalc;
50 Table test_ps_auto_recalc
51 Create Table CREATE TABLE `test_ps_auto_recalc` (
52 `a` int NOT NULL,
53 PRIMARY KEY (`a`)
54 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_AUTO_RECALC=1
55 SELECT create_options FROM information_schema.tables
56 WHERE table_name='test_ps_auto_recalc';
57 CREATE_OPTIONS stats_auto_recalc=1
58 DROP TABLE test_ps_auto_recalc;
59 CREATE TABLE test_ps_auto_recalc (a INT, PRIMARY KEY (a)) ENGINE=INNODB
60 STATS_AUTO_RECALC=1;
61 # restart
62 SHOW CREATE TABLE test_ps_auto_recalc;
63 Table test_ps_auto_recalc
64 Create Table CREATE TABLE `test_ps_auto_recalc` (
65 `a` int NOT NULL,
66 PRIMARY KEY (`a`)
67 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_AUTO_RECALC=1
68 SELECT create_options FROM information_schema.tables
69 WHERE table_name='test_ps_auto_recalc';
70 CREATE_OPTIONS stats_auto_recalc=1
71 ALTER TABLE test_ps_auto_recalc STATS_AUTO_RECALC=0;
72 # restart
73 SHOW CREATE TABLE test_ps_auto_recalc;
74 Table test_ps_auto_recalc
75 Create Table CREATE TABLE `test_ps_auto_recalc` (
76 `a` int NOT NULL,
77 PRIMARY KEY (`a`)
78 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_AUTO_RECALC=0
79 SELECT create_options FROM information_schema.tables
80 WHERE table_name='test_ps_auto_recalc';
81 CREATE_OPTIONS stats_auto_recalc=0
82 DROP TABLE test_ps_auto_recalc;
83 call mtr.add_suppression("ignoring ib_[0-9]+_[0-9]+.dblwr - page size doesn't match");