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:
[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