通過grafana面板展示各home儲存的空間使用率及檔案數使用率

標籤：xxxxx   mina   load   rom   local   char   ase   空間使用率   int   

shell指令碼抓取各home儲存的空間使用率及檔案數使用率，寫道excel檔案裡，再寫到mysql裡，最後通過grafana面板展示

vi aa.sh

#!/bin/bash

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

Dir=/logs/Homes

Home1=df -h /home1 | tail -n 1 | awk -F[:" "]+ ‘{print $5}‘ | tr -d "%"
Homei1=df -i /home1 | tail -n 1 | awk -F[:" "]+ ‘{print $5}‘| tr -d "%"
Home2=df -h /home2 | tail -n 1 | awk -F[:" "]+ ‘{print $5}‘ | tr -d "%"
Homei2=df -i /home2 | tail -n 1 | awk -F[:" "]+ ‘{print $5}‘ | tr -d "%"
/bin/echo "$Date,home1,$Home1,$Homei1" > $Dir/Homeavg.txt
/bin/echo "$Date,home2,$Home2,$Homei2" >> $Dir/Homeavg.txt

/bin/cat $Dir/Homeavg.txt | tr -s ‘[:blank:]‘ > $Dir/Homeavg.csv

/usr/bin/mysql -h 10.0.0.2 -u icinga2 -p‘xxxxxx‘ --local-infile=1 jenkins_log2 -e "LOAD DATA LOCAL INFILE ‘/logs/Homes/Homeavg.csv‘ INTO TABLE homesavg FIELDS TERMINATED BY ‘,‘"

:wq

mysql -u root -p‘xxx‘

create database ming default character set utf8;
create table homesavg(time datetime,home char(50),homeavg float,homeiavg float);
grant all on ming.* to [email protected]‘localhost‘ identified by ‘xxxx‘;
exit

grafana配mysql略

查詢空間使用率：

select UNIX_TIMESTAMP(Time) as time, homeavg as "home1" from homesavg where home="home1";

查詢檔案數使用率：

select UNIX_TIMESTAMP(Time) as time, homeiavg as "home1" from homesavg where home="home1";

通過grafana面板展示各home儲存的空間使用率及檔案數使用率