Re: Server Setup Question

2008-11-15 Thread Jake Maul
I don't have any links, but in general we don't do very much as far as tuning is concerned. Here's a few things I can think of off the top of my head that we sometimes do if we're worried about performance: blockdev --setra 2048 /dev/sda (substitute an appropriate readahead amount and device name

Re: Server Setup Question

2008-11-15 Thread Jake Maul
I see that you've already decided on 64-bit anyway, but here's a more explicit reason to do so: in 32-bit (PAE-mode), no single process can allocate more than 4GB of memory- that's all the address space there is. The *system* can see it all, but each process can only work with a single 4GB chunk of

Re: Server Setup Question

2008-11-12 Thread Olaf Stein
I have no links but the best way of tuning linux is to only install what you actually need. Standard installer like to install all kinds of deamons and other programms you might not need on db server ... On 11/12/08 2:20 PM, "Shain Miley" <[EMAIL PROTECTED]> wrote: > Thanks a lot for all the in

Re: Server Setup Question

2008-11-12 Thread Shain Miley
Thanks a lot for all the infolooks like we will put the 64 bit plan into place. Does anyone know of any good links to information on tuning Linux before a MySQL install? I see that there are lot of MySQL tuning guides...but I assume there are things I can do to Linux that will help with

Re: Server Setup Question

2008-11-12 Thread Daniel P. Brown
On Wed, Nov 12, 2008 at 12:35 PM, Shain Miley <[EMAIL PROTECTED]> wrote: > Hello all, > I was wondering if anyone had any good insight into running the 32 bit and > 64 bit versions of MySQL? We are going to be using a replication setup > within my organization very shortly. We intend to a have

Re: Server Setup Question

2008-11-12 Thread Simon J Mudd
[EMAIL PROTECTED] (Shain Miley) writes: > Hello all, > I was wondering if anyone had any good insight into running the 32 > bit and 64 bit versions of MySQL? We are going to be using a > replication setup within my organization very shortly. We intend to a > have at least one master (writable)