Merlin - How to solve when MySQL runs with very high cpu-usage (ie. 100%)?

Possible solution Copied

1. Check if any tables in merlin is corrupt (and repair them if needed)

   # mysqlcheck -A --auto-repair
   

2. 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"
   

3. Observe CPU usage with top or similar utility, or through a hypervisor in virtualised environment