MySQL 5.1 Reference Manual  /  INFORMATION_SCHEMA Tables  /  The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables

20.8 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables

The GLOBAL_STATUS and SESSION_STATUS tables provide information about server status variables. Their contents correspond to the information produced by the SHOW GLOBAL STATUS and SHOW SESSION STATUS statements (see Section 13.7.5.37, “SHOW STATUS Syntax”).

INFORMATION_SCHEMA NameSHOW NameRemarks
VARIABLE_NAMEVariable_name
VARIABLE_VALUEValue

Notes:

  • The GLOBAL_STATUS and SESSION_STATUS tables were added in MySQL 5.1.12.

  • The VARIABLE_VALUE column for each of these tables is defined as VARCHAR(1024). Previously, this column had the data type DECIMAL(22,7), but was changed to VARCHAR(20480) in 5.1.19 to avoid loss of data when working with status variables whose values were strings, and shortened to VARCHAR(1024) in 5.1.31 to improve performance.


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