Re: mysql optimization tips

2009-02-10 Thread Baron Schwartz
> You can read a few pages from High Performance MySQL 1st edition at > http://books.google.ca/books?id=sgMvu2uZXlsC&printsec=frontcover&dq=mysql+high+performance#PPP1,M1 > Google Books also has excerpts from other MySQL books. You can also get the Query Optimization chapter online as a PDF from h

Re: mysql optimization tips

2009-02-10 Thread mos
At 06:44 PM 2/10/2009, Michael Dykman wrote: On Tue, Feb 10, 2009 at 7:23 PM, Baron Schwartz wrote: > Hi, > > On Tue, Feb 10, 2009 at 9:25 AM, monloi perez wrote: >> Hi All, >> >> I'm not sure if this question is fine, I'm new to the list and I just have one very important question. >> Can any

Re: mysql optimization tips

2009-02-10 Thread Michael Dykman
On Tue, Feb 10, 2009 at 7:23 PM, Baron Schwartz wrote: > Hi, > > On Tue, Feb 10, 2009 at 9:25 AM, monloi perez wrote: >> Hi All, >> >> I'm not sure if this question is fine, I'm new to the list and I just have >> one very important question. >> Can anyone help me suggest the right optimization f

Re: mysql optimization tips

2009-02-10 Thread Baron Schwartz
Hi, On Tue, Feb 10, 2009 at 9:25 AM, monloi perez wrote: > Hi All, > > I'm not sure if this question is fine, I'm new to the list and I just have > one very important question. > Can anyone help me suggest the right optimization for our company's server. I suggest High Performance MySQL, Second

mysql optimization tips

2009-02-10 Thread monloi perez
Hi All, I'm not sure if this question is fine, I'm new to the list and I just have one very important question. Can anyone help me suggest the right optimization for our company's server. Our current server is a Dell PowerEdge 1900 a QuadCore with 1TB total (Raid 1) of HD space and 4G RAM. The