Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.memory_summary_by_user_by_event_name
5 where event_name like 'memory/%' limit 1;
6
7 select * from performance_schema.memory_summary_by_user_by_event_name
8 where event_name='FOO';
9 --enable_result_log
10
11 --error ER_TABLEACCESS_DENIED_ERROR
12 insert into performance_schema.memory_summary_by_user_by_event_name
13 set event_name='FOO', user='BAR',
14 count_alloc=1, count_free=2, sum_number_of_bytes_alloc=3,
15 sum_number_of_bytes_free=4, low_count_used=5;
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 update performance_schema.memory_summary_by_user_by_event_name
19 set count_alloc=12;
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 update performance_schema.memory_summary_by_user_by_event_name
23 set count_alloc=12 where event_name like "FOO";
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 delete from performance_schema.memory_summary_by_user_by_event_name
27 where count_alloc=1;
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 delete from performance_schema.memory_summary_by_user_by_event_name;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.memory_summary_by_user_by_event_name READ;
34 UNLOCK TABLES;
35
36 -- error ER_TABLEACCESS_DENIED_ERROR
37 LOCK TABLES performance_schema.memory_summary_by_user_by_event_name WRITE;
38 UNLOCK TABLES;
39