Debian Codegraph @

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

raw
1 # Tests for the performance schema
2
3 # ===========================================
4 # HELPER include/memory_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_memory_account;
22 drop prepare dump_memory_user;
23 drop prepare dump_memory_host;
24 drop prepare dump_memory_global;
25
26 drop prepare dump_users;
27 drop prepare dump_hosts;
28 drop prepare dump_accounts;
29
30 truncate table performance_schema.accounts;
31 truncate table performance_schema.users;
32 truncate table performance_schema.hosts;
33
34 truncate table performance_schema.setup_actors;
35 insert into performance_schema.setup_actors
36 select * from test.setup_actors;
37 drop table test.setup_actors;
38
39 update performance_schema.threads set instrumented='YES';
40 update performance_schema.setup_instruments set enabled='YES', timed='YES';
41
42 --enable_query_log
43