Debian Codegraph @

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

raw
1 #-------------------------------------------------------------
2 # Tests for PERFORMANCE_SCHEMA stored programs instrumentation
3 #-------------------------------------------------------------
4
5 #
6 # Test case to show the behaviour of stored program instrumentation
7 # when values of the system variables performance_schema_max_program_instances &
8 # performance_schema_max_statement_stack are zero.
9 # PS table will return empty set
10 #
11
12 --source include/not_embedded.inc
13 --source include/have_perfschema.inc
14 --source include/not_msan_with_debug.inc
15
16 --source ../include/start_server_common.inc
17
18 # Values of variables server variables
19 show global variables like "performance_schema_max_program_instances";
20 show global variables like "performance_schema_max_statement_stack";
21
22 --echo #####################
23 --echo # Setup
24 --echo #####################
25 --source suite/perfschema/include/program_nested_setup.inc
26
27 # Truncate summary table
28 TRUNCATE performance_schema.events_statements_summary_by_program;
29
30 --echo #####################
31 --echo # Executing Queries
32 --echo #####################
33 --source suite/perfschema/include/program_nested_execution.inc
34
35 --echo ###########################################
36 --echo # Quering PS statement summary table #
37 --echo ###########################################
38
39 SELECT OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA
40 FROM performance_schema.events_statements_summary_by_program;
41
42 SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_program;
43
44 --echo #####################
45 --echo # Cleanup
46 --echo #####################
47 --source suite/perfschema/include/program_nested_cleanup.inc
48
49