send mail of digest-slowlog

digest-slowlog.sh

#!/bin/bash

GROUP="hoge-service"
HOST_MASTER="master"
HOST_SLAVE="slave01 slave02 slave03"
MAILTO="[email protected]"
TMPFILE=/tmp/slow-log.`date "+%s"`.log

echo "${GROUP} servers summary" > ${TMPFILE}
echo >> ${TMPFILE}

## master
for TARGET in ${HOST_MASTER}
do
  echo "${TARGET} ----------" >> ${TMPFILE}
  ssh ${TARGET} "zcat /var/log/mysql/mysqld-slow.log-`date "+%Y%m%d"`.gz" | pt-query-digest >> ${TMPFILE}
  echo >> ${TMPFILE}
done

## slave
for TARGET in ${HOST_SLAVE}
do
  echo "${TARGET} ----------" >> ${TMPFILE}
  ssh ${TARGET} "zcat /var/log/mysql/mysqld-slow.log-`date "+%Y%m%d"`.gz" | pt-query-digest >> ${TMPFILE}
  echo >> ${TMPFILE}
done

## mail
cat ${TMPFILE} | mail -s "Summary of slow-query ${GROUP}" ${MAILTO}
rm -f ${TMPFILE}