Debian Codegraph @

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

raw
1 # Tests for the performance schema
2 #
3
4 # See comments in include/table_aggregate_setup.inc
5
6 --disable_query_log
7
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 drop prepare dump_waits_account;
21 drop prepare dump_waits_user;
22 drop prepare dump_waits_host;
23 drop prepare dump_waits_global;
24 drop prepare dump_waits_history;
25 drop prepare dump_waits_index_io;
26 drop prepare dump_waits_table_io;
27 drop prepare dump_waits_table_lock;
28 drop prepare dump_objects_summary;
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 truncate table performance_schema.setup_objects;
40 insert into performance_schema.setup_objects
41 select * from test.setup_objects;
42 drop table test.setup_objects;
43
44 drop table test.t1;
45 drop table test.t2;
46 drop table test.t3;
47
48 update performance_schema.threads set instrumented='YES';
49 update performance_schema.setup_instruments set enabled='YES', timed='YES';
50 update performance_schema.setup_consumers set enabled='YES';
51
52 --enable_query_log
53