OP5 Monitor - Re-enabling indexes for tables in MySQL – Support - ITRS Group

Re-enabling indexes may take a long time.

If you find tables with disabled indexes, make sure you run both a full op5-backup and schedule a maintenance window efore running the enable keys query 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.

Articles in this section

OP5 Monitor - Re-enabling indexes for tables in MySQL

Re-enabling indexes may take a long time.

Comments

Articles in this section

Re-enabling indexes may take a long time.

Related articles