Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2008
    Posts
    2

    Unanswered: alter table myisam to innodb taking really long

    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!

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    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.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    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?
    George
    Home | Blog

  4. #4
    Join Date
    Feb 2008
    Posts
    2
    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?

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •