Debian Codegraph @

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

raw
1 select * from performance_schema.socket_instances limit 1;
2 select * from performance_schema.socket_instances
3 where ip='FOO';
4 insert into performance_schema.socket_instances
5 set ip='FOO', event_name='BAR', port=12;
6 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`socket_instances`
7 update performance_schema.socket_instances
8 set ip='FOO';
9 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table `performance_schema`.`socket_instances`
10 delete from performance_schema.socket_instances
11 where event_name like "wait/%";
12 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`socket_instances`
13 delete from performance_schema.socket_instances;
14 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`socket_instances`
15 LOCK TABLES performance_schema.socket_instances READ;
16 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`socket_instances`
17 UNLOCK TABLES;
18 LOCK TABLES performance_schema.socket_instances WRITE;
19 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table `performance_schema`.`socket_instances`
20 UNLOCK TABLES;
21 #
22 # MDEV-25325 column_comment for performance_schema tables
23 #
24 select column_name, column_comment
25 from information_schema.columns
26 where table_schema='performance_schema' and table_name='socket_instances';
27 column_name column_comment
28 EVENT_NAME NAME from the setup_instruments table, and the name of the wait/io/socket/* instrument that produced the event.
29 OBJECT_INSTANCE_BEGIN Memory address of the object.
30 THREAD_ID Thread identifier that the server assigns to each socket.
31 SOCKET_ID The socket's internal file handle.
32 IP Client IP address. Blank for Unix socket file, otherwise an IPv4 or IPv6 address. Together with the PORT identifies the connection.
33 PORT TCP/IP port number, from 0 to 65535. Together with the IP identifies the connection.
34 STATE Socket status, either IDLE if waiting to receive a request from a client, or ACTIVE