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

2013-10-21 Thread Alexander Opitz 
https://bugs.kde.org/show_bug.cgi?id=317470

--- Comment #4 from Alexander Opitz  ---
A second query seems to their very often (from show processlist)

 SELECT CollectionTable.id, CollectionTable.remoteId,
CollectionTable.remoteRevision, CollectionTable

-- 
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

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

2013-10-21 Thread Alexander Opitz 
https://bugs.kde.org/show_bug.cgi?id=317470

Alexander Opitz  changed:

   What|Removed |Added

 CC||o...@gmx.at

--- Comment #3 from Alexander Opitz  ---
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*

-- 
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