Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.events_waits_summary_by_instance
5 where event_name like 'Wait/Synch/%' limit 1;
6
7 select * from performance_schema.events_waits_summary_by_instance
8 where event_name='FOO';
9
10 select * from performance_schema.events_waits_summary_by_instance
11 order by count_star limit 1;
12
13 select * from performance_schema.events_waits_summary_by_instance
14 order by count_star desc limit 1;
15
16 select * from performance_schema.events_waits_summary_by_instance
17 where min_timer_wait > 0 order by count_star limit 1;
18
19 select * from performance_schema.events_waits_summary_by_instance
20 where min_timer_wait > 0 order by count_star desc limit 1;
21 --enable_result_log
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 insert into performance_schema.events_waits_summary_by_instance
25 set event_name='FOO', object_instance_begin=0,
26 count_star=1, sum_timer_wait=2, min_timer_wait=3,
27 avg_timer_wait=4, max_timer_wait=5;
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 update performance_schema.events_waits_summary_by_instance
31 set count_star=12;
32
33 --error ER_TABLEACCESS_DENIED_ERROR
34 update performance_schema.events_waits_summary_by_instance
35 set count_star=12 where event_name like "FOO";
36
37 --error ER_TABLEACCESS_DENIED_ERROR
38 delete from performance_schema.events_waits_summary_by_instance
39 where count_star=1;
40
41 --error ER_TABLEACCESS_DENIED_ERROR
42 delete from performance_schema.events_waits_summary_by_instance;
43
44 -- error ER_TABLEACCESS_DENIED_ERROR
45 LOCK TABLES performance_schema.events_waits_summary_by_instance READ;
46 UNLOCK TABLES;
47
48 -- error ER_TABLEACCESS_DENIED_ERROR
49 LOCK TABLES performance_schema.events_waits_summary_by_instance WRITE;
50 UNLOCK TABLES;
51