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

[Milian Wolff]

On Tuesday 29 November 2011 12:55:21 Dmitry Torokhov wrote:

<snip>

> > > 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? And what is your box? For the record I am reading my
> mail from a Core2Duo laptop with 4Gb RAM and a mid-size SSD with TRIM
> support. Up until now it was more than adequate (the real work is done
> on headless workstations; mail is on dedicated servers).

<snip>
milian at minime:~/.local/share/akonadi$ du -hs *
8.0K    akonadi_control.error
8.0K    akonadi_control.error.old
476M    db_data
4.0K    db_misc
1.6G    file_db_data
36K     file_lost+found
4.0K    mysql.conf
0       socket-minime

Note how the database is only <500MB. Since I use dimap, it is of course no 
wonder that the bodies of the emails show up there as well (the 1.6GB).

Here you can find my data base internals:
http://paste.kde.org/152840/

bye
-- 
Milian Wolff
mail at milianw.de
http://milianw.de
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20111129/a57f56ce/attachment.sig>
-------------- next part --------------
_______________________________________________
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/