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

[Alexander Opitz]

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

Alexander Opitz <opi at gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |opi at gmx.at

--- Comment #3 from Alexander Opitz <opi at gmx.at> ---
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.