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.
-
Tags:
- FAQ
- KEDB
- Performance
- MySQL
- High CPU
- OP5 Monitor
Comments
0 comments
Please sign in to leave a comment.