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 use an SMS gateway via TCP/IP with op5 Appliance System 6 or CentOS 6 HowTo test SMS-Modem using minicom How OP5 Monitor works in relation to grouprights? Does the name ITRS mean something Comments 0 comments Please sign in to leave a comment.