简明教程 - 日常维护
出处:www.mysqlpub.com,不断完善更新中。http://www.mysqlpub.com/thread-59103-1-1.html,转载请注明。查看MySQL运行进程mysql>show processlist;
查看Innodb引擎运行情况:mysql>show engine innodb status\G
查看MySQL参数情况:mysql>show variables like '%innodb%';
查看MySQL运行状态:mysql>show 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;
这个太简单了把,cpu、内存、IO等系统资源情况也要监控啊 基本但是有用的东西
页:
[1]