Re: best mysql optimization tutorial and/or quick start guide?

2009-03-16 Thread David M. Karr
John G. Heim wrote: - Original Message - From: "Darryle Steplight" To: "Stephen Edberg" Cc: "John G. Heim" ; Sent: Thursday, March 05, 2009 12:53 PM Subject: Re: best mysql optimization tutorial and/or quick start guide? High Performance MySql "

Re: best mysql optimization tutorial and/or quick start guide?

2009-03-16 Thread John G. Heim
- Original Message - From: "Darryle Steplight" To: "Stephen Edberg" Cc: "John G. Heim" ; Sent: Thursday, March 05, 2009 12:53 PM Subject: Re: best mysql optimization tutorial and/or quick start guide? High Performance MySql "Optimization,

Re: best mysql optimization tutorial and/or quick start guide?

2009-03-05 Thread Darryle Steplight
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 wrote: > >> I've been poking aro

RE: best mysql optimization tutorial and/or quick start guide?

2009-03-05 Thread Stephen Edberg
> 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

Re: best mysql optimization tutorial and/or quick start guide?

2009-03-05 Thread Walter Heck
Configuring and optimising a MySQL server is highly dependent on your usage of it. The most important question for you now is probably: which storage engines do you use? Based on that, you should start configuring MySQL to assign memory to optimise the usage of each as good as possible. Have fun!