Self help

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

January 24, 2020 14:23
Updated

Possible solution

Check if any tables in merlin is corrupt (and repair them if needed)
1. ```
# 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.

Comments

0 comments

Please sign in to leave a comment.