Self help Troubleshooting ["Troubleshooting"] How to solve when MySQL runs with very high cpu-usage (ie. 100%)? Linus August 30, 2022 16:20 Updated Follow Possible solution Check if any tables in merlin is corrupt (and repair them if needed) # mysqlcheck -A --auto-repair Check if indexing is turned off for report_data # mysql merlin -e "show index from report_data" if disabled, enable indexing again. Note: this might take some time depending on the size of the table. # mysql merlin -e "alter table report_data enable keys"# mysql merlin -e "show index from report_data"hig observe cpu-usage either with top och through a hypervisor Done. Related articles How to adjust rrdcached options to increase IO performance How to configure OP5 Monitor with SELinux enforcing OP5 Monitor - License self-monitoring is reporting a warning despite having a valid license OP5 Monitor - Database maintenance and removing old data OP5 Monitor - Pollers or peers are disconnected Comments 0 comments Please sign in to leave a comment.