Results 1 to 1 of 1
Thread: MySQL Memory Usage Tweaks
-
10-03-2006, 06:39 PM #1Junior Guru Wannabe
- Join Date
- Dec 2005
- Posts
- 37
MySQL Memory Usage Tweaks
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.