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@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 the assignee for the bug.