https://bugs.kde.org/show_bug.cgi?id=384359
Bug ID: 384359 Summary: Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour Product: kmail2 Version: 5.6.0 Platform: Other OS: Linux Status: UNCONFIRMED Severity: normal Priority: NOR Component: general Assignee: kdepim-bugs@kde.org Reporter: kdeb...@customcdrom.de Target Milestone: --- Since todays update, which pulled in KDE PIM 17.08, kMail really became unusable. I'm using a normal IMAP resource with a locally running Dovecot IMAP server process. Akonadi permanently executes quries as the following: SELECT count(DISTINCT PimItemTable.id), sum(PimItemTable.size), sum(CASE WHEN ( SeenFlags.Flag_id IS NOT NULL OR IgnoredFlags.Flag_id IS NOT NULL ) THEN 1 ELSE 0 END) FROM PimItemTable LEFT JOIN PimItemFlagRelation AS SeenFlags ON ( PimItemTable.id = SeenFlags.PimItem_id AND SeenFlags.Flag_id = ? ) LEFT JOIN PimItemFlagRelation AS IgnoredFlags ON ( PimItemTable.id = IgnoredFlags.PimItem_id AND IgnoredFlags.Flag_id = ? ) INNER JOIN CollectionPimItemRelation ON ( CollectionPimItemRelation.PimItem_id = PimItemTable.id ) WHERE ( CollectionPimItemRelation.Collection_id = ? ) constantly loads the disk (Samsung 840 EVO SSD), lets the mysqld process eat 100% CPU (with the corresponding power consumption and fan noises...) and reacts very, very slowly in general. (E.g. moving messages takes several 10 minutes, opening folders often also does.) kMail/Aknoadi already had severe performance problems before, which made working with it a trial of patience (See bug 338571, bug 352604), but this is an all-new quality now... (And also a new bug, as contrary to the other ones the background activity is not directly visible/represented in the UI - except by it not being responsive.) -- You are receiving this mail because: You are the assignee for the bug.