How to decrease InnoDB shutdown timesBaron Schwartz | April 15, 2009 | Posted In: Insight for DBAsSometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages from the buffer pool. These are page...【阅读全文】
利用 nagios 自带的插件来监控 mysql 的主从同步状态[主动方式]1、调试check_mysql主从同步的命令登录到从库的服务器上进行如下操作:grant super,replication slave on *.* to nagios@'192.168.88.%' identified by 'tcs6688';flush privileges;n...【阅读全文】