Debian Codegraph @

mysql-test/suite/perfschema/r/statement_program_lost_inst.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 15
15 select count(*) > 4 from performance_schema.setup_instruments;
16 count(*) > 4
17 1
18 select count(*) from performance_schema.setup_timers;
19 count(*)
20 5
21 Warnings:
22 Warning 1287 'performance_schema.setup_timers' is deprecated and will be removed in a future release
23 select * from performance_schema.accounts;
24 select * from performance_schema.cond_instances;
25 select * from performance_schema.events_stages_current;
26 select * from performance_schema.events_stages_history;
27 select * from performance_schema.events_stages_history_long;
28 select * from performance_schema.events_stages_summary_by_account_by_event_name;
29 select * from performance_schema.events_stages_summary_by_host_by_event_name;
30 select * from performance_schema.events_stages_summary_by_thread_by_event_name;
31 select * from performance_schema.events_stages_summary_by_user_by_event_name;
32 select * from performance_schema.events_stages_summary_global_by_event_name;
33 select * from performance_schema.events_statements_current;
34 select * from performance_schema.events_statements_history;
35 select * from performance_schema.events_statements_history_long;
36 select * from performance_schema.events_statements_summary_by_account_by_event_name;
37 select * from performance_schema.events_statements_summary_by_digest;
38 select * from performance_schema.events_statements_summary_by_host_by_event_name;
39 select * from performance_schema.events_statements_summary_by_thread_by_event_name;
40 select * from performance_schema.events_statements_summary_by_user_by_event_name;
41 select * from performance_schema.events_statements_summary_global_by_event_name;
42 select * from performance_schema.events_transactions_current;
43 select * from performance_schema.events_transactions_history;
44 select * from performance_schema.events_transactions_history_long;
45 select * from performance_schema.events_transactions_summary_by_account_by_event_name;
46 select * from performance_schema.events_transactions_summary_by_host_by_event_name;
47 select * from performance_schema.events_transactions_summary_by_thread_by_event_name;
48 select * from performance_schema.events_transactions_summary_by_user_by_event_name;
49 select * from performance_schema.events_transactions_summary_global_by_event_name;
50 select * from performance_schema.events_waits_current;
51 select * from performance_schema.events_waits_history;
52 select * from performance_schema.events_waits_history_long;
53 select * from performance_schema.events_waits_summary_by_account_by_event_name;
54 select * from performance_schema.events_waits_summary_by_host_by_event_name;
55 select * from performance_schema.events_waits_summary_by_instance;
56 select * from performance_schema.events_waits_summary_by_thread_by_event_name;
57 select * from performance_schema.events_waits_summary_by_user_by_event_name;
58 select * from performance_schema.events_waits_summary_global_by_event_name;
59 select * from performance_schema.memory_summary_by_account_by_event_name;
60 select * from performance_schema.memory_summary_by_host_by_event_name;
61 select * from performance_schema.memory_summary_by_thread_by_event_name;
62 select * from performance_schema.memory_summary_by_user_by_event_name;
63 select * from performance_schema.memory_summary_global_by_event_name;
64 select * from performance_schema.file_instances;
65 select * from performance_schema.file_summary_by_event_name;
66 select * from performance_schema.file_summary_by_instance;
67 select * from performance_schema.host_cache;
68 select * from performance_schema.hosts;
69 select * from performance_schema.memory_summary_by_account_by_event_name;
70 select * from performance_schema.memory_summary_by_host_by_event_name;
71 select * from performance_schema.memory_summary_by_thread_by_event_name;
72 select * from performance_schema.memory_summary_by_user_by_event_name;
73 select * from performance_schema.memory_summary_global_by_event_name;
74 select * from performance_schema.metadata_locks;
75 select * from performance_schema.mutex_instances;
76 select * from performance_schema.objects_summary_global_by_type;
77 select * from performance_schema.performance_timers;
78 select * from performance_schema.rwlock_instances;
79 select * from performance_schema.session_account_connect_attrs;
80 select * from performance_schema.session_connect_attrs;
81 select * from performance_schema.setup_actors;
82 select * from performance_schema.setup_consumers;
83 select * from performance_schema.setup_instruments;
84 select * from performance_schema.setup_objects;
85 select * from performance_schema.setup_timers;
86 select * from performance_schema.socket_instances;
87 select * from performance_schema.socket_summary_by_instance;
88 select * from performance_schema.socket_summary_by_event_name;
89 select * from performance_schema.table_handles;
90 select * from performance_schema.table_io_waits_summary_by_index_usage;
91 select * from performance_schema.table_io_waits_summary_by_table;
92 select * from performance_schema.table_lock_waits_summary_by_table;
93 select * from performance_schema.threads;
94 select * from performance_schema.users;
95 select * from performance_schema.replication_connection_configuration;
96 select * from performance_schema.replication_applier_configuration;
97 select * from performance_schema.replication_applier_status;
98 select * from performance_schema.replication_applier_status_by_coordinator;
99 select * from performance_schema.global_status;
100 select * from performance_schema.status_by_thread;
101 select * from performance_schema.status_by_user;
102 select * from performance_schema.status_by_host;
103 select * from performance_schema.status_by_account;
104 select * from performance_schema.session_status;
105 show global variables like "performance_schema%";
106 Variable_name Value
107 performance_schema ON
108 performance_schema_accounts_size 100
109 performance_schema_digests_size 200
110 performance_schema_events_stages_history_long_size 1000
111 performance_schema_events_stages_history_size 10
112 performance_schema_events_statements_history_long_size 1000
113 performance_schema_events_statements_history_size 10
114 performance_schema_events_transactions_history_long_size 1000
115 performance_schema_events_transactions_history_size 10
116 performance_schema_events_waits_history_long_size 10000
117 performance_schema_events_waits_history_size 10
118 performance_schema_hosts_size 100
119 performance_schema_max_cond_classes 90
120 performance_schema_max_cond_instances 1500
121 performance_schema_max_digest_length 1024
122 performance_schema_max_file_classes 80
123 performance_schema_max_file_handles 32768
124 performance_schema_max_file_instances 10000
125 performance_schema_max_index_stat 5000
126 performance_schema_max_memory_classes 320
127 performance_schema_max_metadata_locks 10000
128 performance_schema_max_mutex_classes 210
129 performance_schema_max_mutex_instances 5000
130 performance_schema_max_prepared_statements_instances 100
131 performance_schema_max_program_instances 7
132 performance_schema_max_rwlock_classes 50
133 performance_schema_max_rwlock_instances 5000
134 performance_schema_max_socket_classes 10
135 performance_schema_max_socket_instances 1000
136 performance_schema_max_sql_text_length 1024
137 performance_schema_max_stage_classes 160
138 performance_schema_max_statement_classes 223
139 performance_schema_max_statement_stack 2
140 performance_schema_max_table_handles 1000
141 performance_schema_max_table_instances 500
142 performance_schema_max_table_lock_stat 500
143 performance_schema_max_thread_classes 50
144 performance_schema_max_thread_instances 400
145 performance_schema_session_connect_attrs_size 2048
146 performance_schema_setup_actors_size 100
147 performance_schema_setup_objects_size 100
148 performance_schema_users_size 100
149 show engine PERFORMANCE_SCHEMA status;
150 show global status like "performance_schema%";
151 show global variables like "performance_schema_max_program_instances";
152 Variable_name Value
153 performance_schema_max_program_instances 7
154 show global variables like "performance_schema_max_statement_stack";
155 Variable_name Value
156 performance_schema_max_statement_stack 2
157 #####################
158 # Setup
159 #####################
160 # SET-UP
161 CREATE DATABASE nested_sp;
162 USE nested_sp;
163 CREATE TABLE t1(
164 id CHAR(16) NOT NULL DEFAULT '',
165 data INT NOT NULL
166 );
167 CREATE TABLE t2(
168 n INT UNSIGNED NOT NULL,
169 f BIGINT UNSIGNED
170 );
171 ############################
172 # Creating Stored Programs #
173 ############################
174 CREATE PROCEDURE c1(x INT)
175 CALL c2("c", x)|
176 CREATE PROCEDURE c2(s CHAR(16), x INT)
177 CALL c3(x, s)|
178 CREATE PROCEDURE c3(x INT, s CHAR(16))
179 CALL c4("level", x, s)|
180 CREATE PROCEDURE c4(l CHAR(8), x INT, s CHAR(16))
181 INSERT INTO t1 VALUES (concat(l,s), x)|
182 CREATE PROCEDURE iotest(x1 CHAR(16), x2 CHAR(16), y INT)
183 BEGIN
184 CALL inc2(x2, y);
185 INSERT INTO t1 VALUES (x1, y);
186 END|
187 CREATE PROCEDURE inc2(x CHAR(16), y INT)
188 BEGIN
189 CALL inc(y);
190 INSERT INTO t1 VALUES (x, y);
191 END|
192 CREATE PROCEDURE inc(inout io INT)
193 SET io = io + 1|
194 CREATE FUNCTION mul(x INT, y INT) RETURNS INT
195 RETURN x*y|
196 CREATE FUNCTION inc(i INT) RETURNS INT
197 RETURN i+1|
198 CREATE FUNCTION fac(n INT UNSIGNED) RETURNS BIGINT UNSIGNED
199 BEGIN
200 DECLARE f BIGINT UNSIGNED DEFAULT 1;
201 WHILE n > 1 DO
202 SET f = f * n;
203 SET n = n - 1;
204 END WHILE;
205 RETURN f;
206 END|
207 CREATE FUNCTION fun(i INT, u INT UNSIGNED) RETURNS DOUBLE
208 RETURN mul(inc(i), fac(u))|
209 CREATE PROCEDURE ifac(n INT UNSIGNED)
210 BEGIN
211 DECLARE i BIGINT UNSIGNED DEFAULT 1;
212 IF n > 20 THEN
213 SET n = 20; # bigint overflow otherwise
214 END IF;
215 WHILE i <= n DO
216 BEGIN
217 INSERT INTO t2 VALUES (i, fac(i));
218 SET i = i + 1;
219 END;
220 END WHILE;
221 END|
222 CREATE TRIGGER trg AFTER INSERT ON t1 FOR EACH ROW
223 CALL ifac(10)|
224 TRUNCATE performance_schema.events_statements_summary_by_program;
225 SELECT OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA FROM
226 performance_schema.events_statements_summary_by_program
227 WHERE OBJECT_SCHEMA='nested_sp' ORDER BY OBJECT_NAME;
228 OBJECT_TYPE OBJECT_NAME OBJECT_SCHEMA
229 Flush status;
230 show global status like "%performance_schema_program_lost%";
231 Variable_name Value
232 Performance_schema_program_lost 0
233 show global status like "%performance_schema_nested_statement_lost%";
234 Variable_name Value
235 Performance_schema_nested_statement_lost 0
236 #####################
237 # Executing Queries
238 #####################
239 #####################
240 # Executing queries #
241 #####################
242 CALL c1(42);
243 SELECT * FROM t1;
244 id data
245 levelc 42
246 DELETE FROM t1;
247 CALL iotest("io1", "io2", 1);
248 SELECT * FROM t1 ORDER BY data DESC;
249 id data
250 io2 2
251 io1 1
252 DELETE FROM t1;
253 SELECT fun(6,10);
254 fun(6,10)
255 25401600
256 INSERT INTO t1 VALUES (20,13);
257 SELECT * FROM t2;
258 n f
259 1 1
260 2 2
261 3 6
262 4 24
263 5 120
264 6 720
265 7 5040
266 8 40320
267 9 362880
268 10 3628800
269 1 1
270 2 2
271 3 6
272 4 24
273 5 120
274 6 720
275 7 5040
276 8 40320
277 9 362880
278 10 3628800
279 1 1
280 2 2
281 3 6
282 4 24
283 5 120
284 6 720
285 7 5040
286 8 40320
287 9 362880
288 10 3628800
289 1 1
290 2 2
291 3 6
292 4 24
293 5 120
294 6 720
295 7 5040
296 8 40320
297 9 362880
298 10 3628800
299 ###########################################
300 # Quering PS statement summary table #
301 ###########################################
302 SELECT OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA
303 FROM performance_schema.events_statements_summary_by_program
304 WHERE OBJECT_SCHEMA='nested_sp' ORDER BY OBJECT_NAME;
305 OBJECT_TYPE OBJECT_NAME OBJECT_SCHEMA
306 PROCEDURE c1 nested_sp
307 PROCEDURE c2 nested_sp
308 PROCEDURE c3 nested_sp
309 PROCEDURE c4 nested_sp
310 FUNCTION fac nested_sp
311 PROCEDURE ifac nested_sp
312 TRIGGER trg nested_sp
313 show global status like "%performance_schema_program_lost%";
314 Variable_name Value
315 Performance_schema_program_lost 6
316 show global status like "%performance_schema_nested_statement_lost%";
317 Variable_name Value
318 Performance_schema_nested_statement_lost 1062
319 #####################
320 # Cleanup
321 #####################
322 DROP PROCEDURE c4;
323 DROP PROCEDURE c3;
324 DROP PROCEDURE c2;
325 DROP PROCEDURE c1;
326 DROP PROCEDURE inc;
327 DROP PROCEDURE inc2;
328 DROP PROCEDURE iotest;
329 DROP FUNCTION mul;
330 DROP FUNCTION inc;
331 DROP FUNCTION fac;
332 DROP FUNCTION fun;
333 DROP PROCEDURE ifac;
334 DROP TRIGGER trg;
335 DROP TABLE t1,t2;
336 DROP DATABASE nested_sp;