threads

A description for this Performance-schema Table has not yet been added to this Documentation.

See also: Performance Schema in 10.6 ES, in 10.5 ES, and in 10.4 ES

DETAILS

SCHEMA

CREATE TABLE `threads` (
  `THREAD_ID` bigint(20) unsigned NOT NULL,
  `NAME` varchar(128) NOT NULL,
  `TYPE` varchar(10) NOT NULL,
  `PROCESSLIST_ID` bigint(20) unsigned DEFAULT NULL,
  `PROCESSLIST_USER` varchar(128) DEFAULT NULL,
  `PROCESSLIST_HOST` varchar(255) DEFAULT NULL,
  `PROCESSLIST_DB` varchar(64) DEFAULT NULL,
  `PROCESSLIST_COMMAND` varchar(16) DEFAULT NULL,
  `PROCESSLIST_TIME` bigint(20) DEFAULT NULL,
  `PROCESSLIST_STATE` varchar(64) DEFAULT NULL,
  `PROCESSLIST_INFO` longtext DEFAULT NULL,
  `PARENT_THREAD_ID` bigint(20) unsigned DEFAULT NULL,
  `ROLE` varchar(64) DEFAULT NULL,
  `INSTRUMENTED` enum('YES','NO') NOT NULL,
  `HISTORY` enum('YES','NO') NOT NULL,
  `CONNECTION_TYPE` varchar(16) DEFAULT NULL,
  `THREAD_OS_ID` bigint(20) unsigned DEFAULT NULL
)

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Schema changed in MariaDB Enterprise Server 10.6.4-1: ...

10.5 Enterprise

  • Schema changed in MariaDB Enterprise Server 10.5.3-1: ...

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

  • Schema changed in MariaDB Community Server 10.4.18-11: ...

EXTERNAL REFERENCES