3 ms·
One of our MySQL instances somehow ended up with two copies of the same index, and any query that tried to use them ended up being a lot slower than it should h
by Izkata 5y ago
One of our MySQL instances somehow ended up with two copies of the same index, and any query that tried to use them ended up being a lot slower than it should have been. Dropping the copy restored it to normal speed.
- giancarlostoro 5y agoWow, I don't even know how to pull that off. I would of thought it wouldn't let you do that!
- setr 5y agoAt least in postgres, you don’t need to provide a name, in which case it seems to do no dedup check on the create index. Quite annoying if you’re doing changes ad-hoc