Debian Codegraph @

mysql-test/suite/innodb/t/innodb-stats-sample.test

raw
1 --source include/have_innodb.inc
2 --source include/no_valgrind_without_big.inc
3 #
4 # Test that mysqld does not crash when running ANALYZE TABLE with
5 # different values of the parameter innodb_stats_transient_sample_pages.
6 #
7
8 # we care only that the following SQL commands do not produce errors
9 # and do not crash the server
10 -- disable_query_log
11 -- enable_warnings
12
13 SET @save_sample_pages = @@GLOBAL.innodb_stats_transient_sample_pages;
14 SET @save_traditional = @@GLOBAL.innodb_stats_traditional;
15 SET GLOBAL innodb_stats_transient_sample_pages=0;
16 #use new method to calculate statistics
17 SET GLOBAL innodb_stats_traditional=0;
18 SHOW VARIABLES LIKE 'innodb_stats_transient_sample_pages';
19 SHOW VARIABLES LIKE 'innodb_stats_traditional';
20 -- disable_result_log
21
22 CREATE TABLE innodb_analyze (
23 a INT,
24 b INT,
25 c char(50),
26 KEY(a),
27 KEY(b,a)
28 ) ENGINE=InnoDB;
29
30 # test with empty table
31 ANALYZE TABLE innodb_analyze;
32
33 SET GLOBAL innodb_stats_transient_sample_pages=2;
34 ANALYZE TABLE innodb_analyze;
35
36 SET GLOBAL innodb_stats_transient_sample_pages=1;
37 ANALYZE TABLE innodb_analyze;
38
39 SET GLOBAL innodb_stats_transient_sample_pages=8000;
40 ANALYZE TABLE innodb_analyze;
41
42 delimiter //;
43 create procedure innodb_insert_proc (repeat_count int)
44 begin
45 declare current_num int;
46 set current_num = 0;
47 while current_num < repeat_count do
48 insert into innodb_analyze values(current_num, current_num*100,substring(MD5(RAND()), -44));
49 set current_num = current_num + 1;
50 end while;
51 end//
52 delimiter ;//
53 commit;
54
55 set autocommit=0;
56 call innodb_insert_proc(7000);
57 commit;
58 set autocommit=1;
59
60 SET GLOBAL innodb_stats_transient_sample_pages=1;
61 ANALYZE TABLE innodb_analyze;
62
63 SET GLOBAL innodb_stats_transient_sample_pages=8;
64 ANALYZE TABLE innodb_analyze;
65
66 SET GLOBAL innodb_stats_transient_sample_pages=16;
67 ANALYZE TABLE innodb_analyze;
68
69 SET GLOBAL innodb_stats_transient_sample_pages=8000;
70 ANALYZE TABLE innodb_analyze;
71
72 DROP PROCEDURE innodb_insert_proc;
73 DROP TABLE innodb_analyze;
74 SET GLOBAL innodb_stats_transient_sample_pages = @save_sample_pages;
75 SET GLOBAL innodb_stats_traditional = @save_traditional;