Hi to all, At 16.42 08/01/2009, Nahuel ANGELINETTI wrote:
I don't know if some people have a big experience from InnoDB and MySQL. We just see in mysql documentation innoDB does not reallow the disk space of deleted datas.
I'm try to find a solution of this problem. I'm still working but I think that those are good hits: 1) a .ibd file for every table http://bugs.mysql.com/bug.php?id=1287
[12 Jul 2004 15:51] Heikki Tuuri
If you use MySQL-4.1.3, define
innodb_file_per_table
in my.cnf, and do OPTIMIZE TABLE, the operating system will get the disk space back. That is because the table is stored in its own .ibd file, and OPTIMIZE will rebuild the whole table to another .ibd file, rename the .ibd file, and delete the old .ibd file.
2) buil a script to drop / rewrite tables. The hack is to rewrite tables in MyIsam type and after transform them into InnoDB http://www.saturn.in/portfolio/mysql.shtml Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)