MyISAM vs InnoDB ----- Incorrect key file for table error

[Praveen KS]

Hi,


In a table of 20,000 records I am frequented with this error:

Error 1034:
Incorrect key file for table: 'XXXX'; try to repair it

Frequency of this error: Three or four times a week.
I am logging the data it was trying to insert or update. After I,

repair table <tablename>

if, I try to insert the same data.. its accepts without getting corrupted.





Has this got something to do with concurrent users transacting with the 
database?

We are using the default type i.e MyISAM. InnoDB provides MySQL with a 
transaction-safe (ACID compliant) storage engine with commit, rollback, and 
crash recovery capabilities.
Does a change to InnoDB will get rid of this problem?

How can we make MyISAM ACID complaint?

Do we have to write it into our application?





MySQL version:

mysql  Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686)

On Red Hat Linux release 8.0 (Psyche) Linux version 2.4.18-14smp ([EMAIL 
PROTECTED]) (gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7))


Regards,
Praveen.

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td><img src="http://travel.indiainfo.com/img/banner-coolwaters.gif"; 
width="600" height="40" alt="" border="0" usemap="#banner"></td></tr>
</table>
<map name="banner">
<area alt="" coords="104,4,207,34" 
href="http://travel.indiainfo.com/destination/beaches/goa.html";>
<area alt="" coords="224,3,296,22" 
href="http://travel.indiainfo.com/packages/beaches/goa-holidayinn.html";>
<area alt="" coords="311,3,450,21" 
href="http://travel.indiainfo.com/packages/beaches/goa-majorda.html";>
<area alt="" coords="223,22,328,39" 
href="http://travel.indiainfo.com/packages/beaches/goa-oldanchor.html";>
<area alt="" coords="339,21,492,38" 
href="http://travel.indiainfo.com/packages/beaches/goa-kamath.html";>
<area alt="" coords="509,9,592,31" 
href="http://travel.indiainfo.com/booknow.html";>
</map>