mySQL/InnoDB defragging
mySQL/InnoDB defragging
Out of context: Reply #1
- Started
- Last post
- 5 Responses
- nospacebar0
It's the index that needs updating after you modify the db a lot.
It should update the index after modification, so I only optimize + analyze if I know there's been a lot of transactions that heavily modified the data.