Using load index might help, but you'll have to make sure you allocate
plenty of space to your keycache. If the queries are identical, the query
cache might also be a good candidate, but that seems unlikely.
The memory will also be used by your OS to cache often-used parts of the
filesystem,
Which MySQL server do you use?
What is your storage engine?
-Original Message-
From: Ken D'Ambrosio [mailto:k...@jots.org]
Sent: Friday, February 05, 2010 5:26 PM
To: mysql@lists.mysql.com
Subject: Help optimizing settings?
I've got a fairly large -- 100+ GB -- MySQL database. It
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