Debian Codegraph @

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

raw
1 --source include/not_embedded.inc
2 --source include/have_perfschema.inc
3 --source include/no_protocol.inc
4
5 --source ../include/start_server_common.inc
6
7 CREATE DATABASE db;
8 USE db;
9
10 # Expect no history
11
12 show global variables like "performance_schema_max_prepared_statements_instances";
13 select count(*) from performance_schema.prepared_statements_instances;
14
15 # Valid operation, edge case
16
17 truncate table performance_schema.prepared_statements_instances;
18
19 # Prepare statements
20 --source suite/perfschema/include/prepared_stmts_setup.inc
21
22 # check the lost status
23 show global status like "%performance_schema_prepared_statements_lost%";
24
25 # Execute statements
26 --source suite/perfschema/include/prepared_stmts_execution.inc
27
28 # check the lost status
29 show global status like "%performance_schema_prepared_statements_lost%";
30
31 # deallocate prepared statements
32 --source suite/perfschema/include/prepared_stmts_deallocation.inc
33
34 # check the lost status
35 show global status like "%performance_schema_prepared_statements_lost%";
36
37 # Flush status now
38 flush global status;
39
40 # status after flush. expect 0.
41 show global status like "%performance_schema_prepared_statements_lost%";
42
43 DROP DATABASE db;