ps_thread_id
Syntax
sys.ps_thread_id(connection_id)
Description
ps_thread_id
is a stored function available with the Sys Schema that returns the thread_id associated with the given connection_id. If the connection_id is NULL, returns the thread_id for the current connection.
Examples
SELECT * FROM performance_schema.threads\G *************************** 13. row *************************** THREAD_ID: 13 NAME: thread/sql/one_connection TYPE: FOREGROUND PROCESSLIST_ID: 3 PROCESSLIST_USER: msandbox PROCESSLIST_HOST: localhost PROCESSLIST_DB: test PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 0 PROCESSLIST_STATE: Sending data PROCESSLIST_INFO: SELECT * FROM performance_schema.threads PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: Socket THREAD_OS_ID: 24379 SELECT sys.ps_thread_id(3); +---------------------+ | sys.ps_thread_id(3) | +---------------------+ | 13 | +---------------------+ SELECT sys.ps_thread_id(NULL); +------------------------+ | sys.ps_thread_id(NULL) | +------------------------+ | 13 | +------------------------+
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.