By temporarily dropping secondary indexes from the new table before copying the data, and then recreating them later, ALTER TABLE can take advantage of the fast index creation feature even when it has to copy the entire table.
Improved InnoDB fast index creation - MySQL Performance Blog
I am nobody's puppet.
Disclaimer: My blogs are not a reflection of my employer's opinions, but are my own, and often unfiltered. Also, some links on this site may be part of an Amazon Associates program, so by clicking on them you help me pay for my independence.
[[{"type":"media","view_mode":"media_preview","fid":"25","link_text":null,"attributes":{"alt":"Acquia Certified Developer","title":"I am an Acquia Certified Developer","height":147,"width":147,"style":"width: 60px; height: 60px;","class":"media-image media-element file-media-preview"}}]] [[{"type":"media","view_mode":"media_preview","fid":"15","link_text":null,"attributes":{"height":180,"width":180,"style":"width: 60px; height: 60px;","class":"media-image media-element file-media-preview"}}]]
[[{"type":"media","view_mode":"media_original","fid":"13","link_text":null,"attributes":{"height":68,"width":310,"style":"width: 190px; height: 42px;","class":"media-image media-element file-media-original"}}]]
- Thanks again, Steve. I hope14 years 1 month ago
- Hi - bit late responding here14 years 1 month ago
- Should have added...14 years 2 months ago
- Hi Ryan,14 years 2 months ago
- Ryan,14 years 2 months ago
- It is happening and you are14 years 5 months ago
- In close future I want to14 years 8 months ago
- the article has been14 years 9 months ago
- I think it's a great coup for14 years 9 months ago
- My hardware box acts as an14 years 10 months ago
