[Kde-pim] Akonadi MySQL backend: Using a file per table in order to be able to free disk space on truncating?

[Martin Steigerwald]

Am Freitag, 10. August 2012 schrieb Volker Krause:
> Hi,

Hi Volker,

> On Friday 10 August 2012 12:39:34 Martin Steigerwald wrote:
> > On doing some research regarding MySQL performance tuning I have been
> > given the hint to consider using a file per table via
> > "innodb_file_per_table" option.
> > 
> > Mainly cause of this advantage:
> > | · Reclaiming disk space when truncating a table."
> > 
> > http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.ht
> > ml
> > 
> > And this user comment:
> > | Posted by Chris Wagner on June 2 2011 11:23pm
> > | 
> > | It is absurd that there is not a builtin function to compact the
> > | ibdata file to reclaim unused space to the OS. *ALWAYS* use
> > | innodb_file_per_table.
> > 
> > http://dev.mysql.com/doc/refman/5.5/en/innodb-data-log-reconfiguratio
> > n.html
> > 
> > 
> > Last I checked – I am currently using PostgreSQL plugin where such a
> > vacuuming is always possible AFAIK – the mysql.conf for Akonadi
> > started MySQL didn´t include this.
> 
> Are you sure? server/src/storage/mysql-global.conf (which is the
> template used for the MySQL server started by Akonadi) has it set
> (line 48).

Hmmm, last I checked. I do not have any MySQL based Akonadi installation 
at the moment – and did not think of looking in the source. It might have 
been changed?

No. It seems to have been there since the beginning (commit 
52bc7682544cb04bf343d8cd13f80f5519856706 that added mysql-global.conf 
based on hints y Kristian Köhntopp). It seems I overlooked it.

Sorry for the noise.

> > Are you aware of that options? Did you consider it?
> > 
> > It might be useful to have:
> > 
> > akonadictl vacuum
> > 
> > have actually really reclaim disk space with MySQL default backend.
> 
> That does reclaim disk space here.

Cool. Then all is well ;)

Thanks,
-- 
Martin 'Helios' Steigerwald - http://www.Lichtvoll.de
GPG: 03B0 0D6C 0040 0710 4AFA  B82F 991B EAAC A599 84C7
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/