[Akonadi] [Bug 319208] KMail unresponsive after POP3 retrieval and filtering with high MySQL load for minutes
Martin Steigerwald
Martin at Lichtvoll.de
Thu May 2 10:32:56 BST 2013
https://bugs.kde.org/show_bug.cgi?id=319208
--- Comment #3 from Martin Steigerwald <Martin at Lichtvoll.de> ---
Just tried to just synchronize the maildir resource, by selecting to look for
new mails from it from the pull down menu.
The time of the high CPU usage seems to shorter, but it still pikes to 200% and
well it has been less mails since last download.
Mytop shows:
MySQL on localhost (5.5.30-1.1) up 0+00:09:33
[11:20:02]
Queries: 5.0 qps: 0 Slow: 0.0 Se/In/Up/De(%):
00/00/00/00
qps now: 0 Slow qps: 0.0 Threads: 29 ( 3/ 0)
00/00/00/00
Key Efficiency: 100.0% Bps in/out: 0.3/ 35.4 Now in/out: 8.4/ 2.0k
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- --------------
3 martin localhost akonadi 0 Execut SELECT
PartTable.id, PartTable.pimItemId, PartTable.name, PartTable.data,
PartTable.datasize, PartTa
30 martin localhost akonadi 0 Execut SELECT
PimItemTable.id, FlagTable.name FROM PimItemTable INNER JOIN
PimItemFlagRelation ON ( PimItem
31 root localhost 0 Query show full
processlist
8 martin localhost akonadi 79 Sleep
[… about 20 more sleeping connections …]
MySQL on localhost (5.5.30-1.1) up 0+00:09:33
[11:20:02]
Queries: 5.0 qps: 0 Slow: 0.0 Se/In/Up/De(%):
00/00/00/00
qps now: 0 Slow qps: 0.0 Threads: 29 ( 3/ 0)
00/00/00/00
Key Efficiency: 100.0% Bps in/out: 0.3/ 35.4 Now in/out: 8.4/ 2.0k
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- --------------
3 martin localhost akonadi 0 Execut SELECT
PartTable.id, PartTable.pimItemId, PartTable.name, PartTable.data,
PartTable.datasize, PartTa
30 martin localhost akonadi 0 Execut SELECT
PimItemTable.id, FlagTable.name FROM PimItemTable INNER JOIN
PimItemFlagRelation ON ( PimItem
31 root localhost 0 Query show full
processlist
8 martin localhost akonadi 79 Sleep
[… about 20 more sleeping connections …]
MySQL usage is high after apparently the POP3 download completed already and
KMail was telling it was synchronizing folders.
So I think thats its the local folder synchronization process that clicking on
the mail retrieval icon triggers causing issues here.
But then after POP3 I also saw maildir resource synchronizing, but maybe just
the folders that have been filtered into? Well, I stop
here with speculation, as I do not really understand what the maildir
synchronisation is doing after POP3 download. I thought
the maildir resource would know where the POP3 resource placed new mails, so no
need to synchronize…
Well on subsequent tries to just trigger a look for mails in the maildir
resource, MySQL CPU usage is down to about 20%, sometimes a bit more, sometimes
a bit less:
ATOP - merkaba 2013/05/02 11:26:55
--------- 10s
elapsed
PRC | sys 3.82s | user 13.68s | #proc 252 | #trun 4 | #tslpi
525 | #tslpu 0 | #zombie 0 | clones 1 | | #exit
0 |
CPU | sys 34% | user 139% | irq 0% | idle 227% | wait
0% | | steal 0% | guest 0% | curf ?MHz | curscal
?% |
cpu | sys 19% | user 67% | irq 0% | idle 14% | cpu002 w
0% | | steal 0% | guest 0% | curf ?MHz | curscal
?% |
cpu | sys 9% | user 53% | irq 0% | idle 38% | cpu003 w
0% | | steal 0% | guest 0% | curf ?MHz | curscal
?% |
cpu | sys 3% | user 12% | irq 0% | idle 85% | cpu000 w
0% | | steal 0% | guest 0% | curf ?MHz | curscal
?% |
cpu | sys 3% | user 8% | irq 0% | idle 90% | cpu001 w
0% | | steal 0% | guest 0% | curf ?MHz | curscal
?% |
CPL | avg1 0.66 | avg5 1.00 | | avg15 0.83 |
| csw 155438 | intr 27726 | | | numcpu
4 |
MEM | tot 7.6G | free 1.4G | cache 2.3G | dirty 0.2M | buff
89.6M | slab 775.1M | slrec 730.9M | shmem 227.0M | shrss 70.4M | shswp
1.6M |
SWP | tot 12.0G | free 11.4G | | |
| | | | vmcom 5.4G | vmlim
15.8G |
LVM | erkaba-home2 | busy 0% | read 0 | write 58 | KiB/r
0 | KiB/w 54 | MBr/s 0.00 | MBw/s 0.31 | avq 9.85 | avio 0.34
ms |
LVM | merkaba-home | busy 0% | read 2 | write 75 | KiB/r
16 | KiB/w 29 | MBr/s 0.00 | MBw/s 0.22 | avq 15.21 | avio 0.18
ms |
LVM | rkaba-debian | busy 0% | read 0 | write 33 | KiB/r
0 | KiB/w 16 | MBr/s 0.00 | MBw/s 0.05 | avq 5.75 | avio 0.12
ms |
DSK | sda | busy 0% | read 2 | write 159 | KiB/r
16 | KiB/w 37 | MBr/s 0.00 | MBw/s 0.58 | avq 10.95 | avio 0.23
ms |
PID TID RUID EUID THR SYSCPU USRCPU VGROW
RGROW RDDSK WRDSK ST EXC S CPUNR CPU CMD
1/2
1029 - martin martin 2 2.04s 6.76s 0K
0K 0K 0K -- - R 2 90%
akonadi_agent_
979 - martin martin 30 0.91s 5.32s 0K
0K 0K 0K -- - S 1 64%
akonadiserver
987 - martin martin 45 0.03s 0.72s 0K
0K 0K 3140K -- - S 1 8% mysqld
That far for now. I take some more time to see how it goes with the larger
innodb buffer setting.
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list