MySQL Forums
Forum List  »  Optimizer & Parser

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Indexes are not working after restoring dump
170
September 27, 2018 11:25AM


Sorry, only registered users may post in this forum.

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.