[Akonadi] [Bug 319208] KMail unresponsive after POP3 retrieval and filtering with high MySQL load for minutes
https://bugs.kde.org/show_bug.cgi?id=319208 Martin Steigerwald mar...@lichtvoll.de changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |FIXED --- Comment #5 from Martin Steigerwald mar...@lichtvoll.de --- I didn´t see this since quite some time. Especially not after using the MySQL performance fixed in current Akonadi 1.13 branch. Thus closing. Thank you for Dan and Milian for improving MySQL performance in recent Akonadi 1.13. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 319208] KMail unresponsive after POP3 retrieval and filtering with high MySQL load for minutes
https://bugs.kde.org/show_bug.cgi?id=319208 --- Comment #4 from Martin Steigerwald mar...@lichtvoll.de --- I think raising the limit to 500M helped quite a bit, but what helped even more is: Go to account settings and then set the maildir resource to update on new start instead of manual check. This way when I click the retrieve mail button just the POP3 resource is triggered. And the maildir resource just takes the mail, but doesn´t start a full synchronisation. I wonder why the maildir resource is set to synchronize by manual trigger at all. I wonder whether the default setting to trigger on each manual check is suitable for POP3 configurations. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 319208] KMail unresponsive after POP3 retrieval and filtering with high MySQL load for minutes
https://bugs.kde.org/show_bug.cgi?id=319208 Martin Steigerwald mar...@lichtvoll.de changed: What|Removed |Added Summary|KMail unresponsive for |KMail unresponsive after |minutes after POP3 |POP3 retrieval and |retrieval and filtering |filtering with high MySQL |with high MySQL load for|load for minutes |minutes | -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 319208] KMail unresponsive after POP3 retrieval and filtering with high MySQL load for minutes
https://bugs.kde.org/show_bug.cgi?id=319208 --- Comment #1 from Martin Steigerwald mar...@lichtvoll.de --- Created attachment 79617 -- https://bugs.kde.org/attachment.cgi?id=79617action=edit atop raw file You can single step through it with atop -r atop_20130502 and using t/T keys. Only 10 minute resolution tough. I can create a larger file with higher resolution -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 319208] KMail unresponsive after POP3 retrieval and filtering with high MySQL load for minutes
https://bugs.kde.org/show_bug.cgi?id=319208 --- Comment #2 from Martin Steigerwald mar...@lichtvoll.de --- Created attachment 79618 -- https://bugs.kde.org/attachment.cgi?id=79618action=edit A sample snapshot of atop text ui with high MySQL load Also demonstrates that MySQL seems to use the innodb_buffer_pool_size=500M buffer size quickly. MySQL just had about 120 MiB mem usage before: 2459 - 4849 7 10664K 3564K 427.5M 136K 466.7M 118.8M 260K 384K 4224K martin martin 2%mysqld (all in the atop raw file I included) -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Akonadi] [Bug 319208] KMail unresponsive after POP3 retrieval and filtering with high MySQL load for minutes
https://bugs.kde.org/show_bug.cgi?id=319208 --- Comment #3 from Martin Steigerwald mar...@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 TimeCmd Query or State -- --- -- --- -- 3martin localhostakonadi 0 Execut SELECT PartTable.id, PartTable.pimItemId, PartTable.name, PartTable.data, PartTable.datasize, PartTa 30martin localhostakonadi 0 Execut SELECT PimItemTable.id, FlagTable.name FROM PimItemTable INNER JOIN PimItemFlagRelation ON ( PimItem 31 root localhost0 Query show full processlist 8martin localhostakonadi79 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 TimeCmd Query or State -- --- -- --- -- 3martin localhostakonadi 0 Execut SELECT PartTable.id, PartTable.pimItemId, PartTable.name, PartTable.data, PartTable.datasize, PartTa 30martin localhostakonadi 0 Execut SELECT PimItemTable.id, FlagTable.name FROM PimItemTable INNER JOIN PimItemFlagRelation ON ( PimItem 31 root localhost0 Query show full processlist 8martin localhostakonadi79 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 | sys3.82s | user 13.68s | #proc252 | #trun 4 | #tslpi 525 | #tslpu 0 | #zombie0 | clones 1 | | #exit 0 | CPU | sys 34% | user139% | irq 0% | idle227% | 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 | avg10.66 | avg51.00 | | avg15 0.83 | | csw 155438 | intr 27726 | | | numcpu 4 | MEM | tot 7.6G | free1.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 | tot12.0G | free 11.4G | | | | | | | vmcom 5.4G | vmlim