https://bugzilla.novell.com/show_bug.cgi?id=726206 https://bugzilla.novell.com/show_bug.cgi?id=726206#c9 --- Comment #9 from Christian Boltz <suse-beta@cboltz.de> 2011-11-27 02:18:03 CET --- (In reply to comment #8)
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.
It's also set to 1 minute for me.
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.
.. which I don't use. Nearly all of my mails are in a mixedmaildir. I used IMAP for some days (= some hundred mails) directly after the update to KMail2 - that doesn't explain the >32000 PLD:RFC822 mails...
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.
Most of my mails come via mailinglists, which means small mails, but lots of headers (mailinglist headers, and the longer transport route means more Received headers). If most of the mails you receive have big attachments, the header vs. body ratio is of course different. Nevertheless the average PLD:HEAD size of 194 bytes is really small - that would mean From, To, Subject, Date and maybe 2 or 3 other lines. Check your database what is stored there, for example the last 10 entries: select * from parttable where name='PLD:HEAD' order by id desc limit 10
Did you have any failed migration?
Yes, but IIRC I deleted the akonadi db and config afterwards. Maybe I overlooked something.
Do you really need the mixed maildir/mailbox folder (the old KMail style storage)?
I have 5 GB of mails in a mixedmaildir and don't really want to know how long it would take to migrate them to maildir. Migrate would mean to create a new maildir storage and move the mails there with drag&drop, right? I tried something like that with a mailinglist folder with 60000 mails some weeks ago. The result was that KMail was busy and unuseable for 10 minutes - and I didn't even move all the 60000 mails around, but used blocks of maybe 5000. And if I was really lucky, KMail even crashed... In other words: migrating all my mails to a maildir would probably take days. _If_ I do that, then the target is most probably a nice local dovecot server which (sorry to say that) seems to be a more useable, stable and faster solution these days.
What is the cache policy for you local folders? (Folder Properties->Retrieval)
[x] sync when opening the folder sync automatically after ___ never ___ [x] fetch message content when needed Keep message content for ___ 1 minute ___
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
I'd call it a mix of two standard mail storage types ;-)
type. I urge you to change your folders to "clean" maildir if possible.
See above - this isn't really an option.
And if you did that (or if you happened to have a failed migration), you could: [delete akonadi database and config]
I'm not too keen on that - re-syncing all my mail folders would take a day. I had to "test" that more than once already...
the downs is that your filters will be wrong and you have to fix them.
Been there, done that ;-) Besides that, I'm afraid that (at least) my sent mails since using KMail2 are not stored on disk, but only in the database. I have 165 mails/1 MB in the "sent messages" folder in KMail (a maildir storage which claims to be in /home/cb/.local/share/local-mail), but that directory is completely empty on the disk...
You can also run a query like this: .. 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.
Interesting idea, I'll check that tomorrow.
Looking at this data - it is the first time I do such a research -, I have to say that it is not that bad.
I hope you aren't surprised if I disagree ;-) -- 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.