Hello.
>mysql Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686) You have an old MySQL version which contains lots of bugs (it's an alpha!). I strongly recommend you to upgrade to the latest release (4.1.12 now) and use official binaries. >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)) "Praveen KS" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
