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

ITRS Support

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"

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

0 comments

Please sign in to leave a comment.