Debian Codegraph @

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

raw
1 select @@global.performance_schema_show_processlist into @save_processlist;
2 set @@global.performance_schema_show_processlist = 'on';
3 Warnings:
4 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
5 select * from performance_schema.processlist
6 where user like 'event_scheduler';
7 select * from performance_schema.processlist
8 where user = 'FOO';
9 insert into performance_schema.processlist
10 values (12, 'foo', 'bar', 'test', null, 1000, 'state', 'info');
11 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'processlist'
12 update performance_schema.processlist
13 set id=12, user='foo';
14 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'processlist'
15 delete from performance_schema.processlist
16 where id <> 99;
17 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'processlist'
18 delete from performance_schema.processlist;
19 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'processlist'
20 LOCK TABLES performance_schema.processlist READ;
21 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'processlist'
22 UNLOCK TABLES;
23 LOCK TABLES performance_schema.processlist WRITE;
24 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'processlist'
25 UNLOCK TABLES;
26 set @@global.performance_schema_show_processlist = @save_processlist;
27 Warnings:
28 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.