Debian Codegraph @

mysql-test/suite/perfschema/t/start_server_low_table_lock.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source ../include/start_server_common.inc
4
5 #############################
6 # Setup database and tables.
7 #############################
8 --disable_warnings
9 drop table if exists db1.t1;
10 drop database if exists db1;
11 --enable_warnings
12 create database db1;
13 create table db1.t1 (a int, b char(10) default 'default');
14
15 #######################
16 # Execute few queries.
17 #######################
18 insert into db1.t1 values('1', 'abc');
19 insert into db1.t1 values('2', 'abc');
20 select * from db1.t1 where a='1';
21
22 #####################################################
23 # Run few queries on Performance Schema stats tables.
24 #####################################################
25 # There should be 3 entries in following table. 2 for insert and 1 for select.
26 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
27 from performance_schema.table_lock_waits_summary_by_table
28 where OBJECT_SCHEMA='db1'
29 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
30
31 flush tables;
32
33 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
34 from performance_schema.table_lock_waits_summary_by_table
35 where OBJECT_SCHEMA='db1'
36 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
37
38 # Expect no TABLE_LOCK_STAT lost, we have room for 1 table lock for db1.t1
39 --disable_warnings
40 select variable_value from performance_schema.global_status
41 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST';
42 --enable_warnings
43
44 create table db1.t2 (a int, b char(10) default 'default',
45 unique key uidx(a));
46
47 #######################
48 # Execute few queries.
49 #######################
50 insert into db1.t1 values('3', 'abc');
51 insert into db1.t1 values('4', 'abc');
52 select * from db1.t1 where a='1';
53
54 insert into db1.t2 values('1', 'abc');
55 insert into db1.t2 values('2', 'abc');
56 select * from db1.t2 where a='1';
57
58 #####################################################
59 # Run few queries on Performance Schema stats tables.
60 #####################################################
61
62 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
63 from performance_schema.table_lock_waits_summary_by_table
64 where OBJECT_SCHEMA='db1'
65 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
66
67 flush tables;
68
69 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
70 from performance_schema.table_lock_waits_summary_by_table
71 where OBJECT_SCHEMA='db1'
72 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
73
74 # Expect TABLE_LOCK_STAT lost, we can not keep stats for db1.t2
75 --disable_warnings
76 select variable_value > 0 from performance_schema.global_status
77 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST';
78 --enable_warnings
79
80 flush status;
81
82
83 #######################################
84 # Update setup_objects to DISABLE TABLE
85 #######################################
86
87 update performance_schema.setup_objects set ENABLED='NO'
88 where OBJECT_TYPE='TABLE' and OBJECT_SCHEMA="%";
89
90 #######################
91 # Execute few queries.
92 #######################
93 insert into db1.t1 values('5', 'abc');
94 insert into db1.t1 values('6', 'abc');
95 select * from db1.t1 where a='1';
96
97 insert into db1.t2 values('3', 'abc');
98 insert into db1.t2 values('4', 'abc');
99 select * from db1.t2 where a='1';
100
101 # Empty, objects are disabled
102 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
103 from performance_schema.table_lock_waits_summary_by_table
104 where OBJECT_SCHEMA='db1'
105 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
106
107 flush tables;
108
109 # Empty, objects are disabled
110 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
111 from performance_schema.table_lock_waits_summary_by_table
112 where OBJECT_SCHEMA='db1'
113 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
114
115 # Do not expect lost counter in TABLE_LOCK_STAT
116 --disable_warnings
117 select variable_value from performance_schema.global_status
118 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST';
119 --enable_warnings
120
121 ###########
122 # Cleanup.
123 ###########
124 drop database db1;
125
126 update performance_schema.setup_objects set ENABLED='YES'
127 where OBJECT_TYPE='TABLE' and OBJECT_SCHEMA="%";
128
129 # The state is not reverting back to original, restart is needed if this
130 # case is to be tested again.
131 --source include/force_restart.inc