Debian Codegraph @

mysql-test/suite/perfschema/t/statement_digest_consumers2.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 # Initial Setup for Digest
9 --source ../include/digest_setup.inc
10
11 # -----------------------------------------
12 # Consumer State |
13 # -----------------------------------------
14 # statements_digest Enabled |
15 # events_statement_current Disabled |
16 # global_implementation Disabled ? |
17 # thread_implementation Disabled ? |
18 # -----------------------------------------
19
20 SELECT * FROM performance_schema.setup_consumers;
21
22 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
23
24 # Executing queries
25 --source ../include/digest_execution.inc
26
27 --echo ####################################
28 --echo # QUERYING PS STATEMENT DIGEST
29 --echo ####################################
30 SELECT schema_name, digest, digest_text, count_star FROM performance_schema.events_statements_summary_by_digest WHERE schema_name IS NOT NULL;
31 SELECT digest, digest_text FROM performance_schema.events_statements_current WHERE source NOT LIKE 'srv_session.cc%';
32
33 # Cleanup for Digest
34 --source ../include/digest_cleanup.inc