[Kde-pim] Akonadi MySQL backend: tuning for larger accounts or switching to MariaDB with a different storage engine?

[Martin Steigerwald]

Hi!

I reported

Bug 332626 - MySQL tuning: adaption of MySQL tuning options for larger 
accounts
https://bugs.kde.org/show_bug.cgi?id=332626


But its somewhat arguable, I know.

I think I saw quite an improvement with raising the default low innodb buffer 
pool size of Akonadi of 80 MiB, which is even below the MySQL default of 128 
MiB, to 256 MiB helped with a 11 GiB large POP3 account, especially when 
synchronizing linux-kernel-ml folder with about 223000 unread mails. And also 
on retrieving and filtering new mails there, which can make KMail quite 
unresponsive on a quite powerful machine (Sandybridge, 8 GB RAM, dual SSD 
BTRFS RAID 1). I will do some testing, yet it is difficult to know for sure. 
mysqltuner.pl script gave some clear recommendations tough, which are to high 
for a desktop machine tough, I think (>1 GiB of innodb buffer pool size). It 
seems it recommends adjusting to actual data size in database, which would 
only be suitable if all of the data is accessed often.

What is the amount data Akonadi accesses frequently? Are there any experiences 
with that? I bet it depends highly on how the user uses it and the amount of 
mails in a single folder to be synchronized.


What do you think?

Do you have any plans to switch to MariaDB and probably investigating storage 
engines which may be more suitable for tuning to desktop loads? InnoDB is 
difficult as innodb_buffer_pool_size needs to take free memory into account which 
can change quite rapidly on desktops or anything else than a dedicated 
database server. A engine which uses Linux pagecache for most of its caching 
would be interesting I think.


Just wanted to raise this topic.

Ciao,
Martin

-- 
Martin Steigerwald
Consultant / Trainer

teamix GmbH
Südwestpark 43
90449 Nürnberg

fon:  +49 911 30999 55
fax:  +49 911 30999 99
mail: martin.steigerwald at teamix.de
web:  http://www.teamix.de
blog: http://blog.teamix.de

Amtsgericht Nürnberg, HRB 18320
Geschäftsführer: Oliver Kügow, Richard Müller

** Frühjahrswissenstage bei teamix - 25.03.2014 | Frankfurt/Mainz 26.03.2014 | München 27.03.2014 ** http://www.teamix.de/wissenstag 

_______________________________________________
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/