https://bugzilla.novell.com/show_bug.cgi?id=726206 https://bugzilla.novell.com/show_bug.cgi?id=726206#c8 --- Comment #8 from Andras Mantia <amantia@kde.org> 2011-11-26 21:14:49 UTC --- Oh, seems Volker didn't backport fsck and vacuum to 1.6.2 :( It will be in the next release only then. Alternatively you can compile yourself or get it from the soon to be released KDE 4.8 beta 1. Only the Akonadi server (not the libraries) is needed and it is of course compatible with the old version. As far as I know (and as I see in the akonadi database), PLD:ENVELOPE is stored for every mail. For all the others there is a PLD:HEAD and PLD:RFC822 (the whole mail), but this should have real data only for disconnected IMAP accounts. For all the others, including maildir and mbox, the header and body part should be stored only for a short time, for me it is 1 minute. You can check in the top level folder properties. (I ignore contacts/calendars that I don't know how long are cached). Just FYI (not that it matters for disc space) PLD:RFC822 itself holds the mail only if it is less then 4KB, anything bigger is stored in external files. But again, the storage is permanent only for disconnected imap. Back to your results. I have 2.7GB local mail in maildir. My ~/.local/share/akonadi/file_db_data is 350MB, which I can say it is roughly that amount of disconnected IMAP email cached there permanently. My mysql database is 692MB. Your query returns: +--------------+-------------+--------------+-----------------+ | name | count(name) | datasize_avg | datasize_sum_MB | +--------------+-------------+--------------+-----------------+ | PLD:ENVELOPE | 272777 | 375 | 97 | | PLD:HEAD | 272777 | 194 | 51 | | PLD:RFC822 | 102905 | 3815 | 374 | +--------------+-------------+--------------+-----------------+ The RFC822 part is large and worries me as well. But the HEAD for me is much less then for you, which makes me wonder what goes wrong in your case. Did you have any failed migration? Do you really need the mixed maildir/mailbox folder (the old KMail style storage)? What is the cache policy for you local folders? (Folder Properties->Retrieval) We *might* see a mixedmaildir specific issue as well here. The mixedmaildir thing is really there for KMail1 users, as it is a non-standard mail storage type. I urge you to change your folders to "clean" maildir if possible. And if you did that (or if you happened to have a failed migration), you could: - stop akonadi - remove the akonadi db (.local/share/akonadi) and config (.config/akonadi) - start akonadi - add back the agents, but now use the Maildir and not mixedmaildir (KMail Maildir) agent The ups is that you are sure you have a clean database, the downs is that your filters will be wrong and you have to fix them. You can also run a query like this: select parttable.name, count(parttable.name), round(avg(parttable.datasize)) as datasize_avg, round(sum(parttable.datasize)/1024/1024) as datasize_sum_MB from parttable,pimitemtable, collectiontable where pimitemtable.collectionid=collectiontable.id and collectiontable.resourceid=RESOURCEID and parttable.pimitemid=pimitemtable.id and parttable.name like 'PLD%' group by parttable.name and get the RESOURCEID from the resourcetable, to see how much space is needed per account type. Might help even more to nail down which resource is using (abusing?) the cache. Eg. for me, from the above amount: - maildir resource: 90M (this corresponds to the index files from KMail1 !) - disconnected imap: 431MB (expected, as this is a local cache) - kolab resource: 1MB (converts calendar mails to calendar data) - some small amounts (<1MB) for addressbook and local calendar resource Looking at this data - it is the first time I do such a research -, I have to say that it is not that bad. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.