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.
Created attachment 78452 [details] gdb output (give by thread apply all bt) Output log of gdb (give by « thread apply all bt ») when akonadiserver and mysqld take lot of CPU (for long time ... Very long time)
I want to add a thing : This bug appear when I launch kmail
I can confirm this behavior while using KMail. The query: "SELECT MimeTypeTable.id, MimeTypeTable.name FROM MimeTypeTable INNER JOIN CollectionMimeTypeRelation" seems to be the most one which is running. mysql> \s -------------- mysql Ver 14.14 Distrib 5.5.32, for debian-linux-gnu (x86_64) using readline 6.2 Connection id: 30 Current database: akonadi Current user: opi@ SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.5.32-0ubuntu7 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /tmp/akonadi-opi.vFIsdl/mysql.socket Uptime: 2 hours 36 min 26 sec Threads: 28 Questions: 30927431 Slow queries: 0 Opens: 174 Flush tables: 1 Open tables: 48 Queries per second avg: 3295.059 -------------- Around 3300 queries per second. *wow*
A second query seems to their very often (from show processlist) SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.remoteRevision, CollectionTable
Could you start Akonadi Console, enable "Job Tracker" and make a screenshot of running jobs (there should be only one, but can have subjobs) once Akonadi/MySQL starts going nuts? From the backtrace (and the SQL query) it's clear that Akonadi is being asked for list of collections very often. I suspect an issue I've seen lately myself, but need confirmation.
(In reply to comment #2) > I want to add a thing : This bug appear when I launch kmail I just noticed this comment: when you open Akonadi Console and in Browser tab check "Local Folders", are there any duplicated collections?
Created attachment 83519 [details] list of job from akonadiconsole list of job from akonadiconsole
I send a screenshot from akonadiconsole jobtracker. These jobs appear in less than a half second. I use package from archlinux repos and akonadiserver consume lof of cpu since 4.11.3 update.
Open Akonadi Console, go to Browser tab, and check whether there are any duplicated folders in "Local Folders" folder - if yes, delete the duplicated folders and it should stop.
(In reply to comment #9) > Open Akonadi Console, go to Browser tab, and check whether there are any > duplicated folders in "Local Folders" folder - if yes, delete the duplicated > folders and it should stop. I had two trash folder, I delete one of them and now it works fine. Thank you.