Debian Codegraph @

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

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