通过shell抓取mysql应用的CPU、内存负载

原创

yangzhimingg 2019-05-22 14:27:27 博主文章分类：shell脚本 ©著作权

文章标签 mysql CPU 文章分类 运维

©著作权归作者所有：来自51CTO博客作者yangzhimingg的原创作品，请联系作者获取转载授权，否则将追究法律责任

通过shell抓取mysql应用的CPU、内存负载

注：此处抓取的CPU使用率同top命令显示，即100%为1个core，是有可能超过100%的

vi dbload.sh

#!/bin/bash

Date=date +"%Y-%m-%d %H:%M:%S"

Datee=date +%Y-%m-%d

Se=/bin/hostname

Cp=/bin/ps aux | grep 'mysql.sock' | head -n 1 | awk -F[:" "]+ '{print $3}' Me=/bin/ps aux | grep 'mysql.sock' | head -n 1 | awk -F[:" "]+ '{print $4}'

/bin/echo "$Date,$Se,$Cp,$Me" > /log/dbload.txt

/bin/cat /log/dbload.txt | tr -s '[:blank:]' > /log/dbload2.csv

/usr/bin/mysql -h 10.0.0.2 -u icinga2 -p'xxxxxxx' --local-infile=1 dbload -e "LOAD DATA LOCAL INFILE '/log/dbload2.csv' INTO TABLE loadavg FIELDS TERMINATED BY ','"

:wq

mysql部分：

create database dbload default character set utf8; create table loadvag(time datetime,server char(50),cpu float,mem float); grant all on dbload.* to icinga2@'10.%' identified by 'xxxxx'; flush privileges; exit

grafana语句：

select UNIX_TIMESTAMP(Time) as time, cpu as "db2" from loadavg where server="db2";