脚本代码如下:
#!/bin/bash                                                                                                                # Info   : check mysql slave                                                                                               # Author : dingtm                                                                                                          # CTime  : 2011.03.21                                                                                                      # This script run by root                                                                                                                                                                                                                             DBDir=/elain/apps/mysql/bin/                                                                                               DBSock=/elain/data/mysql/3306/mysql.sock                                                                                   Log=/tmp/mysql_slave.log                                                                                                   DBUser=root                                                                                                                DBPasswd=elain                                                                                                        MailList=elain@elain.org,elain2012@hotmail.com                                                                                                                                                                                                           Seconds_Behind_Master=$(${DBDir}mysql -u${DBUser} -p${DBPasswd} -S ${DBSock} -e "show slave status\G;" | awk -F':' '/Seconds_Behind_Master/{print $2}')                                                                                              
本文来自: 华盟黑客(中国最大黑客培训中心网站) 详细出处参考:http://www.hmhack.com/article/html/283.html

最新文章

  1. 解决ArcGIS中因SDE或数据库配置问题而导致服务宕掉的一种思路
  2. openGL漫游功能简单实现
  3. Python中的可迭代对象与迭代器对象
  4. CI框架源码阅读笔记6 扩展钩子 Hook.php
  5. [转]Ionic + AngularJS angular-translate 国际化本地化解决方案
  6. 【SpringMVC】SpringMVC系列4之@RequestParam 映射请求参数值
  7. MEF初体验之七:Using Catalogs
  8. GPS校时器,GPS时钟装置,NTP网络时间服务器
  9. redis数据类型-列表类型
  10. Assets.xcassets误删后的恢复
  11. mybatis 日志的使用以及设计
  12. (贪心)P1223 排队接水 洛谷
  13. zabbix添加对haproxy的监控
  14. luogu P3760 [TJOI2017]异或和
  15. 7.11python多进程
  16. 【Linux学习一】命令查看与帮助
  17. 安卓中使用HttpURLConnection连接网络简单示例 --Android网络编程
  18. 【Python】一些零散的练习
  19. 从数据库到NoSQL思路整理
  20. 2-Fifth Scrum Meeting20151205

热门文章

  1. JS制作的简单的三级及联
  2. jgroups 常见概念
  3. 在WindowsServer2008服务器上安装SQLServer2008R2
  4. mongo常用命令
  5. Windows xp 重载内核(使用Irp进行文件操作)
  6. SharePoint 2013 自定义翻页显示列表项
  7. Innodb的事务与日志 & JTA事务
  8. jquery 应用小结
  9. 如何设置box shadow的透明度
  10. C++组合问题