Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Question Unanswered: InnoDb tablespace compaction

    Hi,

    I have made a test database for performance testing and my InnoDb tablespace grew from 1Gig to 8 Gig... After I dropped that test database, the tablespace stayed to the same size. How can I "resize" it to its original size?

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    Unfortunately there is no way to reduce the size of an innodb tablespace at the moment.

    There are two solutions
    1)
    - Export
    - Drop the database and delete he files
    - Recreate the database
    - Import

    2)
    - Convert all tables to MyISAM
    - Restart MySQL with skip-innodb in my.cnf
    - Delete the innodb files
    - Restart MySQL with new innodb file parameters
    - Convert the tables back to innodb

Posting Permissions

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