Indexes are not working after restoring dump
Posted by:
Amit K
Date: September 27, 2018 11:25AM
I had situation where DB was deleted accidently and have to restore using the mysql dump that I took previous day.
After the restoration the application performance seem to be slow and queries are taking longer than usual.
I do see the indexes defined, but they are not applied while executing queries.
Then I tried to run explain on the queries and I found
Possible_keys / Key / key_len/ ref are null and its scanning all the rows in the tables with where condition.
I tired repair table but it doesn't seem to help.
Did anyone face similar issue, please help me to fix this.
Thanks in advance
Amit
Subject
Views
Written By
Posted
Indexes are not working after restoring dump
1500
September 27, 2018 11:25AM
872
September 27, 2018 01:39PM
689
September 27, 2018 01:45PM
736
September 28, 2018 12:21AM
690
September 27, 2018 07:14PM
641
September 27, 2018 08:31PM
641
September 28, 2018 11:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.