Zabbix and MySQL, Crashed tables

[bbrendon]

If it still crashes then official MySQL support says that this is not a problem with MySQL.

Really? Interesting. I'm very curious why they say that.

[ProTON]

Interestingly swithing to InnoDB worked, even if this increased server's load a bit. MySQL says that InnoDB has better row locking capabilities. So if there are a lot of DELETE/UPDATE statements going on (just like in Zabbix housekeeping for example) and a server is taken down it is more resilient.

[zabbix_es]

Query of zabbix restart MySQL.

I had zabbix server installed on OpenSuSE 10.1 with MySQL 5.0.56 SP1 and when I tried to monitor event window in zabbix front-end, zabbix sent a well formed query to MySQL that restart the hole database server.
It was an strange issue of MySQL in this environment because I tried this query in other server and it works fine.
This is the reason because I didn't report this issue in this forum until now.
Now I have downloaded latest MySQL release (5.1.xxx) and this issue has dissapear.

I told you only just in case it could help you.