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, 4146🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL? Wh...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Start the Command-Line SQL*Plus in Oracle? If you Oracle server or client installed on your w...