Index continues to fail on large database

2004-03-05 Thread Devios McShady
On February 5, I posted this message to the list describing my problem: http://archives.neohapsis.com/archives/mysql/2004-q1/2398.html I received the following response and posted a reply to this response, respectively reply: http://archives.neohapsis.com/archives/mysql/2004-q1/2426.html response:

Re: index failing on large database - any ideas why?

2004-02-05 Thread Devios McShady
>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > On 2/4/04, 11:11:12 PM, Devios McShady <[EMAIL PROTECTED]> wrote regarding > index failing on large database - any ideas why?: > >

index failing on large database - any ideas why?

2004-02-04 Thread Devios McShady
I have a database with one 17GB table containing about 23 million customer records. The table has about 15 fields. I wanna index five of them to speed up searching. My indexing operation keeps failing with error:127 (record table has crashed). The process fails of different fields at different