关于show variables官方文档有提到一些:
System variable information is also available from these sources:
Performance Schema tables. See Section 21.9.12, “Performance Schema System Variable Tables”.
The GLOBAL_VARIABLES and SESSION_VARIABLES tables. See Section 20.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”.
The mysqladmin variables command. See Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”.
关于show status官方文档描述如下:
tatus variable information is also available from these sources:
Performance Schema tables. See Section 21.9.13, “Performance Schema Status Variable Tables”.
The GLOBAL_STATUS and SESSION_STATUS tables. See Section 20.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”.
The mysqladmin extended-status command. See Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”.