[Koha-devel] Database size with InnoDB

[Zeno Tajoli]

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 @)