Debian Codegraph @

mysql-test/suite/perfschema/r/dml_innodb_redo_log_files.result

raw
1 select * from performance_schema.innodb_redo_log_files;
2 select * from performance_schema.innodb_redo_log_files
3 where file_name='foo';
4 FILE_ID FILE_NAME START_LSN END_LSN SIZE_IN_BYTES IS_FULL CONSUMER_LEVEL
5 insert into performance_schema.innodb_redo_log_files
6 set file_name='#ib_redo1', file_id=1, start_lsn=8192, end_lsn=10240, size_in_bytes=4096,
7 is_full='YES', consumer_level=0;
8 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'innodb_redo_log_files'
9 update performance_schema.innodb_redo_log_files
10 set file_name='#ib_redo2' where file_id=1;
11 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'innodb_redo_log_files'
12 delete from performance_schema.innodb_redo_log_files;
13 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'innodb_redo_log_files'
14 delete from performance_schema.innodb_redo_log_files
15 where file_name='#ib_redo1';
16 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'innodb_redo_log_files'
17 LOCK TABLES performance_schema.innodb_redo_log_files READ;
18 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'innodb_redo_log_files'
19 UNLOCK TABLES;
20 LOCK TABLES performance_schema.innodb_redo_log_files WRITE;
21 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'innodb_redo_log_files'
22 UNLOCK TABLES;