Edit File: dml_file_summary_by_instance.result
select * from performance_schema.file_summary_by_instance where event_name like 'Wait/io/%' limit 1; select * from performance_schema.file_summary_by_instance where event_name='FOO'; insert into performance_schema.file_summary_by_instance set event_name='FOO', count_read=1, count_write=2, sum_number_of_bytes_read=4, sum_number_of_bytes_write=5; ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'file_summary_by_instance' update performance_schema.file_summary_by_instance set count_read=12; ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'file_summary_by_instance' update performance_schema.file_summary_by_instance set count_write=12 where event_name like "FOO"; ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'file_summary_by_instance' delete from performance_schema.file_summary_by_instance where count_read=1; ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'file_summary_by_instance' delete from performance_schema.file_summary_by_instance; ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'file_summary_by_instance' LOCK TABLES performance_schema.file_summary_by_instance READ; ERROR 42000: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'file_summary_by_instance' UNLOCK TABLES; LOCK TABLES performance_schema.file_summary_by_instance WRITE; ERROR 42000: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'file_summary_by_instance' UNLOCK TABLES;
Back to File Manager