1select * from performance_schema.events_waits_summary_global_by_event_name
2where event_name like 'Wait/Synch/%' limit 1;
3select * from performance_schema.events_waits_summary_global_by_event_name
4where event_name='FOO';
5insert into performance_schema.events_waits_summary_global_by_event_name
6set event_name='FOO', count_star=1, sum_timer_wait=2, min_timer_wait=3,
7avg_timer_wait=4, max_timer_wait=5;
8ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'events_waits_summary_global_by_event_name'
9update performance_schema.events_waits_summary_global_by_event_name
10set count_star=12;
11ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'events_waits_summary_global_by_event_name'
12update performance_schema.events_waits_summary_global_by_event_name
13set count_star=12 where event_name like "FOO";
14ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'events_waits_summary_global_by_event_name'
15delete from performance_schema.events_waits_summary_global_by_event_name
16where count_star=1;
17ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'events_waits_summary_global_by_event_name'
18delete from performance_schema.events_waits_summary_global_by_event_name;
19ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'events_waits_summary_global_by_event_name'
20LOCK TABLES performance_schema.events_waits_summary_global_by_event_name READ;
21ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'events_waits_summary_global_by_event_name'
22UNLOCK TABLES;
23LOCK TABLES performance_schema.events_waits_summary_global_by_event_name WRITE;
24ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'events_waits_summary_global_by_event_name'
25UNLOCK TABLES;
26#
27# MDEV-25325 column_comment for performance_schema tables
28#
29select column_name, column_comment
30from information_schema.columns
31where table_schema='performance_schema' and table_name='events_waits_summary_global_by_event_name';
32column_name	column_comment
33EVENT_NAME	Event name.
34COUNT_STAR	Number of summarized events
35SUM_TIMER_WAIT	Total wait time of the summarized events that are timed.
36MIN_TIMER_WAIT	Minimum wait time of the summarized events that are timed.
37AVG_TIMER_WAIT	Average wait time of the summarized events that are timed.
38MAX_TIMER_WAIT	Maximum wait time of the summarized events that are timed.
39