[Akonadi] [Bug 395253] New: High cpu usage of mysql server used by akonadi / akonadiserver

[Christoph Thielecke]

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

            Bug ID: 395253
           Summary: High cpu usage of mysql server used by akonadi /
                    akonadiserver
           Product: Akonadi
           Version: 5.7.2
          Platform: Other
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: crissi99 at gmx.de
  Target Milestone: ---

Created attachment 113217
  --> https://bugs.kde.org/attachment.cgi?id=113217&action=edit
query debugger at akonadiconsole with strange queries

I noticed high cpu usage (75-80%) of mysql server used by akonadi for long time
(more then 2 hours). on Intel(R) Core(TM) i7 CPU       Q 840  @ 1.87GHz
(quadcore). The akonadiserver itself  uses 30-35% of cpu.

Something went wrong with akonadi. 

The query debugger at akonadiconsole also shows strange queries (see attaches
screenshot).


akonadiserver version: 5.7.3 (part of 17.12.3)

Here is akonadi's mysql config:
##### cat ~/.local/share/akonadi/mysql.conf | egrep -v -e ';' -e '#' -e '^$'
[mysqld]
character_set_server=utf8
collation_server=utf8_general_ci
default_storage_engine=innodb
innodb_buffer_pool_size=128M
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=1M
innodb_log_file_size=64M
log_error=mysql.err
log_warnings=2
lower_case_table_names=1
max_allowed_packet=32M
max_connections=256
query_cache_size=0
query_cache_type=0
skip_grant_tables
skip_networking
table_open_cache=200
thread_cache_size=3
wait_timeout=31536000
key_buffer_size=16K
secure_file_priv=
sql_mode=NO_ENGINE_SUBSTITUTION
innodb-read-io-threads=1
innodb-write-io-threads=1
[client]
default-character-set=utf8
##### end of mysql config #####

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