- 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
Please sign in to leave a comment.