Hi folks

I'm trying to get a table's engine changed from myisam to innodb. It's a table about 22GB in size.

It's taken about an hour so far and is still churning. Any idea how long this can take?

Running MySQL 4.1 on this box.

Thanks in advance for your assistance!

Unfortunately I have no idea, and i would guess a long time perhaps?
Did it finish in the end? How long did it take? Any information you have i'm sure would be of use to others.

Just to satisfy my own curiosity...
What kind of information are you storing in a 22Gb table?!

How long does a simple "SELECT *" take on the table in question?

I actually goofed - the size of the table is closer to 2GB.

It never finished (waited 6 hours). So, we renamed the table instead, created a new table of the original name, changed the engine to innodb, and then ran an "insert into table select * from original_table" which took long but we could get a pulse on where we stood on things.

I'm sure that wasn't the best idea - but any thoughts?

changing to a new table is always going to be smarter than attempting to change in place. Personally I never even thought any one would try that.