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 - 'man blockdev') mount the MySQL data partition with 'noatime' consider playing with different schedulers ... the stock one works fairly well, but some people prefer 'deadline' Hmm... can't think of anything else right now. We spent more effort tuning MySQL itself than the underlying system. Linux has lots of knobs if you go looking, but (at least for us) you generally don't need to mess with them. We run CentOS mostly, for the record... Jake On Wed, Nov 12, 2008 at 12:20 PM, Shain Miley <[EMAIL PROTECTED]> wrote: > Thanks a lot for all the info....looks 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 performance as > well... > > Thanks, > > Shain > > > Daniel P. Brown wrote: >> >> 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 at least one >>> master (writable) DB and several (let's say 3 for this excersise ) >>> read-only >>> DB's. >>> >> >> [snip!] >> >>> >>> Would I need to run the 64 bit version on all the servers or just the >>> master, etc? Any help would be great. >>> >> >> I would highly recommend running the 64-bit version on all systems >> if it's feasible from an infrastructure standpoint. One of my >> customers has a cluster that I manage where the RAM ranges from >> 16-24GB per machine, and I have 64-bit setups on each. They use >> replication as well, for the record. >> >> There may be some issues with read/write/seek times on a 32-bit >> machine as opposed to a 64-bit. The 32-bit may seem to lag, which can >> cause issues with replication under heavy loads. And, of course, >> filesizes and memory barriers do exist (and are being rather >> easily-reached now). However, if you're strictly asking about how it >> interfaces from one MySQL server to the next, it's no problem. MySQL >> couldn't care less if it's compiled for i586 or x86_64; that's only in >> how it relates to the OS on which it's installed, not how it interacts >> with sibling systems. >> >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
