Re: InnoDB key adding slowness

2004-01-20 Thread Heikki Tuuri
"Keith Thompson"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, January 21, 2004 3:50 AM Subject: Re: InnoDB key adding slowness > I forgot to mention too that this is the 64bit MySQL 4.0.17 > running on Solaris9. > > >Hi all, >

Re: InnoDB key adding slowness

2004-01-20 Thread Keith Thompson
I forgot to mention too that this is the 64bit MySQL 4.0.17 running on Solaris9. >Hi all, >I decided I needed another index in an InnoDB table that has about >25 million rows (each 80 bytes long). As I've done dozens of times >with MyISAM tables, I did a simple "alter table": > alter table

InnoDB key adding slowness

2004-01-20 Thread Keith Thompson
Hi all, I decided I needed another index in an InnoDB table that has about 25 million rows (each 80 bytes long). As I've done dozens of times with MyISAM tables, I did a simple "alter table": alter table WMH_CHK_a add key JoinTrans (TransID) This has been running for 14 hours and I have