[kmail2] [Bug 384359] New: Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Gunter Ohrner]

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 at kde.org
          Reporter: kdebugs at 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.