Shulou(Shulou.com)05/31 Report--

Editor to share with you how to achieve mysql data collection shell script, I hope you will learn something after reading this article, let's discuss it together!

#! / bin/sh INTERVAL=5 PREFIX=$INTERVAL-sec-status RUNFILE=/home/benchmarks/running mysql- e 'SHOW GLOBAL VARIABLES' > > mysql-variables while test-e $RUNFILE Do file=$ (date +% financing% I) sleep=$ (date +% s.% N | awk "{print $INTERVAL-(\ $1% $INTERVAL)}") sleep $sleep ts= "$(date +" TS% s% N% F% T ")" loadavg= "$(uptime)" echo "$ts $loadavg" > $PREFIX-$ {file}-status mysql-e 'SHOW GLOBAL STATUS' > $PREFIX-$ (file)-status & echo "$ts $loadavg" > > $PREFIX-$ {file}-innodbstatus echo-e 'SHOW ENGINE INNODB STATUS\ G' > $PREFIX-$ {file}-innodbstatus & echo "$ts $loadavg" > > $PREFIX-$ {file}-processlist mysql-e 'SHOW FULL PROCESSLIST\ G' > $PREFIX-$ {file}-processlist & echo $ts done echo Exiting because $RUNFILE does not exist. After reading this article, I believe you have a certain understanding of "how to achieve mysql data collection shell script". If you want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.