On Wed, 01 Jun 2005 18:03:28 +1200 Simon <[EMAIL PROTECTED]> wrote: > Jacob S wrote: > [snip] > > Jacob - Nearly Right: > > woody(dev) = faster (Linux version 2.4.18-bf2.4): > > # hdparm /dev/md0 > /dev/md0: > BLKROGET failed: Invalid argument > geometry = 23632/2/4, sectors = 80405120, start = 0 > > The above raid consists of: > > # hdparm /dev/hde > > /dev/hde: > multcount = 0 (off) > I/O support = 0 (default 16-bit) > unmaskirq = 0 (off) > using_dma = 1 (on) > keepsettings = 0 (off) > nowerr = 0 (off) > readonly = 0 (off) > readahead = 8 (on) > geometry = 5005/255/63, sectors = 80418240, start = 0 > busstate = 1 (on) > > # hdparm /dev/hdg > > /dev/hdg: > multcount = 0 (off) > I/O support = 0 (default 16-bit) > unmaskirq = 0 (off) > using_dma = 1 (on) > keepsettings = 0 (off) > nowerr = 0 (off) > readonly = 0 (off) > readahead = 8 (on) > geometry = 79780/16/63, sectors = 80418240, start = 0 > busstate = 1 (on) > > > sarge(production) = slower (Linux version 2.6.8-2-k7): > > # hdparm /dev/md0 > /dev/md0: > readonly = 0 (off) > readahead = 256 (on) > geometry = 25248/2/4, sectors = 80418048, start = 0 > > The above raid consists of: > > # hdparm /dev/hde > > /dev/hde: > multcount = 0 (off) > IO_support = 0 (default 16-bit) > unmaskirq = 0 (off) > using_dma = 1 (on) > keepsettings = 0 (off) > readonly = 0 (off) > readahead = 256 (on) > geometry = 65535/16/63, sectors = 80418240, start = 0 > > # hdparm /dev/hdg > > /dev/hdg: > multcount = 0 (off) > IO_support = 0 (default 16-bit) > unmaskirq = 0 (off) > using_dma = 1 (on) > keepsettings = 0 (off) > readonly = 0 (off) > readahead = 256 (on) > geometry = 65535/16/63, sectors = 80418240, start = 0
The readahead on the Woody box is 8, it is 256 on the sarge box. That's one difference. Are both boxes only MySQL servers, and are you *sure* that the Sarge box is quiescent when you run the test? > Both my.cnf files are pretty much the same> How different are they? -- ----------------------------------------------------------------- Ron Johnson, Jr. Jefferson, LA USA PGP Key ID 8834C06B I prefer encrypted mail. "Today, it is not only that our kings do not know mathematics, but our philosophers do not know mathematics." Julius Robert Oppenheimer (1904-1967) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
