Edit File: dml_setup_consumers.result
select * from performance_schema.setup_consumers; NAME ENABLED events_waits_current YES events_waits_history YES events_waits_history_long YES events_waits_summary_by_thread_by_event_name YES events_waits_summary_by_event_name YES events_waits_summary_by_instance YES file_summary_by_event_name YES file_summary_by_instance YES select * from performance_schema.setup_consumers where name='events_waits_current'; NAME ENABLED events_waits_current YES select * from performance_schema.setup_consumers where enabled='YES'; NAME ENABLED events_waits_current YES events_waits_history YES events_waits_history_long YES events_waits_summary_by_thread_by_event_name YES events_waits_summary_by_event_name YES events_waits_summary_by_instance YES file_summary_by_event_name YES file_summary_by_instance YES select * from performance_schema.setup_consumers where enabled='NO'; NAME ENABLED insert into performance_schema.setup_consumers set name='FOO', enabled='YES'; ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_consumers' update performance_schema.setup_consumers set name='FOO'; ERROR HY000: Invalid performance_schema usage. update performance_schema.setup_consumers set enabled='YES'; delete from performance_schema.setup_consumers; ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_consumers' delete from performance_schema.setup_consumers where name='events_waits_current'; ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_consumers' LOCK TABLES performance_schema.setup_consumers READ; UNLOCK TABLES; LOCK TABLES performance_schema.setup_consumers WRITE; UNLOCK TABLES;
Back to File Manager