show variables like'character_%' 显示字符编码
SHOW VARIABLES LIKE 'collation_%';
show processlist 查看连接数
show databases
show tables
use databaseName
desc tableName
SHOW status 查看数据库状态
SHOW GLOBAL VARIABLES LIKE '%wait_timeout%' 显示全局wait_timeout变量