From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../perfschema/include/event_aggregate_cleanup.inc | 64 ++++++++++++++++++++++ 1 file changed, 64 insertions(+) create mode 100644 mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc (limited to 'mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc') diff --git a/mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc b/mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc new file mode 100644 index 00000000..2cb8a69e --- /dev/null +++ b/mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc @@ -0,0 +1,64 @@ +# Tests for the performance schema + +# ========================================== +# HELPER include/event_aggregate_cleanup.inc +# ========================================== + +--disable_query_log +revoke all privileges, grant option from user1@localhost; +revoke all privileges, grant option from user2@localhost; +revoke all privileges, grant option from user3@localhost; +revoke all privileges, grant option from user4@localhost; +drop user user1@localhost; +drop user user2@localhost; +drop user user3@localhost; +drop user user4@localhost; +flush privileges; + +drop procedure dump_thread; +drop procedure dump_one_thread; + +drop prepare dump_waits_account; +drop prepare dump_waits_user; +drop prepare dump_waits_host; +drop prepare dump_waits_history; +drop prepare dump_waits_global; + +drop prepare dump_stages_account; +drop prepare dump_stages_user; +drop prepare dump_stages_host; +drop prepare dump_stages_history; +drop prepare dump_stages_global; + +drop prepare dump_statements_account; +drop prepare dump_statements_user; +drop prepare dump_statements_host; +drop prepare dump_statements_history; +drop prepare dump_statements_global; + +drop prepare dump_transactions_account; +drop prepare dump_transactions_user; +drop prepare dump_transactions_host; +drop prepare dump_transactions_history; +drop prepare dump_transactions_global; + +drop prepare dump_users; +drop prepare dump_hosts; +drop prepare dump_accounts; + +truncate table performance_schema.accounts; +truncate table performance_schema.users; +truncate table performance_schema.hosts; + +truncate table performance_schema.setup_actors; +insert into performance_schema.setup_actors + select * from test.setup_actors; +drop table test.setup_actors; +drop table test.t1; +drop function test.f; + +update performance_schema.threads set instrumented='YES'; +update performance_schema.setup_instruments set enabled='YES', timed='YES'; + +--enable_query_log + -- cgit v1.2.3