Which MySQL server do you use?
What is your storage engine?
From: Ken D'Ambrosio [mailto:ken@stripped]
Sent: Friday, February 05, 2010 5:26 PM
Subject: Help optimizing settings?
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
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql