search

Home >Database >Mysql Tutorial >MySQL获取系统性能和状态_MySQL

MySQL获取系统性能和状态_MySQL

WBOY
WBOYOriginal
2016-06-01 13:31:24883browse

bitsCN.com

MySQL获取系统性能和状态

 

#!/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 "{print $INTERVAL - (/$1 % $INTERVAL)}")      sleep $sleep      ts="$(date +"TS %s.%N %F %T")"      loadavg="$(uptime)"      echo "$ts $loadavg" >> $PREFIX-${file}-status      my -e 'show global status' >> $PREFIX-${file}-status &      echo "$ts $loadavg" >> $PREFIX-${file}-innodbstatus      my -e 'show engine innodb status/G' >> $PREFIX-${file}-innodbstatus &      echo "$ts $loadavg" >> $PREFIX-${file}-processlist      my -e 'show full processlist/G' >> $PREFIX-${file}-processlist &      echo $ts  done  echo Exiting because $RUNFILE does not exist.

 


bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql中engine=innodb和engine=myisam的区别_MySQLNext article：Mysql迁移到Oracle前需要了解的50件事_MySQL

Related articles

See more