SHOW GLOBAL VARIABLES;
SHOW SESSION VARIABLES;
SHOW GLOBAL VARIABLES LIKE 'SOMENAME%';
SELECT @@GLOBAL.var_name;
SELECT @@session_var_name;
Set MySQL Variables
SET GLOBAL var1 = val1, var2 = val2, SESSION var3 = val3;
SET GLOBAL var1 = val1;
SET @@GLOBAL.var1 = val1;
SET SESSION var1 = val1;
SET @@var1 = val1;
MySQL SHOW
SQL
Description
SHOW VARIABLES [LIKE 'some%]
Show Mysql variables
SHOW STATUS [LIKE 'some%]
Show Mysql status
SHOW INDEX FROM tbl
Show table index
SHOW TABLES
Show all tables
SHOW ERRORS/WARNINGS
Show errors or warnings
SHOW ENGINE engine_name {STATUS | MUTEX}
Show engine (say INNODB) status
SHOW PROCESSLIST
Show process running in MySQL
SHOW INNODB STATUS
Show InnoDB status
SHOW GRANTS [FOR user]
Show users grants
SHOW PRIVILEGES
Show Mysql Privileges
SHOW PROFILES
Resource utilization for statements in this session
SHOW PROFILE FOR QUERY n
Resource utilization for statement n in SHOW PROFILES
SHOW TABLE STATUS [LIKE 'some%]
Show table status
SHOW CREATE DATABASE mydb;
Show database definition
SHOW CREATE TABLE tbl1;
Show table definition
SHOW OPEN TABLES
Show open tables
SHOW BINARY LOGS;
Show binary log file in use
SHOW CREATE EVENT mydb.myevent
Show event definition
SHOW CREATE FUCNTION/PROCEDURE/TRIGGER/VIEW/EVENT ...
Show corresponding info
SHOW EVENTS/FUNCTION CODE/FUNCTION STATUS/TRIGGERS
LOCAL means do not log into the binary log
