Bug 260630

Summary:	akonadi uses big mysql log files
Product:	[Frameworks and Libraries] Akonadi	Reporter:	Bernhard M. Wiedemann <kdebugsbmw>
Component:	general	Assignee:	kdepim bugs <kdepim-bugs>
Status:	RESOLVED NOT A BUG
Severity:	normal	CC:	cfeck, kairo, MurzNN, tokoe
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	openSUSE
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Bernhard M. Wiedemann 2010-12-18 14:46:47 UTC

Version:           unspecified (using KDE 4.5.85) 
OS:                Linux

akonadi comes with a mysql.conf file that has "innodb_log_file_size=64M" 
which means that KDE-LiveCDs will waste 128MB of RAM just for the two logfiles. 
The default log size is 5MB so there should be a very good reason to have it that big.
Additionally, wasting over 100MB per user on disks of regular installs is also not nice.

Reproducible: Always

Steps to Reproduce:
du -m ~/.local/share/akonadi/db_data/ib_logfile*

Actual Results:  
64
64

Expected Results:  
5
5

Comment 1 Christophe Marin 2010-12-26 23:52:09 UTC

This is for performance reasons. See the following page for the details: http://techbase.kde.org/Projects/PIM/Akonadi#Akonadi_needs_too_much_space_in_my_home_directory.21

Comment 2 Christoph Feck 2010-12-27 02:32:04 UTC

See also bug 217016 for possible workarounds.

Comment 3 Murz 2014-05-30 07:18:59 UTC

Confirm this problem, each user that contains almost empty database, eats 128 MB of logfiles (64mb in ib_logfile0 and 64mb in ib_logfile1)!
I think that size of log files must be smaller, or maybe depend of database size.

Comment 4 Murz 2014-05-30 07:21:12 UTC

At now we can fix this via changing defaults config file /etc/akonadi/mysql-global.conf
- string
innodb_log_file_size=64M
change to
innodb_log_file_size=1M