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-b...@kde.org
Reporter: criss...@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 watching all bug changes.
