In general you need to adjust your server settings to actually use the new RAM.
This depends on various things, storage engines used, what else runs on the box, etc.
In addition you should look at your schema, see if you have the right indices for what
you want to do.
E.g. All columns that you use in joins as well as all columns you use with where, order
and group should be indexed
On 2/5/10 9:26 AM, "Ken D'Ambrosio" <ken@stripped> wrote:
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
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Battelle Center for Mathematical Medicine
Nationwide Children's Hospital, The Research Institute
700 Children's Drive
43205 Columbus, OH
"I consider that the golden rule requires that if I like a program I must share it with
other people who like it."
Richard M. Stallman