Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 #
3 # Test that mysqld does not crash when running ANALYZE TABLE with
4 # different values of the parameter innodb_stats_transient_sample_pages.
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 -- enable_warnings
11
12 SET @save_sample_pages = @@GLOBAL.innodb_stats_transient_sample_pages;
13 SET GLOBAL innodb_stats_transient_sample_pages=0;
14 SHOW VARIABLES LIKE 'innodb_stats_transient_sample_pages';
15 -- disable_result_log
16
17 CREATE TABLE innodb_analyze (
18 a INT,
19 b INT,
20 KEY(a),
21 KEY(b,a)
22 ) ENGINE=InnoDB;
23
24 # test with empty table
25
26 ANALYZE TABLE innodb_analyze;
27
28 SET GLOBAL innodb_stats_transient_sample_pages=2;
29 ANALYZE TABLE innodb_analyze;
30
31 SET GLOBAL innodb_stats_transient_sample_pages=4;
32 ANALYZE TABLE innodb_analyze;
33
34 SET GLOBAL innodb_stats_transient_sample_pages=8;
35 ANALYZE TABLE innodb_analyze;
36
37 SET GLOBAL innodb_stats_transient_sample_pages=16;
38 ANALYZE TABLE innodb_analyze;
39
40 INSERT INTO innodb_analyze VALUES
41 (1,1), (1,1), (1,2), (1,3), (1,4), (1,5),
42 (8,1), (8,8), (8,2), (7,1), (1,4), (3,5);
43
44 SET GLOBAL innodb_stats_transient_sample_pages=1;
45 ANALYZE TABLE innodb_analyze;
46
47 SET GLOBAL innodb_stats_transient_sample_pages=2;
48 ANALYZE TABLE innodb_analyze;
49
50 SET GLOBAL innodb_stats_transient_sample_pages=4;
51 ANALYZE TABLE innodb_analyze;
52
53 SET GLOBAL innodb_stats_transient_sample_pages=8;
54 ANALYZE TABLE innodb_analyze;
55
56 SET GLOBAL innodb_stats_transient_sample_pages=16;
57 ANALYZE TABLE innodb_analyze;
58
59 DROP TABLE innodb_analyze;
60 SET GLOBAL innodb_stats_transient_sample_pages = @save_sample_pages;