Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual The user_variables_by_thread Table

As of MySQL 5.7.5, the Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 9.4, “User-Defined Variables”.

The user_variables_by_thread table contains these columns:


    The thread identifier of the session in which the variable is defined.


    The variable name, without the leading @ character.


    The variable value.

Download this Manual
User Comments
Sign Up Login You must be logged in to post a comment.