查看MySQL运行进程
mysql>show processlist;
查看Innodb引擎运行情况:
mysql>show engine innodb status\G
查看MySQL参数情况:
mysql>show [global] variables like '%innodb%';
查看MySQL运行状态:
mysql>show [global] status like '%thread%';
查看表、存储过程、触发器:
mysql>show tables;
mysql>show procedure status; show create procedure USP_Cursor;
mysql>show triggers; show create trigger TRI_UP_User_Delete;
查看MySQL帮助:
mysql>help;
mysql>help conntents;
mysql>help show;