Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Is it possible to compact an Innodb Table?

    hi
    i have a mysql 4.0.16 db with innodb tables...
    the database tables are frequently updated by deleting all data and putting in new data every 15 minutes..
    in this situation the database size is 13 GB instead of 3 Gb as should be? is there a way to compact the Innodb tables?
    i've fund a tool only for myisam such as myisamchk..
    Thank you

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    There is no tool like this cause INNODB use a table space instead of multiple files.

    But you can use this simple tech to defrag your tables and speed up you indices

    Dump your data to a text file
    drop the table
    recreate it and import you data

    You can also use

    ALTER TABLE yourtablename TYPE=InnoDB
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Dec 2003
    Posts
    2

    Innodb

    well thx..
    i've noticed that on /var/lib/mysql there are many file in this format:
    machinename-bin.001 to 00n...
    each file has many MB size..but what are these files?
    i've 23 files of that type..and i've deleted the first 21 ..and restarted mysql and all seems to work fine? is it possible to avoid the creation of such files? or is there a way to tell mysql to cancel them automatically?
    thx

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Red face

    thas was your transaction logs or your data

    You can configure how many file can be used by INNODB
    in MySql Start up option

    http://www.lasso-developpeur.net/us/...o?id=22&tab=db
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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