Help optimizing settings?

[Ken D'Ambrosio]

I've got a fairly large -- 100+ GB -- MySQL database.  It isn't accessed
often -- it's acting more as an archive right now than anything else. 
That being said, when it does get accessed, the indeces seem to take
forever to load.  Being as I just bumped the RAM from 2 GB to 6 GB, what,
generically, would be the best way to go forward to take advantage of the
extra RAM?

Thanks!

-Ken


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.