Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Below is the simple script for monitoring mysql error logs. You can set the cron jobs as per your need(eg. daily,hourly)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | #!/bin/bash SERNAME="Dbtut" SERPUBIP="10.0.0.0" SERVER="ip-10.0.0.0" Error_log_location=/var/log Alert_log_path=/opt/work/dblogs sudo egrep -i 'Error' $Error_log_location/mysqld.log |sort -u > $Alert_log_path/mysqld_ALERTLOG.txt if [ $? -eq 0 ]; then sudo cat $Error_log_location/mysqld.log > $Alert_log_path/mysqld_archived_`date +%Y-%m-%d-%H:%M:%S`.log if [ $? -eq 0 ]; then sudo cat /dev/null > $Error_log_location/mysqld.log else echo "failed to empty file" fi else echo "something went wrong after log file backup" fi cd /tmp/ cd /opt/work/dblogs/ FILE_TYPE="*.txt" FILE_TYPE1="*.log" find ${FILE_TYPE} -type f -mtime +1 -delete find ${FILE_TYPE1} -type f -mtime +1 -delete if [ -s "$Alert_log_path/mysqld_ALERTLOG.txt" ] ; then cat $Alert_log_path/mysqld_ALERTLOG.txt | mutt -s "URGENT -ERROR in Mysql Alert Log File for $SERNAME ($SERPUBIP) at `date` " -- ${MAIL_LIST} fi |
Hope this helps !
