Performance Schema socket_instances Table

MariaDB starting with 10.0

The socket_instances table, along with many other new Performance Schema tables, was added in MariaDB 10.0.

The socket_instances table lists active server connections, with each record being a Unix socket file or TCP/IP connection.

The socket_instances table contains the following columns:

EVENT_NAMENAME from the setup_instruments table, and the name of the wait/io/socket/* instrument that produced the event.
OBJECT_INSTANCE_BEGINMemory address of the object.
THREAD_IDThread identifier that the server assigns to each socket.
SOCKET_IDThe socket's internal file handle.
IPClient IP address. Blank for Unix socket file, otherwise an IPv4 or IPv6 address. Together with the PORT identifies the connection.
PORTTCP/IP port number, from 0 to 65535. Together with the IP identifies the connection.
STATESocket status, either IDLE if waiting to receive a request from a client, or ACTIVE


Comments loading...