MySQL index building performance
- by Christian
I tried to build an index over a two columns of a 30,000,000 entry database.
I canceled the process after ~60hr as it didn't seem to work.
For some reason MySQL takes only 22 mb ram instead of using the RAM fully.
Is index building an operation that needs no Ram or is there some way to tell MySQL to use more RAM to be faster?