Debian Codegraph @

mysql-test/suite/innodb/t/events-merge-tmp-path.test

raw
1 ### test to check if performance_schema.events_waits_history_long
2 ### reflects correct data
3
4 update performance_schema.setup_instruments set enabled=IF(name='wait/io/file/innodb/innodb_temp_file','YES','NO');
5 update performance_schema.setup_consumers set enabled='YES';
6 use test;
7 CREATE TABLE `t1`(`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name1` varchar(180) NOT NULL, `name2` varchar(180) DEFAULT NULL, `name3` varchar(180) DEFAULT NULL, `name4` varchar(180) DEFAULT NULL, PRIMARY KEY (`id`,`name1`(10)) ) engine=InnoDB;
8 set @id:=0;
9
10 ### populate random data
11 insert into t1 values
12 (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
13 , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
14 , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
15 , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
16 insert into `t1`(`id`,`name1`,`name2`,`name3`,`name4`)
17 select @id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000) from
18 `t1` k1, `t1` k2, `t1` k3, `t1` k4,`t1` k5,`t1` k6;
19
20 #create inplace index and check if data is mention in events_waits_h
21 create index i_dtyp_big on `t1`(name1) algorithm=inplace;
22
23 --replace_regex /[\\\/]Innodb Merge Temp File/#Innodb Merge Temp File/
24 --replace_result $MYSQLTEST_VARDIR_ABS MYSQL_TEST_DIR
25
26 select distinct object_name from performance_schema.events_waits_history_long where event_name like '%wait%io%file%innodb%innodb_temp_file%'
27 and object_name like '%Innodb Merge Temp File%';
28 drop table t1;
29 update performance_schema.setup_instruments set enabled='YES';
30