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