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" <k...@jots.org> 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=olaf.st...@nationwidechildrens.org ------------------------- 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.st...@nationwidechildrens.org "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
