1
select * from performance_schema.table_lock_waits_summary_by_table
3
select * from performance_schema.table_lock_waits_summary_by_table
4
where object_name='FOO';
5
insert into performance_schema.table_lock_waits_summary_by_table
6
set object_type='TABLE', object_name='FOO', object_schema='BAR',
7
count_star=1, sum_timer_wait=2, min_timer_wait=3,
8
avg_timer_wait=4, max_timer_wait=5;
9
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'table_lock_waits_summary_by_table'
10
update performance_schema.table_lock_waits_summary_by_table
12
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'table_lock_waits_summary_by_table'
13
update performance_schema.table_lock_waits_summary_by_table
14
set count_star=12 where object_name like "FOO";
15
ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'table_lock_waits_summary_by_table'
16
delete from performance_schema.table_lock_waits_summary_by_table
18
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'table_lock_waits_summary_by_table'
19
delete from performance_schema.table_lock_waits_summary_by_table;
20
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'table_lock_waits_summary_by_table'
21
LOCK TABLES performance_schema.table_lock_waits_summary_by_table READ;
22
ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'table_lock_waits_summary_by_table'
24
LOCK TABLES performance_schema.table_lock_waits_summary_by_table WRITE;
25
ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'table_lock_waits_summary_by_table'