Unanswered: Is it possible to compact an Innodb Table?
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..
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?