mirror of
https://github.com/MariaDB/server.git
synced 2026-02-09 12:18:41 +01:00
29a986a024
Test was affected by incompletely closed preceding connections. Make test agnostic to concurrent connections by querying performance_schema.events_statements_current only for connections that it uses.
40 lines
1.5 KiB
Text
40 lines
1.5 KiB
Text
# ----------------------------------------------------
|
|
# Tests for the performance schema statement Digests.
|
|
# ----------------------------------------------------
|
|
|
|
# Test case to show behavior of statements digest in combination of different
|
|
# consumers enabled/disabled
|
|
|
|
--source include/not_embedded.inc
|
|
--source include/have_perfschema.inc
|
|
|
|
# Initial Setup for Digest
|
|
--source ../include/digest_setup.inc
|
|
|
|
# -----------------------------------------
|
|
# Consumer State |
|
|
# -----------------------------------------
|
|
# statements_digest Enabled |
|
|
# events_statement_current Disabled |
|
|
# global_implementation Disabled ? |
|
|
# thread_implementation Disabled ? |
|
|
# -----------------------------------------
|
|
|
|
SELECT * FROM performance_schema.setup_consumers;
|
|
|
|
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 FROM performance_schema.events_statements_summary_by_digest;
|
|
SELECT digest, digest_text FROM performance_schema.events_statements_current
|
|
INNER JOIN performance_schema.threads
|
|
ON events_statements_current.thread_id=threads.thread_id
|
|
WHERE threads.processlist_id=connection_id();
|
|
|
|
# Cleanup for Digest
|
|
--source ../include/digest_cleanup.inc
|