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 @) _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
