Debian Codegraph @

mysql-test/suite/perfschema/r/dml_file_instances_myisam.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=MYISAM;
30 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
31 FILE_NAME
32 t_db_26152751.sdi
33 t_db_26152751.MYI
34 t_db_26152751.MYD
35 RENAME TABLE t_db_26152751 to t_db_26152751_new;
36 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
37 FILE_NAME
38 t_db_26152751_new.MYI
39 t_db_26152751_new.MYD
40 t_db_26152751_new.sdi
41 RENAME TABLE t_db_26152751_new to t_db_26152751;
42 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
43 FILE_NAME
44 t_db_26152751.MYI
45 t_db_26152751.MYD
46 t_db_26152751.sdi
47 ALTER TABLE t_db_26152751 ADD COLUMN b INT;
48 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
49 FILE_NAME
50 t_db_26152751.MYI
51 t_db_26152751.MYD
52 t_db_26152751.sdi
53 DROP TABLE t_db_26152751;
54 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%";
55 FILE_NAME
56 DROP DATABASE db_26152751;