MySQL获取系统性能和状态代码

数据运维 2023-04-22 泡泡 手机阅读

复制代码 代码如下: #!/bin/ksh INTERVAL=5 PREFIX=$INTERVAL-sec-status touch /tmp/running RUNFILE=/tmp/running my -e 'show global variables' mysql-variables while test -e $RUNFILE; do file=$(date +%F_%I) sleep=$(date +%s.%N | awk "{pr

                        <p>复制代码 代码如下: #!/bin/ksh INTERVAL=5 PREFIX=$INTERVAL-sec-status touch /tmp/running RUNFILE=/tmp/running my -e 'show global variables' &gt;&gt; mysql-variables while test -e $RUNFILE; do file=$(date +%F_%I) sleep=$(date +%s.%N | awk "{print $INTERVAL - (\$1 % $INTERVAL)}") sleep $sleep ts="$(date +"TS %s.%N %F %T")" loadavg="$(uptime)" echo "$ts $loadavg" &gt;&gt; $PREFIX-${file}-status my -e 'show global status' &gt;&gt; $PREFIX-${file}-status &amp; echo "$ts $loadavg" &gt;&gt; $PREFIX-${file}-innodbstatus my -e 'show engine innodb status\G' &gt;&gt; $PREFIX-${file}-innodbstatus &amp; echo "$ts $loadavg" &gt;&gt; $PREFIX-${file}-processlist my -e 'show full processlist\G' &gt;&gt; $PREFIX-${file}-processlist &amp; echo $ts done echo Exiting because $RUNFILE does not exist. </p>