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.

ColumnDescription
EVENT_NAMESocket instrument.
OBJECT_INSTANCE_BEGINAddress in memory.
COUNT_STARNumber of summarized events
SUM_TIMER_WAITTotal wait time of the summarized events that are timed.
MIN_TIMER_WAITMinimum wait time of the summarized events that are timed.
AVG_TIMER_WAITAverage wait time of the summarized events that are timed.
MAX_TIMER_WAITMaximum wait time of the summarized events that are timed.
COUNT_READNumber of all read operations, including RECV, RECVFROM, and RECVMSG.
SUM_TIMER_READTotal wait time of all read operations that are timed.
MIN_TIMER_READMinimum wait time of all read operations that are timed.
AVG_TIMER_READAverage wait time of all read operations that are timed.
MAX_TIMER_READMaximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READBytes read by read operations.
COUNT_WRITENumber of all write operations, including SEND, SENDTO, and SENDMSG.
SUM_TIMER_WRITETotal wait time of all write operations that are timed.
MIN_TIMER_WRITEMinimum wait time of all write operations that are timed.
AVG_TIMER_WRITEAverage wait time of all write operations that are timed.
MAX_TIMER_WRITEMaximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITEBytes written by write operations.
COUNT_MISCNumber of all miscellaneous operations not counted above, including CONNECT, LISTEN, ACCEPT, CLOSE, and SHUTDOWN.
SUM_TIMER_MISCTotal wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISCMinimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISCAverage wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISCMaximum 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.

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.