Re: mysqld crashes during long index build

2003-07-02 Thread Heikki Tuuri
Heikki - Original Message - From: ""Emile Bourquin"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, July 03, 2003 9:01 AM Subject: mysqld crashes during long index build > --=_NextPart_000_007B_01C340ED.B86BB880 > Content-Type: text/p

mysqld crashes during long index build

2003-07-02 Thread Emile Bourquin
Dual Xeon 2.8 GHz, hyperthreaded, 533 MHz FSB 2 GB RAM Red Hat, kernel-2.4.20-18.9 SMP mysql 4.0.13, InnoDB table holding 32 million+ records, building an index using: create index BY_NAME on PROFILE_NAMES (LAST_NAME,FIRST_NAME) my.cnf contains: [mysqld] datadir=/var/lib/mysql socket=/var/lib/my