Debian Codegraph @

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

raw
1 show databases;
2 Database
3 information_schema
4 mtr
5 mysql
6 performance_schema
7 sys
8 test
9 select count(*) from performance_schema.performance_timers;
10 count(*)
11 5
12 select count(*) from performance_schema.setup_consumers;
13 count(*)
14 16
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 1
18 select * from performance_schema.accounts;
19 select * from performance_schema.cond_instances;
20 select * from performance_schema.events_stages_current;
21 select * from performance_schema.events_stages_history;
22 select * from performance_schema.events_stages_history_long;
23 select * from performance_schema.events_stages_summary_by_account_by_event_name;
24 select * from performance_schema.events_stages_summary_by_host_by_event_name;
25 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
26 select * from performance_schema.events_stages_summary_by_user_by_event_name;
27 select * from performance_schema.events_stages_summary_global_by_event_name;
28 select * from performance_schema.events_statements_current;
29 select * from performance_schema.events_statements_histogram_by_digest;
30 select * from performance_schema.events_statements_histogram_global;
31 select * from performance_schema.events_statements_history;
32 select * from performance_schema.events_statements_history_long;
33 select * from performance_schema.events_statements_summary_by_account_by_event_name;
34 select * from performance_schema.events_statements_summary_by_digest;
35 select * from performance_schema.events_statements_summary_by_host_by_event_name;
36 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
37 select * from performance_schema.events_statements_summary_by_user_by_event_name;
38 select * from performance_schema.events_statements_summary_global_by_event_name;
39 select * from performance_schema.events_transactions_current;
40 select * from performance_schema.events_transactions_history;
41 select * from performance_schema.events_transactions_history_long;
42 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
43 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
44 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
45 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
46 select * from performance_schema.events_transactions_summary_global_by_event_name;
47 select * from performance_schema.events_waits_current;
48 select * from performance_schema.events_waits_history;
49 select * from performance_schema.events_waits_history_long;
50 select * from performance_schema.events_waits_summary_by_account_by_event_name;
51 select * from performance_schema.events_waits_summary_by_host_by_event_name;
52 select * from performance_schema.events_waits_summary_by_instance;
53 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
54 select * from performance_schema.events_waits_summary_by_user_by_event_name;
55 select * from performance_schema.events_waits_summary_global_by_event_name;
56 select * from performance_schema.memory_summary_by_account_by_event_name;
57 select * from performance_schema.memory_summary_by_host_by_event_name;
58 select * from performance_schema.memory_summary_by_thread_by_event_name;
59 select * from performance_schema.memory_summary_by_user_by_event_name;
60 select * from performance_schema.memory_summary_global_by_event_name;
61 select * from performance_schema.events_errors_summary_by_account_by_error;
62 select * from performance_schema.events_errors_summary_by_host_by_error;
63 select * from performance_schema.events_errors_summary_by_thread_by_error;
64 select * from performance_schema.events_errors_summary_by_user_by_error;
65 select * from performance_schema.events_errors_summary_global_by_error;
66 select * from performance_schema.file_instances;
67 select * from performance_schema.file_summary_by_event_name;
68 select * from performance_schema.file_summary_by_instance;
69 select * from performance_schema.host_cache;
70 select * from performance_schema.hosts;
71 select * from performance_schema.memory_summary_by_account_by_event_name;
72 select * from performance_schema.memory_summary_by_host_by_event_name;
73 select * from performance_schema.memory_summary_by_thread_by_event_name;
74 select * from performance_schema.memory_summary_by_user_by_event_name;
75 select * from performance_schema.memory_summary_global_by_event_name;
76 select * from performance_schema.metadata_locks;
77 select * from performance_schema.mutex_instances;
78 select * from performance_schema.objects_summary_global_by_type;
79 select * from performance_schema.performance_timers;
80 select * from performance_schema.rwlock_instances;
81 select * from performance_schema.data_locks;
82 select * from performance_schema.data_lock_waits;
83 select * from performance_schema.session_account_connect_attrs;
84 select * from performance_schema.session_connect_attrs;
85 select * from performance_schema.setup_actors;
86 select * from performance_schema.setup_consumers;
87 select * from performance_schema.setup_instruments;
88 select * from performance_schema.setup_objects;
89 select * from performance_schema.setup_threads;
90 select * from performance_schema.socket_instances;
91 select * from performance_schema.socket_summary_by_instance;
92 select * from performance_schema.socket_summary_by_event_name;
93 select * from performance_schema.table_handles;
94 select * from performance_schema.table_io_waits_summary_by_index_usage;
95 select * from performance_schema.table_io_waits_summary_by_table;
96 select * from performance_schema.table_lock_waits_summary_by_table;
97 select * from performance_schema.threads;
98 select * from performance_schema.users;
99 select * from performance_schema.replication_connection_configuration;
100 select * from performance_schema.replication_connection_status;
101 select * from performance_schema.replication_applier_configuration;
102 select * from performance_schema.replication_applier_status;
103 select * from performance_schema.replication_applier_status_by_coordinator;
104 select * from performance_schema.replication_applier_status_by_worker;
105 select * from performance_schema.global_status;
106 select * from performance_schema.status_by_thread;
107 select * from performance_schema.status_by_user;
108 select * from performance_schema.status_by_host;
109 select * from performance_schema.status_by_account;
110 select * from performance_schema.session_status;
111 select * from performance_schema.global_variables;
112 select * from performance_schema.variables_by_thread;
113 select * from performance_schema.session_variables;
114 show engine PERFORMANCE_SCHEMA status;
115 show global status like "performance_schema%";
116 drop table if exists db1.t1;
117 drop database if exists db1;
118 create database db1;
119 create table db1.t1 (a int, b char(10) default 'default');
120 insert into db1.t1 values('1', 'abc');
121 insert into db1.t1 values('2', 'abc');
122 select * from db1.t1 where a='1';
123 a b
124 1 abc
125 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
126 from performance_schema.table_lock_waits_summary_by_table
127 where OBJECT_SCHEMA='db1'
128 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
129 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
130 3 TABLE db1 t1
131 flush tables;
132 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
133 from performance_schema.table_lock_waits_summary_by_table
134 where OBJECT_SCHEMA='db1'
135 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
136 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
137 3 TABLE db1 t1
138 select variable_value from performance_schema.global_status
139 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST';
140 variable_value
141 0
142 create table db1.t2 (a int, b char(10) default 'default',
143 unique key uidx(a));
144 insert into db1.t1 values('3', 'abc');
145 insert into db1.t1 values('4', 'abc');
146 select * from db1.t1 where a='1';
147 a b
148 1 abc
149 insert into db1.t2 values('1', 'abc');
150 insert into db1.t2 values('2', 'abc');
151 select * from db1.t2 where a='1';
152 a b
153 1 abc
154 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
155 from performance_schema.table_lock_waits_summary_by_table
156 where OBJECT_SCHEMA='db1'
157 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
158 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
159 6 TABLE db1 t1
160 3 TABLE db1 t2
161 flush tables;
162 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
163 from performance_schema.table_lock_waits_summary_by_table
164 where OBJECT_SCHEMA='db1'
165 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
166 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
167 6 TABLE db1 t1
168 0 TABLE db1 t2
169 select variable_value > 0 from performance_schema.global_status
170 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST';
171 variable_value > 0
172 1
173 flush status;
174 update performance_schema.setup_objects set ENABLED='NO'
175 where OBJECT_TYPE='TABLE' and OBJECT_SCHEMA="%";
176 insert into db1.t1 values('5', 'abc');
177 insert into db1.t1 values('6', 'abc');
178 select * from db1.t1 where a='1';
179 a b
180 1 abc
181 insert into db1.t2 values('3', 'abc');
182 insert into db1.t2 values('4', 'abc');
183 select * from db1.t2 where a='1';
184 a b
185 1 abc
186 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
187 from performance_schema.table_lock_waits_summary_by_table
188 where OBJECT_SCHEMA='db1'
189 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
190 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
191 6 TABLE db1 t1
192 0 TABLE db1 t2
193 flush tables;
194 select COUNT_STAR, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
195 from performance_schema.table_lock_waits_summary_by_table
196 where OBJECT_SCHEMA='db1'
197 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
198 COUNT_STAR OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME
199 6 TABLE db1 t1
200 0 TABLE db1 t2
201 select variable_value from performance_schema.global_status
202 where variable_name like 'PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST';
203 variable_value
204 0
205 drop database db1;
206 update performance_schema.setup_objects set ENABLED='YES'
207 where OBJECT_TYPE='TABLE' and OBJECT_SCHEMA="%";