The Ultimate Guide to High Availability with MariaDB

Performance Schema user_variables_by_thread Table

MariaDB starting with 10.5.2

The user_variables_by_thread table was added in MariaDB 10.5.2.

The user_variables_by_thread table contains information about user-defined variables and the threads that defined them.

TRUNCATE TABLE cannot be performed on the table.

The table contains the following columns:

ColumnDescription
THREAD_IDThe thread identifier of the session in which the variable is defined.
VARIABLE_NAMEThe variable name, without the leading @ character.
VARIABLE_VALUEThe variable value

Example

SET @var = 0;

SELECT * FROM user_variables_by_thread;
+-----------+---------------+----------------+
| THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE |
+-----------+---------------+----------------+
|        11 | var           | 0              |
+-----------+---------------+----------------+

See Also

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.