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 --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 Enabled |
18 # events_statement_current Disabled |
19 # global_implementation Disabled ? |
20 # thread_implementation Disabled ? |
21 # -----------------------------------------
22
23 SELECT * FROM performance_schema.setup_consumers;
24
25 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
26
27 # Executing queries
28 --source ../include/digest_execution.inc
29
30 --echo ####################################
31 --echo # QUERYING PS STATEMENT DIGEST
32 --echo ####################################
33 SELECT schema_name, digest, digest_text, count_star FROM performance_schema.events_statements_summary_by_digest;
34 SELECT digest, digest_text FROM performance_schema.events_statements_current
35 INNER JOIN performance_schema.threads
36 ON events_statements_current.thread_id=threads.thread_id
37 WHERE threads.processlist_id=connection_id();
38
39 # Cleanup for Digest
40 --source ../include/digest_cleanup.inc