MySQL 8.4 Release Notes
Given a Performance Schema thread ID, returns the
account associated with the thread.
user_name
@host_name
in_thread_id BIGINT UNSIGNED
: The thread ID for which to return the account. The value should match theTHREAD_ID
column from some Performance Schemathreads
table row.
mysql> SELECT sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID()));
+----------------------------------------------------------+
| sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())) |
+----------------------------------------------------------+
| root@localhost |
+----------------------------------------------------------+