Debian Codegraph @

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

raw
1 select * from performance_schema.table_io_waits_summary_by_index_usage
2 limit 1;
3 select * from performance_schema.table_io_waits_summary_by_index_usage
4 where object_name='FOO';
5 insert into performance_schema.table_io_waits_summary_by_index_usage
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_io_waits_summary_by_index_usage'
10 update performance_schema.table_io_waits_summary_by_index_usage
11 set count_star=12;
12 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'table_io_waits_summary_by_index_usage'
13 update performance_schema.table_io_waits_summary_by_index_usage
14 set count_star=12 where object_name like "FOO";
15 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'table_io_waits_summary_by_index_usage'
16 delete from performance_schema.table_io_waits_summary_by_index_usage
17 where count_star=1;
18 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'table_io_waits_summary_by_index_usage'
19 delete from performance_schema.table_io_waits_summary_by_index_usage;
20 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'table_io_waits_summary_by_index_usage'
21 LOCK TABLES performance_schema.table_io_waits_summary_by_index_usage READ;
22 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'table_io_waits_summary_by_index_usage'
23 UNLOCK TABLES;
24 LOCK TABLES performance_schema.table_io_waits_summary_by_index_usage WRITE;
25 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'table_io_waits_summary_by_index_usage'
26 UNLOCK TABLES;
27 #
28 # WL#6599/BUG#23044286: New Data Dictionary and I_S Integration.
29 #
30 CREATE TABLE test.t1(fld1 INT);
31 LOCK TABLE test.t1 WRITE;
32 ALTER TABLE test.t1 OPTIMIZE PARTITION ALL;
33 Table Op Msg_type Msg_text
34 test.t1 optimize Error Partition management on a not partitioned table is not possible
35 test.t1 optimize status Operation failed
36 SELECT object_name FROM performance_schema.table_io_waits_summary_by_index_usage
37 WHERE object_schema= 'test';
38 object_name
39 # Cleanup
40 UNLOCK TABLES;
41 DROP TABLE test.t1;