[root@ba ~]# mysqldump --default-character-set=utf8 --databases susite ucme >/home/2db-uch-ss-20120312.sqlmysqldump: Got error: 1449: The user specified as a definer ([url=mailto:]'mbuch'@'10.6.21.%'[/url]) does not exist when using LOCK TABLES【】建用户mysql> grant select,insert,update,delete on mc...【阅读全文】
某个初级dba误删index,mysql漫山遍野全是10S以上的慢sql,mysql服务被hang住了,而且慢sql不断在增加中,如果手动在mysql界面kill的话,根本来不及,这个时候,shell就必须要出手了,如下的shell脚本,大家可以参考:#It is used to kill processlist of mysql sleep#!/bin/shwhile :do n=`mysqladmin processlist...【阅读全文】
show engine innodb status ;结果记录如下:=====================================110908 8:26:52 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 19 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops...【阅读全文】