# Performance Schema socket\_summary\_by\_instance Table

It aggregates timer and byte count statistics for all socket I/O operations by socket instance.

| Column                        | Description                                                                                                       |
| ----------------------------- | ----------------------------------------------------------------------------------------------------------------- |
| EVENT\_NAME                   | Socket instrument.                                                                                                |
| OBJECT\_INSTANCE\_BEGIN       | Address in memory.                                                                                                |
| COUNT\_STAR                   | Number of summarized events                                                                                       |
| SUM\_TIMER\_WAIT              | Total wait time of the summarized events that are timed.                                                          |
| MIN\_TIMER\_WAIT              | Minimum wait time of the summarized events that are timed.                                                        |
| AVG\_TIMER\_WAIT              | Average wait time of the summarized events that are timed.                                                        |
| MAX\_TIMER\_WAIT              | Maximum wait time of the summarized events that are timed.                                                        |
| COUNT\_READ                   | Number of all read operations, including RECV, RECVFROM, and RECVMSG.                                             |
| SUM\_TIMER\_READ              | Total wait time of all read operations that are timed.                                                            |
| MIN\_TIMER\_READ              | Minimum wait time of all read operations that are timed.                                                          |
| AVG\_TIMER\_READ              | Average wait time of all read operations that are timed.                                                          |
| MAX\_TIMER\_READ              | Maximum wait time of all read operations that are timed.                                                          |
| SUM\_NUMBER\_OF\_BYTES\_READ  | Bytes read by read operations.                                                                                    |
| COUNT\_WRITE                  | Number of all write operations, including SEND, SENDTO, and SENDMSG.                                              |
| SUM\_TIMER\_WRITE             | Total wait time of all write operations that are timed.                                                           |
| MIN\_TIMER\_WRITE             | Minimum wait time of all write operations that are timed.                                                         |
| AVG\_TIMER\_WRITE             | Average wait time of all write operations that are timed.                                                         |
| MAX\_TIMER\_WRITE             | Maximum wait time of all write operations that are timed.                                                         |
| SUM\_NUMBER\_OF\_BYTES\_WRITE | Bytes written by write operations.                                                                                |
| COUNT\_MISC                   | Number of all miscellaneous operations not counted above, including CONNECT, LISTEN, ACCEPT, CLOSE, and SHUTDOWN. |
| SUM\_TIMER\_MISC              | Total wait time of all miscellaneous operations that are timed.                                                   |
| MIN\_TIMER\_MISC              | Minimum wait time of all miscellaneous operations that are timed.                                                 |
| AVG\_TIMER\_MISC              | Average wait time of all miscellaneous operations that are timed.                                                 |
| MAX\_TIMER\_MISC              | Maximum wait time of all miscellaneous operations that are timed.                                                 |

The corresponding row in the table is deleted when a connection terminates.

You can [TRUNCATE](/docs/server/reference/sql-statements/table-statements/truncate-table.md) the table, which will reset all counters to zero.

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

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-socket_summary_by_instance-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.