Debian Codegraph @

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

raw
1 # ----------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # ----------------------------------------------------
4
5 --source include/xplugin_wait_for_interfaces.inc
6 # Test case to show behavior of statements digest when
7 # statement-digest-size is 0
8
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, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
21 SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
22
23
24 SHOW GLOBAL VARIABLES LIKE "performance_schema_digests_size";
25 SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_digest;
26
27 select count(*)
28 from performance_schema.events_statements_histogram_by_digest;
29
30 select SCHEMA_NAME, DIGEST IS NULL, BUCKET_NUMBER
31 from performance_schema.events_statements_histogram_by_digest
32 where BUCKET_NUMBER= 1;
33
34 # Cleanup for Digest
35 --source ../include/digest_cleanup.inc
36