Debian Codegraph @

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

raw
1 # -----------------------------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # -----------------------------------------------------------------------
4
5 --source include/not_embedded.inc
6 --source include/have_perfschema.inc
7
8 SET sql_mode='NO_ENGINE_SUBSTITUTION';
9 # Initial Setup for Digest
10 --source ../include/digest_setup.inc
11
12 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
13
14 # Executing queries
15 --source ../include/digest_execution.inc
16
17 --echo ####################################
18 --echo # QUERYING PS STATEMENT DIGEST
19 --echo ####################################
20 SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
21 SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
22
23 # Cleanup for Digest
24 --source ../include/digest_cleanup.inc
25 SET sql_mode=default;