https://bugzilla.novell.com/show_bug.cgi?id=726206 https://bugzilla.novell.com/show_bug.cgi?id=726206#c7 --- Comment #7 from Christian Boltz <suse-beta@cboltz.de> 2011-11-26 13:29:14 CET --- (In reply to comment #6)
Thanks for the numbers, indeed the index files were much smaller, it means.... Try akonadictl vacuum and see how much the database decreases and akonadictl fsck to see if you have stale files in file_db_data.
akonadictl does not support those parameters (on openSUSE 12.1, KDE 4.7.2) - were they added in a later KDE release?
Regarding email headers, not the full header is cached, only the envelope (according to the main akonadi developer).
That seems to depend (but I have no idea on what ;-). I just checked the content of "parttable" and the result is mixed: select name, count(name), round(avg(datasize)) as datasize_avg, round(sum(datasize)/1024/1024) as datasize_sum_MB from parttable where name like 'PLD%' group by name; +--------------+-------------+--------------+-----------------+ | name | count(name) | datasize_avg | datasize_sum_MB | +--------------+-------------+--------------+-----------------+ | PLD:ENVELOPE | 340754 | 355 | 115 | | PLD:HEAD | 340754 | 3141 | 1021 | | PLD:RFC822 | 32933 | 10657 | 335 | +--------------+-------------+--------------+-----------------+ PLD:ENVELOPE rows only contains the most important headers PLD:HEAD rows contain the full mail headers (which can already be pretty big on mailinglist posts) PLD:RFC822 rows contain complete mails with header and body (!) (I don't know if those mails are stored in my maildir somewhere...) There seems to be a connection between PLD:HEAD and PLD:Envelope because the count() of both is the same.
But it looks we should certainly reduce the space used somehow.
Indeed ;-)
Regarding virtuosobackend: no, it is not Akonadi. It is the "semantic desktop search database", which indeed indexes your mail for full text search and finding relation between mails, addressbook and other files on your system, but it might contain also indexes from your other files on the file system. So it interacts with KMail/Akonadi, but it is a different server and functionality, outside of Akonadi's control.
Thanks for the explanation. Sounds like something I don't really need ;-) - is it possible to disable it and to delete its cache? -- 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.