High Performance MySql "Optimization, Backups, Replication, and more" 2nd Edition . Got a problem, pick a chapter and read the solution. This book is awesome, I'm confident you will find what you are looking for :) .
On Thu, Mar 5, 2009 at 12:30 PM, Stephen Edberg <sbedb...@ucdavis.edu> wrote: > >> 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 >> 2 >> 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 >> huge >> difference. >> >> 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 > > http://www.mysqlperformanceblog.com/ > > 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' - > > http://oreilly.com/catalog/9780596101718/index.html > > - which I've heard good things about (don't have it myself, plan to buy). > Also see > > http://dev.mysql.com/doc/refman/5.0/en/optimization.html > > (assuming you use 5.0; substitute appropriate version if otherwise). > > - steve edberg > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=dstepli...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
