Self help FAQ ["FAQ"] How to solve when MySQL runs with very high cpu-usage (ie. 100%)? Linus January 24, 2020 14:23 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. Tags: FAQ KEDB Performance MySQL High CPU OP5 Monitor Related articles How to adjust rrdcached options to increase IO performance OP5 Monitor - License self-monitoring is reporting a warning despite having a valid license OP5 Monitor - Pollers or peers are disconnected Estimating necessary bandwidth in a Monitor cluster How to Tweak PHP and MySQL settings for OP5 Monitor Comments 0 comments Please sign in to leave a comment.