Debian Codegraph @

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

raw
1 # ----------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # ----------------------------------------------------
4
5 # Test case to show behavior of statements digest in combination of different
6 # consumers enabled/disabled
7
8 --source include/not_embedded.inc
9 --source include/have_perfschema.inc
10
11 # Initial Setup for Digest
12 --source ../include/digest_setup.inc
13
14 # -----------------------------------------
15 # Consumer State |
16 # -----------------------------------------
17 # statements_digest Disabled |
18 # events_statement_current Enabled |
19 # -----------------------------------------
20
21 SELECT * FROM performance_schema.setup_consumers;
22
23 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
24
25 # Executing queries
26 --source ../include/digest_execution.inc
27
28 --echo ####################################
29 --echo # QUERYING PS STATEMENT DIGEST
30 --echo ####################################
31 SELECT schema_name,digest_text, count_star FROM performance_schema.events_statements_summary_by_digest;
32 SELECT digest_text FROM performance_schema.events_statements_current;
33
34 # Cleanup for Digest
35 --source ../include/digest_cleanup.inc