Re: help configuring a db server

2010-02-11 Thread Tim Small
John G. Heim wrote: > But I'm confused about disk. I would think disk pspeed > would be fairly important. That entirely depends on your database usage pattern: What is your total dataset size? What is your working set (i.e. data which is commonly/regularly accessed)? Can you reasonably fit your

Re: help configuring a db server

2010-02-11 Thread William Warren
From: "Eric Rostetter" > To: linux-poweredge@dell.com > Sent: Wednesday, February 10, 2010 3:35:06 PM (GMT-0600) America/Chicago > Subject: Re: help configuring a db server > > Quoting "John G. Heim": > > >> to go) and mysql. We have databases for

Re: help configuring a db server

2010-02-11 Thread Paul M. Dyer
ebruary 10, 2010 3:35:06 PM (GMT-0600) America/Chicago Subject: Re: help configuring a db server Quoting "John G. Heim" : > to go) and mysql. We have databases for spamassassin bayesian rules, > drupal, moodle, imp (webmail), and our own private data. Our private data > is pretty

Re: help configuring a db server

2010-02-10 Thread Tino Schwarze
On Wed, Feb 10, 2010 at 03:35:06PM -0600, Eric Rostetter wrote: > > for under $6000. But I'm confused about disk. I would think disk pspeed > > would be fairly important. How can I configure a machine with a fast disk? > > What are my options from Dell in that regard? > > Get the fastest RAID con

Re: help configuring a db server

2010-02-10 Thread Eric Rostetter
Quoting "John G. Heim" : > to go) and mysql. We have databases for spamassassin bayesian rules, > drupal, moodle, imp (webmail), and our own private data. Our private data > is pretty small with the biggest table containing under 10,000 records. We > do have a table with about 4,00 PDF docs in a

help configuring a db server

2010-02-10 Thread John G. Heim
I hope this is not too far off topic (maybe its considered on topic [I hope]). I need help configuring a database server. We have $6000 to spend. The server will be running debian stable (maybe squeeze by the time we're ready to go) and mysql. We have databases for spamassassin bayesian rules,