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

[Andras Mantia]

Dmitry Torokhov wrote:

> I am sorry, I shoudl have mentioned that this was done with branch new
> akonadi database (as in rm -rf .local/share/akonadi) and re-creating my
> accounts (I did not even want to mentioned how original import screwed up
> my local folders that I use as archive for some emails). 

I hope the cleanup was complete (included config files as well).

> I also believe
> that all tasks that mysqld was supposed to do are done becuase the
> original email was written yestreday; it was stuk in moderation so I
> subscribed to kde-pim list and re-sent.

Just as a note, this is the devel list, the user list is kdepim-
users at kde.org. We can continue the thread here, but keep this is mind.

>> > Alas I still see akonadi/mysql peg my CPU ifor a while
>> > every time I switch mailboxes:
>> > 
>> >  1754 dtor      20   0 1175m  37m 4108 S 62.7  1.0  10:22.35 mysqld
>> >  3375 dtor      20   0  909m 159m  22m R 61.4  4.0   8:21.99
>> > akonadi_imap_re
>> >  1751 dtor      20   0 1363m  20m 5016 S  6.9  0.5   8:59.32
>> > akonadiserver
>> 
>> Well, for me mysqld hardly shows up in the top 10 or even more list of
>> most CPU intensive apps, and if it does for seconds, it is below 10%.
> 
> Would you mind staring sizes of your mailboxes and the rowcount on your
> akonadi database? 

My data is in the link I already posted. Here it is again:
https://bugzilla.novell.com/show_bug.cgi?id=726206#c8

In short: 
"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."

parttable has 644873 entries
pimitemtable has 269486 entries
pimitemflagrelation has 270754.

I use pop3, maildir and disconnected imap.

> And what is your box? 

I use regularly two computers:
- Quad Core, 8GB with KDE master 
- Core2Duo, 3GB laptop with the stable KDE (now "only" 4.7.2)

Both have regular hard disks.

I have local mail folders with 20000+ mails inside, the IMAP folders are 
smaller (as disconnected, all the mails are cached locally).

I found one case when mysql uses a noticable amount of CPU (60%) for a 
second or two on the Core2Duo: when I click on a such large folder the first 
time. It is another issue (and completely unrelated to Akonadi and the 
database) that KMail itself is busy listing the mails with 75% CPU usage for 
a minute or so...

>> So I
>> suspect that it is busy with something the migrator or some other code
>> asked "in the past" in a bad way.
> 
> There is hardly any past as the database is branch new.

You obviously run into a problem, that's clear. I told the possible 
technical reasons, but I cannot guess more.

> Since it was a clean import I'd rather not repeat this excersize.

This is your choice, of course and I accept 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/