mysql cpu和内存监控

最新推荐文章于 2023-10-30 15:37:40 发布

weixin_30268071

最新推荐文章于 2023-10-30 15:37:40 发布

阅读量268

点赞数

文章标签：数据库 awk

原文链接：http://www.cnblogs.com/fanxuanhui-linux/p/6242979.html

版权

mysqlMem 监控：
#!/bin/bash
Pid=`/bin/ps -ef|grep mysqld|grep -Ev "grep|safe"|awk '{print $2}'`
vMem=`/usr/bin/top -b -n 1 -p $Pid |grep mysql |awk '{print $5}'|awk -F"g" '{print $1}'`
rMem=`/usr/bin/top -b -n 1 -p $Pid |grep mysql |awk '{print $6}'|awk -F"g" '{print $1}'`
if [ $1 == "vMem" ];then
　　echo $vMem
elif [ $1 == "rMem" ];then
　　echo $rMem
fi

mysqlCpu监控：
#!/bin/bash
Pid=`/bin/ps -ef|grep mysqld|grep -Ev "grep|safe"|awk '{print $2}'`
#vMem=`/usr/bin/top -b -n 1 -p $Pid |grep mysql |awk '{print $5}'|awk -F"g" '{print $1}'`
Cpu=`/usr/bin/top -b -n 1 -p $Pid |grep mysql |awk '{print $9}'|awk -F"g" '{print $1}'`
if [ $1 == "Cpu" ];then
　　echo $Cpu
elif [ $1 == "rMem" ];then
　　echo $rMem
fi

转载于:https://www.cnblogs.com/fanxuanhui-linux/p/6242979.html