Debian Codegraph @

mysql-test/suite/perfschema/include/event_aggregate_cleanup.inc

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