Created attachment 113217 [details] 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 #####
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version? If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please mark the bug as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!
This bug has been in NEEDSINFO status with no change for at least 30 days. The bug is now closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging Thank you for helping us make KDE software even better for everyone!