> I've been poking around google looking for tutorials and/or quick start
> guides on optimizing the mysql server. We just upgraded our DB server from
> Gb of RAM to 16. But I don't know how to reconfigure mysql to take full
> advantage of it. Although, just installing the RAM seems to have made a
> Any suggestions for a really good tutorial on configuring the server based
> on the amount of RAM, etc?
Hard to give details on performance optimization without knowing more about
the details for your load, but there are a number of cache-related
parameters (query cache, key cache and so on) that could be increased to
take optimum advantage of the additional RAM.
Take a look at
The name is pretty self-explanatory, and there's a lot of useful info there
on mysql tuning. They are the authors of 'High Performance MySQL' -
- which I've heard good things about (don't have it myself, plan to buy).
(assuming you use 5.0; substitute appropriate version if otherwise).
- steve edberg