We're trying to write a monitoring process for our master so that if a
table is corrupt it will raise flags which can then trigger
operations.

We can do the basic stuff such as asserting that the port is open and
that we can ping the machine but I want to test if any
INSERT/UPDATE/DELETEs are failing on the master due to table
corruption.

For example, if you have a functioning DB and then deliberately
corrupt the tables (for testing of course) I'd want SOME way to detect
that INSERTs were failing on this table.

There's no way to currently detect this I believe.  SHOW STATUS
doesn't help nor does SHOW TABLE STATUS.

Any pointers?

--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to