Self help 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. Related articles How to configure separate storage for RRD graph data How to monitor Linux and Unix servers via SNMP? How to Tweak PHP and MySQL settings for OP5 Monitor How to analyze sysload issues? Troubleshooting high runq-sz, and iops/tps values. How to test SMS-Modem using minicom? Comments 0 comments Please sign in to leave a comment.