PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect

Q

How to obtain the performance schema thread id of the current connection using the PS_CURRENT_THREAD_ID() function?

✍: FYIcenter.com

A

PS_CURRENT_THREAD_ID() is a MySQL built-in function that returns the performance schema thread id of the current connection. For example:

SELECT PS_CURRENT_THREAD_ID();
  -- +------------------------+
  -- | PS_CURRENT_THREAD_ID() |
  -- +------------------------+
  -- |                    348 |
  -- +------------------------+

Reference information of the PS_CURRENT_THREAD_ID() function:

PS_CURRENT_THREAD_ID(): id
  Returns the performance schema thread id of the current connection.

Arguments, return value and availability:
  id: Return value. The performance schema thread id of the current connection.
  Available since MySQL 8.0.

Related MySQL functions:

⇒ PS_THREAD_ID() - PS Thread ID of Given Connect

⇐ LAST_INSERT_ID() - Last Value of AUTO_INCREMENT Column

⇑ MySQL Functions on System Information

⇑⇑ MySQL Function References

2025-02-16, 3007🔥, 0💬

ICU_VERSION() - ICU (International Components for Unicode) Version
How to obtain the version number of the ICU (International Components for Unicode) library using the ICU_VERSION() function? ICU_VERSION() is a MySQL built-in function that returns the version number of the ICU (International Components for Unicode) library. For example: SELECT ICU_VERSION(); -- +--... 2025-04-11, 6285🔥, 0💬

DATABASE() - Name of Current Database
How to obtain the name of the current database using the DATABASE() function? DATABASE() is a MySQL built-in function that returns the name of the current database. For example: USE mysql; Database changed SELECT DATABASE(); -- +------------+ -- | DATABASE() | -- +------------+ -- | mysql | -- +----... 2025-06-18, 4175🔥, 0💬

CURRENT_USER() - Authentication Name of Current User
How to obtain the authentication name of the current user using the CURRENT_USER() function? CURRENT_USER() is a MySQL built-in function that returns the authentication name of the current user. The authentication name is a combination of "User" and "Host" columns in the mysql.user table and used to... 2025-06-18, 4136🔥, 0💬

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? 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()... 2025-02-16, 3818🔥, 0💬

ROW_COUNT() - Affected Rows from Last DML Statement
How to obtain the affected row count from the last DML statement (INSERT, UPDATE or DELETE) using the ROW_COUNT() function? ROW_COUNT() is a MySQL built-in function that returns the affected row count from the last DML (Data Manipulation Language) statement (INSERT, UPDATE and DELETE). For example: ... 2025-02-16, 3452🔥, 0💬

LAST_INSERT_ID() - Last Value of AUTO_INCREMENT Column
How to obtain the last inserted value of an AUTO_INCREMENT column using the LAST_INSERT_ID() function? LAST_INSERT_ID() is a MySQL built-in function that returns the last inserted value of an AUTO_INCREMENT column. For example: CREATE TABLE MyTable (id INTEGER AUTO_INCREMENT, comment CHAR(80), PRIMA... 2025-04-11, 3210🔥, 0💬

SCHEMA() - Synonym for DATABASE()
What's the difference between SCHEMA() and DATABASE() functions? SCHEMA() is a synonym for the DATABASE() function. Related MySQL functions: DATABASE() - Name of Current Database SCHEMA() - Synonym for DATABASE() ⇒ SESSION_USER() - Synonym for USER() ⇐ ROW_COUNT() - Affected Rows from Last DML St... 2025-02-16, 3139🔥, 0💬

PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect
How to obtain the performance schema thread id of the current connection using the PS_CURRENT_THREAD_ID() function? PS_CURRENT_THREAD_ID() is a MySQL built-in function that returns the performance schema thread id of the current connection. For example: SELECT PS_CURRENT_THREAD_ID(); -- +-----------... 2025-02-16, 3008🔥, 0💬

ROLES_GRAPHML() - User Role Graph in GraphML Format
How to obtain User Role Graph in GraphML Format using the ROLES_GRAPHML() function? ROLES_GRAPHML() is a MySQL built-in function that returns user role graph in GraphML format. For example: SELECT ROLES_GRAPHML(); -- +----------------------------- ------------------------------ ---------+-- | ROLES_G... 2025-02-16, 2642🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.