[Akonadi] [Bug 317470] New: mysqld take lot of CPU usage when Akonadi is enabled (4.10.41)

[Aristide]

https://bugs.kde.org/show_bug.cgi?id=317470

            Bug ID: 317470
           Summary: mysqld take lot of CPU usage when Akonadi is enabled
                    (4.10.41)
    Classification: Unclassified
           Product: Akonadi
           Version: unspecified
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: general
          Assignee: kdepim-bugs at kde.org
          Reporter: fmetton at gmail.com

Hi ! I have a big problem with Akonadi, since update from KDE 4.10.40 to
4.10.41.

When Akonadi is enabled, mysqld is used with 25% of CPU. After many audits for
mysql, I have this values

→ Akonadi appear 35 times in « processlist » in : mysqladmin -u root -p
processlist
→ Same command but with status, give : « Uptime: 6049  Threads: 36  Questions:
10240323  Slow queries: 0  Opens: 321  Flush tables: 1  Open tables: 64 
Queries per second avg: 1692.895 »  ... 1692.895 Querys per seconds ... 
→ Akonadi like to run : « SELECT MimeTypeTable.id, MimeTypeTable.name FROM
MimeTypeTable INNER JOIN CollectionMimeTypeRelation ».

Ask me if you need more informations, what do you want and more :)




Reproducible: Always




I use External mysql database for Akonadi (with dbs_akonadi for database name,
and akonadidb for username, in localhost.

-- 
You are receiving this mail because:
You are the assignee for the bug.