processlist_summary
NAME
processlist_summary: Number of connected, sleeping, running connections and slow query countTYPE
ViewDESCRIPTION
processlist_summary provides a one-line summary of PROCESSLIST status. It presents with counters listing the number of connected, running, sleeping, long-running processes.
STRUCTURE
mysql> DESC common_schema.processlist_summary; +--------------------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+---------------+------+-----+---------+-------+ | count_processes | bigint(21) | NO | | 0 | | | active_processes | decimal(23,0) | YES | | NULL | | | sleeping_processes | decimal(23,0) | YES | | NULL | | | active_queries | decimal(23,0) | YES | | NULL | | | num_queries_over_1_sec | decimal(23,0) | NO | | 0 | | | num_queries_over_10_sec | decimal(23,0) | NO | | 0 | | | num_queries_over_60_sec | decimal(23,0) | NO | | 0 | | | average_active_time | decimal(14,4) | NO | | 0.0000 | | | median_95pct_active_time | decimal(10,2) | NO | | 0.00 | | +--------------------------+---------------+------+-----+---------+-------+
SYNOPSIS
Columns of this view:
- count_processes: total number of connected processes
- active_processes: number of processes not sleeping
- sleeping_processes: number of sleeping processes
- active_queries: number of non-replication, non-sleeping processes
- num_queries_over_1_sec: non-replication queries running at 1 second or more
- num_queries_over_10_sec: non-replication queries running at 10 second or more
- num_queries_over_60_sec: non-replication queries running at 60 second or more
- average_active_time: average query execution time for non-replication, non-sleeping queries queries
- median_95pct_active_time: run time at 95% (95% processes run at this or lower time) for active processes
All of the above counters exclude the connection from which the view is being queried.
num_queries_over_10_sec include queries counted in num_queries_over_1_sec.
num_queries_over_60_sec include queries counted in num_queries_over_10_sec and num_queries_over_1_sec.
EXAMPLES
mysql> SELECT * FROM common_schema.processlist_summary where average_active_time > 0\G
*************************** 1. row ***************************
count_processes: 123
active_processes: 68
sleeping_processes: 55
active_queries: 66
num_queries_over_1_sec: 34
num_queries_over_10_sec: 0
num_queries_over_60_sec: 0
average_active_time: 1.3939
median_95pct_active_time: 4.00