[prev in list] [next in list] [prev in thread] [next in thread]
List: kde-pim
Subject: [Kde-pim] Akonadi MySQL backend: tuning for larger accounts or switching to MariaDB with a different
From: Martin Steigerwald <ms () teamix ! de>
Date: 2014-03-26 12:06:23
Message-ID: 6320975.VLLJqURay7 () mango
[Download RAW message or body]
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@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@kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic