Debian Codegraph @

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

raw
1
2 ================================================================================
3 SETUP
4 ================================================================================
5 connect con1, localhost, root,,;
6 CREATE TABLE test.t1 (c1 INT);
7 PREPARE stmt1 FROM "SELECT c1 FROM test.t1";
8 EXECUTE stmt1;
9 c1
10 SHOW SESSION STATUS LIKE "%com_stmt_%prepare%";
11 Variable_name Value
12 Com_stmt_prepare 1
13 Com_stmt_reprepare 0
14 SELECT * FROM performance_schema.session_status WHERE VARIABLE_NAME LIKE "%com_stmt%";
15 VARIABLE_NAME VARIABLE_VALUE
16 Com_stmt_reprepare 0
17 SELECT VARIABLE_VALUE INTO @count_global_reprepare_before
18 FROM performance_schema.global_status
19 WHERE VARIABLE_NAME LIKE "Com_stmt_reprepare";
20 ALTER TABLE test.t1 ADD COLUMN c2 INTEGER;
21 EXECUTE stmt1;
22 c1
23 SHOW SESSION STATUS LIKE "%com_stmt_%prepare%";
24 Variable_name Value
25 Com_stmt_prepare 2
26 Com_stmt_reprepare 1
27 SELECT * FROM performance_schema.session_status WHERE VARIABLE_NAME LIKE "%com_stmt%";
28 VARIABLE_NAME VARIABLE_VALUE
29 Com_stmt_reprepare 1
30 SELECT VARIABLE_VALUE INTO @count_global_reprepare_after
31 FROM performance_schema.global_status
32 WHERE VARIABLE_NAME LIKE "Com_stmt_reprepare";
33 SELECT @count_global_reprepare_after - @count_global_reprepare_before;
34 @count_global_reprepare_after - @count_global_reprepare_before
35 1
36
37 ================================================================================
38 CLEANUP
39 ================================================================================
40 DROP TABLE test.t1;
41 disconnect con1;
42 connection default;