Debian Codegraph @

mysql-test/suite/perfschema/r/setup_object_table_lock_io.result

raw
1 drop table if exists test.setup_objects;
2 update performance_schema.setup_instruments set enabled='NO';
3 update performance_schema.setup_instruments set enabled='YES', timed='YES'
4 where name in ('wait/io/table/sql/handler', 'wait/lock/table/sql/handler');
5 truncate table performance_schema.table_io_waits_summary_by_table;
6 truncate table performance_schema.table_lock_waits_summary_by_table;
7 create table test.setup_objects as select * from performance_schema.setup_objects;
8 truncate table performance_schema.setup_objects;
9 select * from performance_schema.setup_objects;
10 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
11 insert into performance_schema.setup_objects
12 values ('TABLE', 'db1', 't1', 'YES', 'YES');
13 insert into performance_schema.setup_objects
14 values ('TABLE', 'db1', 't2', 'YES', 'YES');
15 select * from performance_schema.setup_objects
16 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
17 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
18 TABLE db1 t1 YES YES
19 TABLE db1 t2 YES YES
20 SET sql_mode = default;
21 drop database if exists db1;
22 create database db1;
23 create table db1.t1 (a int, b char(10) default 'default', unique key uidx(a));
24 create table db1.t2 (a int, b char(10) default 'default');
25 insert into db1.t1 values('11', 'db1.t1');
26 insert into db1.t1 values('12', 'db1.t1');
27 insert into db1.t1 values('13', 'db1.t1');
28 insert into db1.t2 values('21', 'db1.t2');
29 insert into db1.t2 values('22', 'db1.t2');
30 insert into db1.t2 values('23', 'db1.t2');
31 select OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_READ, COUNT_WRITE
32 from performance_schema.table_lock_waits_summary_by_table
33 where OBJECT_SCHEMA='db1';
34 OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_READ COUNT_WRITE
35 db1 t1 3 0 3
36 db1 t2 3 0 3
37 select OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_READ, COUNT_WRITE
38 from performance_schema.table_io_waits_summary_by_table
39 where OBJECT_SCHEMA='db1';
40 OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_READ COUNT_WRITE
41 db1 t1 3 0 3
42 db1 t2 3 0 3
43 update performance_schema.setup_objects
44 set ENABLED='NO' where OBJECT_SCHEMA = 'db1' and OBJECT_NAME='t1';
45 select OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_READ, COUNT_WRITE
46 from performance_schema.table_lock_waits_summary_by_table
47 where OBJECT_SCHEMA='db1';
48 OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_READ COUNT_WRITE
49 db1 t1 3 0 3
50 db1 t2 3 0 3
51 select OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_READ, COUNT_WRITE
52 from performance_schema.table_io_waits_summary_by_table
53 where OBJECT_SCHEMA='db1';
54 OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_READ COUNT_WRITE
55 db1 t1 3 0 3
56 db1 t2 3 0 3
57 update performance_schema.setup_objects
58 set ENABLED='YES' where OBJECT_SCHEMA = 'db1' and OBJECT_NAME='t1';
59 select OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_READ, COUNT_WRITE
60 from performance_schema.table_lock_waits_summary_by_table
61 where OBJECT_SCHEMA='db1';
62 OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_READ COUNT_WRITE
63 db1 t1 3 0 3
64 db1 t2 3 0 3
65 select OBJECT_SCHEMA, OBJECT_NAME, COUNT_STAR, COUNT_READ, COUNT_WRITE
66 from performance_schema.table_io_waits_summary_by_table
67 where OBJECT_SCHEMA='db1';
68 OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_READ COUNT_WRITE
69 db1 t1 3 0 3
70 db1 t2 3 0 3
71 truncate table performance_schema.setup_objects;
72 select count(*) from performance_schema.setup_objects;
73 count(*)
74 0
75 drop database db1;
76 truncate table performance_schema.setup_objects;
77 insert into performance_schema.setup_objects select * from test.setup_objects;
78 drop table test.setup_objects;
79 update performance_schema.setup_instruments set enabled='YES', timed='YES';