1# Tests for the performance schema 2 3# ========================================== 4# HELPER include/event_aggregate_cleanup.inc 5# ========================================== 6 7--disable_query_log 8revoke all privileges, grant option from user1@localhost; 9revoke all privileges, grant option from user2@localhost; 10revoke all privileges, grant option from user3@localhost; 11revoke all privileges, grant option from user4@localhost; 12drop user user1@localhost; 13drop user user2@localhost; 14drop user user3@localhost; 15drop user user4@localhost; 16flush privileges; 17 18drop procedure dump_thread; 19drop procedure dump_one_thread; 20 21drop prepare dump_waits_account; 22drop prepare dump_waits_user; 23drop prepare dump_waits_host; 24drop prepare dump_waits_history; 25drop prepare dump_waits_global; 26 27drop prepare dump_stages_account; 28drop prepare dump_stages_user; 29drop prepare dump_stages_host; 30drop prepare dump_stages_history; 31drop prepare dump_stages_global; 32 33drop prepare dump_statements_account; 34drop prepare dump_statements_user; 35drop prepare dump_statements_host; 36drop prepare dump_statements_history; 37drop prepare dump_statements_global; 38 39drop prepare dump_users; 40drop prepare dump_hosts; 41drop prepare dump_accounts; 42 43truncate table performance_schema.accounts; 44truncate table performance_schema.users; 45truncate table performance_schema.hosts; 46 47truncate table performance_schema.setup_actors; 48insert into performance_schema.setup_actors 49 select * from test.setup_actors; 50drop table test.setup_actors; 51drop table test.t1; 52 53update performance_schema.threads set instrumented='YES'; 54update performance_schema.setup_instruments set enabled='YES', timed='YES'; 55 56--enable_query_log 57 58