Re: Indexs after table name changed
Posted by: Peter Brawley
Date: June 28, 2016 05:08PM

> The named table is not using/showing the indexes associated with it.

Show Create Table for the table no longer includes the index specs that were there before, and so far as you know, your own users or code did not drop them?

I've never seen MySQL drop indexes on its own. It would be a very serious unreliability, if it were to happen.

That it's not been reported strongly suggests it didn't happen to you either. Much more likely: some code, or some user, or sql injection is responsible.

If it happens again, turn on the general log so you can trace where the rogue command comes from.

Options: ReplyQuote

Written By
Re: Indexs after table name changed
June 28, 2016 05:08PM

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.