slow query extract

Saturday, 22 October 2011 01:46

echo-log-query-#########################-/var/log/mysql/mysql-slowlog

// A cron to send extract of slow query log of 3 different servers by mail every day. Change the email address. It is assumed that the keys are saved to login to different servers.



35 23 * * * (ssh 192.29.0.214 mysqldumpslow /var/log/mysql/mysql-slow.log | head -200; echo "#########################"; echo "Slow query log from 121"; echo "#########################"; ssh 192.29.0.121 mysqldumpslow /var/log/mysql/mysql-slow.log | head -200; echo "#########################";  echo "Slow query log from 213"; echo "#########################"; ssh 192.29.0.213 mysqldumpslow /var/log/mysql/mysql-slow.log | head -200 ) | mailx -s "My City slow query log from 214, 121 and 213" shantanu.oak+
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it
  > /root/shantanu/dumpslowsuccess.txt 2> /root/shantanu/dumpslowerror.txt