Debian Codegraph @

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

raw
1 select * from performance_schema.file_instances limit 1;
2 select * from performance_schema.file_instances
3 where file_name='FOO';
4 insert into performance_schema.file_instances
5 set file_name='FOO', event_name='BAR', open_count=12;
6 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'file_instances'
7 update performance_schema.file_instances
8 set file_name='FOO';
9 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'file_instances'
10 delete from performance_schema.file_instances
11 where event_name like "wait/%";
12 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'file_instances'
13 delete from performance_schema.file_instances;
14 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'file_instances'
15 LOCK TABLES performance_schema.file_instances READ;
16 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'file_instances'
17 UNLOCK TABLES;
18 LOCK TABLES performance_schema.file_instances WRITE;
19 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'file_instances'
20 UNLOCK TABLES;
21 ###
22 ### Bug#26152751: INNODB LEAKS MEMORY, PERFORMANCE_SCHEMA FILE_INSTANCES
23 ### #SQL-IB3129987-252773.IBD
24 ###
25 CREATE DATABASE db_26152751;
26 USE db_26152751;
27 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
28 FILE_NAME
29 CREATE TABLE t_db_26152751 (a INT) ENGINE=INNODB;
30 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
31 FILE_NAME
32 t_db_26152751.ibd
33 RENAME TABLE t_db_26152751 to t_db_26152751_new;
34 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
35 FILE_NAME
36 t_db_26152751_new.ibd
37 RENAME TABLE t_db_26152751_new to t_db_26152751;
38 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
39 FILE_NAME
40 t_db_26152751.ibd
41 ALTER TABLE t_db_26152751 ADD COLUMN b INT;
42 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
43 FILE_NAME
44 t_db_26152751.ibd
45 DROP TABLE t_db_26152751;
46 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
47 FILE_NAME
48 DROP DATABASE db_26152751;