Debian Codegraph @

mysql-test/suite/innodb/t/innodb-analyze.test

raw
1 #
2 # Test that mysqld does not crash when running ANALYZE TABLE with
3 # different values of the parameter innodb_stats_transient_sample_pages.
4 #
5
6
7 # we care only that the following SQL commands do not produce errors
8 # and do not crash the server
9 -- disable_query_log
10 -- disable_result_log
11
12 let $sample_pages=`select @@innodb_stats_transient_sample_pages`;
13 SET GLOBAL innodb_stats_transient_sample_pages=0;
14
15 # check that the value has been adjusted to 1
16 -- enable_result_log
17 SHOW VARIABLES LIKE 'innodb_stats_transient_sample_pages';
18 -- disable_result_log
19
20 CREATE TABLE innodb_analyze (
21 a INT,
22 b INT,
23 KEY(a),
24 KEY(b,a)
25 ) ENGINE=InnoDB;
26
27 # test with empty table
28
29 ANALYZE TABLE innodb_analyze;
30
31 SET GLOBAL innodb_stats_transient_sample_pages=2;
32 ANALYZE TABLE innodb_analyze;
33
34 SET GLOBAL innodb_stats_transient_sample_pages=4;
35 ANALYZE TABLE innodb_analyze;
36
37 SET GLOBAL innodb_stats_transient_sample_pages=8;
38 ANALYZE TABLE innodb_analyze;
39
40 SET GLOBAL innodb_stats_transient_sample_pages=16;
41 ANALYZE TABLE innodb_analyze;
42
43 INSERT INTO innodb_analyze VALUES
44 (1,1), (1,1), (1,2), (1,3), (1,4), (1,5),
45 (8,1), (8,8), (8,2), (7,1), (1,4), (3,5);
46
47 SET GLOBAL innodb_stats_transient_sample_pages=1;
48 ANALYZE TABLE innodb_analyze;
49
50 SET GLOBAL innodb_stats_transient_sample_pages=2;
51 ANALYZE TABLE innodb_analyze;
52
53 SET GLOBAL innodb_stats_transient_sample_pages=4;
54 ANALYZE TABLE innodb_analyze;
55
56 SET GLOBAL innodb_stats_transient_sample_pages=8;
57 ANALYZE TABLE innodb_analyze;
58
59 SET GLOBAL innodb_stats_transient_sample_pages=16;
60 ANALYZE TABLE innodb_analyze;
61
62 DROP TABLE innodb_analyze;
63 EVAL SET GLOBAL innodb_stats_transient_sample_pages=$sample_pages;