Debian Codegraph @

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

raw
1 --source include/big_test.inc
2
3 DELIMITER |;
4 CREATE PROCEDURE prepare_data(IN val INT)
5 BEGIN
6 DECLARE i INT DEFAULT 1;
7
8 WHILE i < val DO
9 INSERT INTO t1 (b) VALUES (i);
10 SET i = i + 1;
11 END WHILE;
12 END|
13 DELIMITER ;|
14
15
16 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT);
17
18 SET GLOBAL innodb_monitor_enable = module_sampling;
19
20 SELECT NAME,COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME='sampled_pages_read';
21
22 CALL prepare_data(30000);
23 ANALYZE TABLE t1 UPDATE HISTOGRAM ON b WITH 50 BUCKETS;
24 SELECT SCHEMA_NAME, TABLE_NAME, COLUMN_NAME FROM information_schema.column_statistics WHERE COLUMN_NAME = 'b';
25 DROP TABLE t1;
26
27 --replace_regex /[0-9]+/XX/
28 SELECT NAME,COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE SUBSYSTEM='sampling';
29
30 SET GLOBAL innodb_monitor_disable = module_sampling;
31 SET GLOBAL innodb_monitor_reset_all = "module_sampling";
32
33
34 --echo #
35 --echo # Cleanup
36 --echo #
37
38 SET GLOBAL innodb_monitor_enable = default;
39 SET GLOBAL innodb_monitor_disable = default;
40 SET GLOBAL innodb_monitor_reset_all = default;
41
42 DROP PROCEDURE prepare_data;