1 of 1

ps_thread_account

This function returns the user account (username@hostname) associated with a specific Performance Schema thread ID.

Syntax

sys.ps_thread_account(thread_id)

Description

ps_thread_account is a available with the that returns the account (username@hostname) associated with the given thread_id.

Returns NULL if the thread_id is not found.

Examples

_{This page is licensed: CC BY-SA / Gnu FDL}

SELECT sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID()));
+----------------------------------------------------------+
| sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())) |
+----------------------------------------------------------+
| msandbox@localhost                                       |
+----------------------------------------------------------+

SELECT sys.ps_thread_account(sys.ps_thread_id(2042));
+-----------------------------------------------+
| sys.ps_thread_account(sys.ps_thread_id(2042)) |
+-----------------------------------------------+
| NULL                                          |
+-----------------------------------------------+

SELECT sys.ps_thread_account(sys.ps_thread_id(NULL));
+-----------------------------------------------+
| sys.ps_thread_account(sys.ps_thread_id(NULL)) |
+-----------------------------------------------+
| msandbox@localhost                            |
+-----------------------------------------------+