MySQL database "table is marked as crashed" ... Zabbix item to monitor it

[vitS]

Hi,

Sometimes we have crashed tables, so I decided to create monitoring of such cases in zabbix.

Maybe someone implemented it already?

I tried:

- to scan log /var/db/mysql/servername.err for "is marked as crashed" -> for one server it is working, but the problem that on each server name is different. Maybe someone can point me how to find this log for monitoring - .err

Thanks,