Re: MySQL Performance Woody Vs Sarge
On Wed, 01 Jun 2005 18:03:28 +1200
Simon <dev@networker.co.nz> 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)
Reply to: