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
Olaf
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
extra RAM?
Thanks!
-Ken
--
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
-------------------------
Olaf Stein
DBA
Battelle Center for Mathematical Medicine
Nationwide Children's Hospital, The Research Institute
700 Children's Drive
43205 Columbus, OH
phone: 1-614-355-5685
cell: 1-614-843-0432
email: olaf.stein@stripped
"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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.