Debian Codegraph @

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

raw
1 # ----------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # ----------------------------------------------------
4
5 # Test case to show behavior of statements digest when
6 # statement-digest-size is 0
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 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
15
16 # Executing queries
17 --source ../include/digest_execution.inc
18
19 --echo ####################################
20 --echo # QUERYING PS STATEMENT DIGEST
21 --echo ####################################
22 SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
23 SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
24
25
26 # Expect no digest
27 SHOW GLOBAL VARIABLES LIKE "performance_schema_digests_size";
28 SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_digest;
29
30 # Cleanup for Digest
31 --source ../include/digest_cleanup.inc
32