MySQL server has gone away on simple select query

since any weeks I have a problem with a simple SQL Query where from time to time the mySQL Server has gone away. But in the last time I have this crashes every day 1,2 times day.

The query is very simple:

SELECT ... from table where field = 'some string' LIMIT 1

The table has 15 rows and the "field" where the query selects is an index. The explain is very good and shows that the index is used.

The table is innodb. At the beginning I have used MyISAM but the problem is the same. After the crashes began I have transform it into InnoDB but this does not helpes.

Where can be the problem here?

Server version: 5.0.51a-24+lenny3 (Debian) mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2

Tha开发者_StackOverflownk you very much!

Cheers Nik

---

If your data is corrupted then it can cause the exact symptoms you're describing.

Try running a CHECK TABLE table to confirm and a REPAIR TABLE table to resolve.