Debian Codegraph @

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

raw
1 select * from performance_schema.hosts
2 limit 1;
3 select * from performance_schema.hosts
4 where host='FOO';
5 insert into performance_schema.hosts
6 set host='FOO',
7 current_connections=1, total_connections=2;
8 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`hosts`
9 update performance_schema.hosts
10 set current_connections=12;
11 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`hosts`
12 update performance_schema.hosts
13 set current_connections=12 where host like "FOO";
14 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`hosts`
15 delete from performance_schema.hosts
16 where total_connections=1;
17 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`hosts`
18 delete from performance_schema.hosts;
19 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`hosts`
20 LOCK TABLES performance_schema.hosts READ;
21 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`hosts`
22 UNLOCK TABLES;
23 LOCK TABLES performance_schema.hosts WRITE;
24 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`hosts`
25 UNLOCK TABLES;
26 #
27 # MDEV-25325 column_comment for performance_schema tables
28 #
29 select column_name, column_comment
30 from information_schema.columns
31 where table_schema='performance_schema' and table_name='hosts';
32 column_name column_comment
33 HOST Host name used by the client to connect, NULL for internal threads or user sessions that failed to authenticate.
34 CURRENT_CONNECTIONS Current number of the host's connections.
35 TOTAL_CONNECTIONS Total number of the host's connections