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

[Dmitry Torokhov]

On Tue, Nov 29, 2011 at 11:55:23PM +0200, Andras Mantia wrote:
> 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).

Yes.

> 
> > 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.

I do not think this is wrong venue for this discussion as it is not of
"how do I?" type of question.

> 
> >> > 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...

OK, so I guess we have similar setups, the difference id that Im using
online IMAP for most of my mail.

> 
> >> 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.

Like I said I'll try to find some time and profile kmail and see where
it is spending most of the time.

Thanks.

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