W3cubDocs

/MariaDB

Performance Schema socket_summary_by_instance Table

MariaDB starting with 10.0

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

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 the table, which will reset all counters to zero.

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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-socket_summary_by_instance-table/