[Kde-pim] Akonadi: single database design mistake?

[Andras Mantia]

Anders Lund wrote:

> I find this message disturbing and worrying.
> 
> I have
> 1.1G ~/Mail
> 1.5G ~/.local/share/akonadi
> 
> The majority of the akonadi directory is taken up by parttable. What is in
> that, and why, assuming it is data that is already in my mail? 
Might be. Recently I and somebody else did some tests with the Akonadi 
database size. We found that mixedmaildir seems to use unusable large amount 
of entries for mail headers in the database. Given that the migrator usually 
(all the time?) creates mixedmaildir resources, this might explain the size 
of the resource.
 I didn't yet have time to debug, not even to reproduce with a test account 
what we found, so the mixedmaildir developer wasn't even yet informed.
Anyway, look here for the details, tips and queries for the database:
https://bugzilla.novell.com/show_bug.cgi?id=726206

(yes, the opensuse bugzilla, i will move it bugs.kde.org when I can 
reproduce it).

> I do not
> even use akonadi for mail atm, is it a leftover from broken attempts at
> using kdepim 4.7? 

If you didn't remove the database after the failed attempts, most probably 
yes. Given that mysql and other database engines (for performance reason) 
doesn't really delete the data immediately when you mark it as deleted, the 
size can grow unless you vacuum (zip, compress) the database. With the 
upcoming (from KDE 4.8 beta) Akonadi you can do this with "akonadictl 
vacuum".

> Is there a way to remove that without loosing data
> (kaddressbook unfortunately uses akonadi to STORE data - namely groups,
> though iiutc that was never meant to be done)?

It should not store data there, just metadata. If it does, that is a serious 
bug and should be reported. I know close to zero about kaddressbook, so 
can't comment, but in case you think the data is not stored in external 
file/kolab server/whatever, report it.

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