Re-enabling indexes may take a long time.If you find tables with disabled indexes, make sure you run both a full
op5-backupand schedule a maintenance window efore running the
enable keysquery below.
If you are experiencing very slow GUI operations or report generations, it's possible that indexes are not enabled on one or more of your tables. Run the following query:
# mysql merlin -e 'SELECT DISTINCT table_name, index_name, comment FROM information_schema.statistics;' | grep -i disable
This command should not give any results, if it does show you a table name and an indication that the index is disabled, run the following
# mysql merlin -e "ALTER TABLE report_data enable keys"
Replace "report_data" with the relevant table name.