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, 3696🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Start the Command-Line SQL*Plus in Oracle? If you Oracle server or client installed on your w...