Collections:
PS_THREAD_ID() - PS Thread ID of Given Connect
How to obtain the performance schema thread id of a given connection using the PS_THREAD_ID() function?
✍: FYIcenter.com
PS_THREAD_ID(con) is a MySQL built-in function that
returns the performance schema thread id of a given connection.
For example:
SELECT CONNECTION_ID(); -- +-----------------+ -- | CONNECTION_ID() | -- +-----------------+ -- | 307 | -- +-----------------+ SELECT PS_THREAD_ID(307); -- +-------------------+ -- | PS_THREAD_ID(307) | -- +-------------------+ -- | 348 | -- +-------------------+ SELECT PS_CURRENT_THREAD_ID(); -- +------------------------+ -- | PS_CURRENT_THREAD_ID() | -- +------------------------+ -- | 348 | -- +------------------------+
Reference information of the PS_THREAD_ID() function:
PS_THREAD_ID(con): id Returns the performance schema thread id of a given connection. Arguments, return value and availability: con: Required. The connection id. id: Return value. The performance schema thread id of the given connection. Available since MySQL 8.0.
Related MySQL functions:
⇒ ROLES_GRAPHML() - User Role Graph in GraphML Format
⇐ PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect
2025-02-16, 764🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...