[Koha-devel] Database size with InnoDB

[Nahuel ANGELINETTI]

Hi,

Le Fri, 16 Jan 2009 12:46:29 +0100,
Zeno Tajoli <tajoli at cilea.it> a écrit :
> 
> >[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
>

Build a script should be the solution, BUT do not rewrite tables un
MyIsam, it doesn't support the foreign keys, so they will be dropped.
The solution I found in mysql website, is to mysqldump all the
database, drop/create the database, and reinsert all the datas.

bests,

--
Nahuel ANGELINETTI