Debian Codegraph @

mysql-test/suite/perfschema/t/start_server_off.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5
6 --source ../include/start_server_common.inc
7
8 select * from information_schema.engines
9 where engine = "PERFORMANCE_SCHEMA";
10
11 # Expecting all off / zero
12 show status like "performance_schema%";
13 show variables like "performance_schema";
14
15 # Expect all consumers disabled
16
17 select * from performance_schema.setup_consumers;
18
19 # Expect no instruments
20
21 select * from performance_schema.setup_instruments;
22
23 select * from performance_schema.setup_actors;
24 select * from performance_schema.setup_objects;
25 select * from performance_schema.setup_timers;
26
27 # Expect INSERT to fail with an error
28
29 --error ER_WRONG_PERFSCHEMA_USAGE
30 insert into performance_schema.setup_objects values ('TABLE', 'myschema', 'myobject', 'YES', 'YES');
31
32 --error ER_WRONG_PERFSCHEMA_USAGE
33 insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole', 'YES', 'YES');
34
35 # Expect SELECT, UPDATE, DELETE and TRUNCATE to affect 0 rows, but with
36 # no error because the target row(s) will not be found
37
38 select * from performance_schema.setup_objects;
39 update performance_schema.setup_objects set OBJECT_NAME = 'myobject';
40 delete from performance_schema.setup_objects;
41
42 select * from performance_schema.setup_actors;
43 update performance_schema.setup_actors set HOST = 'myhost';
44 delete from performance_schema.setup_actors;
45
46 truncate performance_schema.events_stages_history_long;
47 truncate performance_schema.events_statements_history_long;
48 truncate performance_schema.events_waits_history_long;
49 truncate performance_schema.setup_objects;
50 truncate performance_schema.setup_actors;
51
52 --disable_warnings
53 # Expect that status variables are still accessible
54 show global status like "performance_schema%";
55 show session status like "performance_schema%";
56 --enable_warnings