[Kde-pim] Slowness in POP3 case, maildir resource stat()ing on /etc/localtime very often (was: Re: ... MySQL backend: tuning for larger accounts...)

[Mark Gaiser]

On Thu, Mar 27, 2014 at 6:13 PM, Jos Poortvliet <jospoortvliet at gmail.com> wrote:
> On Thursday 27 March 2014 16:35:44 Martin Steigerwald wrote:
>> Am Donnerstag, 27. März 2014, 15:48:15 schrieb Daniel Vrátil:
>> > On Thursday 27 of March 2014 14:46:57 Martin Steigerwald wrote:
>> > > Am Donnerstag, 27. März 2014, 12:24:39 schrieb Daniel Vrátil:
>> > > > Hi,
>> > > >
>> > > > thanks a lot for all the analysis. I will need to read up on this and
>> > > > consult  MySQL documentation first, so I'll go through it next week
>> > >
>> > > Gee, I now had it again with my POP3 setup. KMail blocked for minutes.
>> > > akonadi maildir resource 100% CPU bound. And I think I found part of the
>> > > reason why:
>> > >
>> > > 70% of all stat calls, about 100000 of them during that strace, were to
>> > > stat /etc/localtime.
>> >
>> > Is your TZ env variable set? If not set it to TZ="Europe/XX" (whatever
>> > your
>> > TZ is) and try again, it might reduce the amount of stats.
>>
>> Seems to help:
>>
>> merkaba:/tmp> grep -c "stat(\"/etc/localtime" strace-blub.txt
>> 0
>> merkaba:/tmp#1> grep -c "stat(" strace-blub.txt
>> 998
>>
>> Still KMail was blocked for some time, but appeared to be shorter,
>> definately wasn´t a minute, but this was also during KDE session startup
>> with Akonadi starting and MySQL was using 120% CPU (possibly due to other
>> initialization reasons).
>>
>> I wait for some bigger mail batch to arrive and retest then and add comment
>> to bug.
>
> You want everybody on this list to send you a mail to help you test it?
>
> :P

Ohh, i can help with that.
A simple for loop in PHP. Something like:
for($i = 0; i < 10000; $i++)
{ mail() }

Will give you "just" 10000 mails :)
_______________________________________________
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/