For many weeks I have had a problem with a simple SQL query where from time to time the MySQL server has crashed. But recently it is crashing every day, 1-2 times a 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 has an index. The explain is very good and shows that the index is used.
The table is innodb. At the beginning I used MyISAM but the problem is still the same. After the crashes began I have transformed it into InnoDB but this does not help.
Where can be the problem be?
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
Thank you very much!