mysql性能检查脚本-部分(三)
tatus like 'Innodb_buffer_pool_reads'; "
innob_02="show status like 'Innodb_buffer_pool_read_requests'; "
innob_re01="innob_re01.`date +%Y%m%d%H%M%S`.txt"
innob_re02="innob_re02.`date +%Y%m%d%H%M%S`.txt"
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${innob_01}" |grep -v Variable_name \
|cut -f 2 >${innob_re01}
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${innob_02}" |grep -v Variable_name \
|cut -f 2 >${innob_re02}
innob_03=`cat ${innob_re01}`
innob_04=`cat ${innob_re02}`
if [ "${innob_03}" -eq 0 ] ;then
cechon "7. there is no any value!" green
echo " "
else
innob_05=`awk 'BEGIN{print '${innob_03}' / '${innob_04}'}'` #shell默认不支持浮点运算
innob_06=`awk 'BEGIN{print '1-${innob_05}'}'` #shell默认不支持浮点运算
innodb_buffer_read_hits=`awk 'BEGIN{print '${innob_06}' * 100}'`
cechon "7. current mysql Innodb_buffer_read_hits is: ${innodb_buffer_read_hits} " red
echo " "
fi
rm -rf ${innob_re01}
rm -rf ${innob_re02}
#8.Query Cache命中率
#Query_cache_hits =((Qcache_hits/(Qcache_hits+Qcache_inserts+Qcache_not_cached))*100)
qc_01="show status like 'Qcache_hits'; "
qc_02="show status like 'Qcache_inserts'; "
qc_03="show status like 'Qcache_not_cached'; "
qc_re01="qc_re01.`date +%Y%m%d%H%M%S`.txt"
qc_re02="qc_re02.`date +%Y%m%d%H%M%S`.txt"
qc_re03="qc_re03.`date +%Y%m%d%H%M%S`.txt"
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${qc_01}" |grep -v Variable_name \
|cut -f 2 >
${qc_re01}
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${qc_02}" |grep -v Variable_name \
|cut -f 2 >${qc_re02}
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${qc_03}" |grep -v Variable_name \
|cut -f 2 >${qc_re03}
qc_04=`cat ${qc_re01}`
qc_05=`cat ${qc_re02}`
qc_06=`cat ${qc_re03}`
if [ "${qc_04}" -eq 0 ] ;then
cechon "8. there is no any value!" green
echo " "
else
qc_07=`awk 'BEGIN{print '${qc_04}' + '${qc_05}' + '${qc_06}' }'`
qc_08=`awk 'BEGIN{print '${qc_04}'/'${qc_07}'}'`
query_cache_hits=`awk 'BEGIN{print '${qc_08}' * 100}'`
cechon "8. current mysql query_cache_hits is: ${query_cache_hits} " red
echo " "
fi
rm -rf ${qc_re01}
rm -rf ${qc_re02}
rm -rf ${qc_re03}