processlist

Overview

In 23.08 ES, 23.07 ES:

A description for this sys Table has not yet been added to this Documentation.

In 10.6 ES, 10.6 CS:

The server's process list.

In 10.6 ES:

The server's process list.

In 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:

Not present

In 10.5 ES, 10.4 ES:

Not present

USAGE

DETAILS

SYNONYMS

SCHEMA

VIEW `processlist` AS SELECT
  `pps`.`THREAD_ID` AS `thd_id`,
  `pps`.`PROCESSLIST_ID` AS `conn_id`,
  if(`pps`.`NAME` = 'thread/sql/one_connection',concat(`pps`.`PROCESSLIST_USER`,'@',`pps`.`PROCESSLIST_HOST`),replace(`pps`.`NAME`,'thread/','')) AS `user`,
  `pps`.`PROCESSLIST_DB` AS `db`,
  `pps`.`PROCESSLIST_COMMAND` AS `command`,
  `pps`.`PROCESSLIST_STATE` AS `state`,
  `pps`.`PROCESSLIST_TIME` AS `time`,
  `sys`.`format_statement`(`pps`.`PROCESSLIST_INFO`) AS `current_statement`,
  if(`esc`.`END_EVENT_ID` is null,format_pico_time(`esc`.`TIMER_WAIT`),NULL) AS `statement_latency`,
  if(`esc`.`END_EVENT_ID` is null,round(100 * (`estc`.`WORK_COMPLETED` / `estc`.`WORK_ESTIMATED`),2),NULL) AS `progress`,
  format_pico_time(`esc`.`LOCK_TIME`) AS `lock_latency`,
  `esc`.`ROWS_EXAMINED` AS `rows_examined`,
  `esc`.`ROWS_SENT` AS `rows_sent`,
  `esc`.`ROWS_AFFECTED` AS `rows_affected`,
  `esc`.`CREATED_TMP_TABLES` AS `tmp_tables`,
  `esc`.`CREATED_TMP_DISK_TABLES` AS `tmp_disk_tables`,
  if(`esc`.`NO_GOOD_INDEX_USED` > 0 or `esc`.`NO_INDEX_USED` > 0,'YES','NO') AS `full_scan`,
  if(`esc`.`END_EVENT_ID` is not null,`sys`.`format_statement`(`esc`.`SQL_TEXT`),NULL) AS `last_statement`,
  if(`esc`.`END_EVENT_ID` is not null,format_pico_time(`esc`.`TIMER_WAIT`),NULL) AS `last_statement_latency`,
  `sys`.`format_bytes`(`mem`.`current_allocated`) AS `current_memory`,
  `ewc`.`EVENT_NAME` AS `last_wait`,
  if(`ewc`.`END_EVENT_ID` is null and `ewc`.`EVENT_NAME` is not null,'Still Waiting',format_pico_time(`ewc`.`TIMER_WAIT`)) AS `last_wait_latency`,
  `ewc`.`SOURCE` AS `source`,
  format_pico_time(`etc`.`TIMER_WAIT`) AS `trx_latency`,
  `etc`.`STATE` AS `trx_state`,
  `etc`.`AUTOCOMMIT` AS `trx_autocommit`,
  `conattr_pid`.`ATTR_VALUE` AS `pid`,
  `conattr_progname`.`ATTR_VALUE` AS `program_name`
FROM (((((((`performance_schema`.`threads` `pps` left join `performance_schema`.`events_waits_current` `ewc` on(`pps`.`THREAD_ID` = `ewc`.`THREAD_ID`)) left join `performance_schema`.`events_stages_current` `estc` on(`pps`.`THREAD_ID` = `estc`.`THREAD_ID`)) left join `performance_schema`.`events_statements_current` `esc` on(`pps`.`THREAD_ID` = `esc`.`THREAD_ID`)) left join `performance_schema`.`events_transactions_current` `etc` on(`pps`.`THREAD_ID` = `etc`.`THREAD_ID`)) left join `sys`.`x$memory_by_thread_by_current_bytes` `mem` on(`pps`.`THREAD_ID` = `mem`.`thread_id`)) left join `performance_schema`.`session_connect_attrs` `conattr_pid` on(`conattr_pid`.`PROCESSLIST_ID` = `pps`.`PROCESSLIST_ID` and `conattr_pid`.`ATTR_NAME` = '_pid')) left join `performance_schema`.`session_connect_attrs` `conattr_progname` on(`conattr_progname`.`PROCESSLIST_ID` = `pps`.`PROCESSLIST_ID` and `conattr_progname`.`ATTR_NAME` = 'program_name')) order by `pps`.`PROCESSLIST_TIME` desc,if(`ewc`.`END_EVENT_ID` is null and `ewc`.`EVENT_NAME` is not null,'Still Waiting',format_pico_time(`ewc`.`TIMER_WAIT`)) desc

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Added in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Added in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Not present.

10.5 Community

  • Not present.

10.4 Enterprise

  • Not present.

10.4 Community

  • Not present.

10.3 Enterprise

  • Not present.

10.3 Community

  • Not present.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Added in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Not present.

10.4 Enterprise

  • Not present.

EXTERNAL REFERENCES