my.cnf: Improve speed of adding new columns and indexes in large MySQL tables
- by Dan
I have a large table ( 10 million rows) which I am adding new columns and indexes to.
This is taking progressively longer and longer to complete.
I have a powerful server with 16GB of memory available.
What are the best settings in my.cnf to increase in order to speed this process up?