> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-socket_instances-table.md).

# Performance Schema socket\_instances Table

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:

| Column                  | Description                                                                                                                         |
| ----------------------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| EVENT\_NAME             | NAME from the setup\_instruments table, and the name of the wait/io/socket/\* instrument that produced the event.                   |
| OBJECT\_INSTANCE\_BEGIN | Memory address of the object.                                                                                                       |
| THREAD\_ID              | Thread identifier that the server assigns to each socket.                                                                           |
| SOCKET\_ID              | The socket's internal file handle.                                                                                                  |
| IP                      | Client IP address. Blank for Unix socket file, otherwise an IPv4 or IPv6 address. Together with the PORT identifies the connection. |
| PORT                    | TCP/IP port number, from 0 to 65535. Together with the IP identifies the connection.                                                |
| STATE                   | Socket status, either IDLE if waiting to receive a request from a client, or ACTIVE                                                 |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}