2012 年 9月 26 日随笔档案 - zuoxingyu

2012年9月26日

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/09/11/how-to-find-mysql-queries-worth-optimizing/One question I often get is how one can find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries which cause the large portion of the load 阅读全文

posted @ 2012-09-26 14:43 zuoxingyu 阅读(815) 评论(0) 推荐(0)

MYSQL 数据库状态检查脚本(Python版）

摘要： #原shell版View Code 1 #!/bin/bash 2 3 # Script Name: mysql_status_check.sh 4 # Description: check mysql servers status 5 # Author: Xinggang Wang - OpsEye.com 6 # Create Date: 2012/3/30 7 8 #获取MySQL所在服务器IP/端口/用户名/密码 9 read -p "Host=" HOST 10 read -p "Port=" PORT 11 read -p "Use 阅读全文

posted @ 2012-09-26 14:08 zuoxingyu 阅读(2418) 评论(0) 推荐(1)

天堂