tools to monitor database errors - support

25 Apr 2007


      Hi-
I would like to know when tables in the db stop responding, such as
(table "watchdog"/ "cache"/ "sessions"); does any one know of tools that
monitor error_logs and would notify you via email?
All suggestions would be greatly appreciated.
Thanks!
See examples below:
Example 1- Message in the error_log when the table "watchdog" stop
responding:
root@DNDI-8399 logs]# tail -f error_log
[client 220.181.19.168] PHP Fatal error:  Can't open file:
'watchdog.MYI' (errno                                             :
145)\nquery: INSERT INTO watchdog (uid, type, message, severity, link,
locatio                                             n, hostname,
timestamp) VALUES (0, 'php', 'mysql_fetch_array(): supplied argumen
t is not a valid MySQL result resource in
/var/www/vhosts/ndipartidos.org/httpdo
cs/includes/common.inc(2011) : eval()\'d code on line 11.', 2, '',
'/en/blog/43                                             719',
'220.181.19.168', 1177511462) in
/var/www/vhosts/ndipartidos.org/httpdocs/
includes/database.mysql.inc on line 66
[client 220.181.19.168] PHP Fatal error:  Can't open file:
'watchdog.MYI' (errno                                             :
145)\nquery: INSERT INTO watchdog (uid, type, message, severity, link,
locatio                                             n, hostname,
timestamp) VALUES (0, 'php', 'mysql_fetch_array(): supplied argumen
t is not a valid MySQL result resource in
/var/www/vhosts/ndipartidos.org/httpdo
cs/includes/common.inc(2011) : eval()\'d code on line 11.', 2, '',
'/en/blog/38                                             7',
'220.181.19.168', 1177511502) in
/var/www/vhosts/ndipartidos.org/httpdocs/in
cludes/database.mysql.inc on line 66
Example 2- in this case the site does not load; just a blank page
appears.
root@DNDI-8399 ~]# cd /var/www/vhosts/aswat.com/statistics/logs
[root@DNDI-8399 logs]# tail -f error_log
[client 216.65.65.26] PHP Fatal error:  Maximum execution time of 30
seconds exc                                             eeded in
/var/www/vhosts/aswat.com/httpdocs/includes/menu.inc on line 996
[client 217.160.230.163] PHP Notice:  unserialize(): Error at offset
34980 of 35                                             750 bytes in
/var/www/vhosts/aswat.com/httpdocs/includes/bootstrap.inc on line 2
39
[client 74.6.75.12] PHP Notice:  unserialize(): Error at offset 34980 of
35750 b                                             ytes in
/var/www/vhosts/aswat.com/httpdocs/includes/bootstrap.inc on line 239