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:

ColumnDescription
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

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.