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 # Initial Setup for Digest
9 --source ../include/digest_setup.inc
10
11 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
12
13 # Executing queries
14 --source ../include/digest_execution.inc
15
16 --echo ####################################
17 --echo # QUERYING PS STATEMENT DIGEST
18 --echo ####################################
19 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
20 SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
21
22
23 # Expect no digest
24 SHOW GLOBAL VARIABLES LIKE "performance_schema_digests_size";
25 SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_digest;
26
27 # Cleanup for Digest
28 --source ../include/digest_cleanup.inc
29