I'm creating a index on a table with about a hundred million records and it is taking a while. I'm hoping I can speed things up by increasing the memory available to MySQL. Looking at top I see that MySQL uses at most 80mb, I guess that must be the cap it gets set to by default.
Anyone have any suggestions on how to tweak MySQL memory usage settings for best performance? I have 2 GB that I can let MySQL eat up.