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