37 lines
1.2 KiB
Plaintext
37 lines
1.2 KiB
Plaintext
# ----------------------------------------------------
|
|
# Tests for the performance schema statement Digests.
|
|
# ----------------------------------------------------
|
|
|
|
--source include/xplugin_wait_for_interfaces.inc
|
|
# Test case to show behavior of statements digest when
|
|
# statement-digest-size is 0
|
|
|
|
# Initial Setup for Digest
|
|
--source ../include/digest_setup.inc
|
|
|
|
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
|
|
|
|
# Executing queries
|
|
--source ../include/digest_execution.inc
|
|
|
|
--echo ####################################
|
|
--echo # QUERYING PS STATEMENT DIGEST
|
|
--echo ####################################
|
|
SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
|
|
SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
|
|
|
|
|
|
SHOW GLOBAL VARIABLES LIKE "performance_schema_digests_size";
|
|
SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_digest;
|
|
|
|
select count(*)
|
|
from performance_schema.events_statements_histogram_by_digest;
|
|
|
|
select SCHEMA_NAME, DIGEST IS NULL, BUCKET_NUMBER
|
|
from performance_schema.events_statements_histogram_by_digest
|
|
where BUCKET_NUMBER= 1;
|
|
|
|
# Cleanup for Digest
|
|
--source ../include/digest_cleanup.inc
|
|
|