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@kde.org
Reporter: fmet...@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.
_______________________________________________
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs
