sessions and not background threads. -- This is a non-blocking closer replacement to -- [INFORMATION_SCHEMA. | SHOW FULL] PROCESSLIST -- -- Performs less locking than the legacy sources, whilst giving extra information. -- -- mysql> select * from sys.session\G -- *************************** 1. row *************************** -- thd_id: 24 -- conn_id: 2 -- user: root@localhost -- db: sys -- command: Query -- state: Sending data -- time: 0 -- current_statement: select * from sys.session -- execution_engine: PRIMARY -- statement_latency: 137.22 ms -- progress: NULL -- lock_latency: 33.75 ms -- rows_examined: 0 -- rows_sent: 0 -- rows_affected: 0 -- tmp_tables: 4 -- tmp_disk_tables: 1 -- full_scan: YES -- last_statement: NULL -- last_statement_latency: NULL -- current_memory: 3.26 MiB -- last_wait: wait/synch/mutex/innodb/file_format_max_mutex -- last_wait_latency: 64.09 ns -- source: trx0sys.cc:778 -- trx_latency: 7.88 s -- trx_state: ACTIVE -- trx_autocommit: NO -- pid: 4212 -- program_name: mysql -- CREATE OR REPLACE DEFINER = 'mysql.sys'@'localhost' SQL SECURITY INVOKER VIEW session AS SELECT * FROM sys.processlist WHERE conn_id IS NOT NULL AND command != 'Daemon';