Re: MySQL Performance Woody Vs Sarge

From: Jochen Schulz (ml_at_well-adjusted.de)
Date: 05/31/05

  • Next message: Rafael Ostertag: "Re: php and apache2 errors"
    Date: Tue, 31 May 2005 09:17:35 +0200
    To: debian-user@lists.debian.org
    
    
    

    Simon:
    >
    > The only difference i can find is that an htparm on the RAID drive:
    >
    > woody:
    >
    > Timing buffer-cache reads: 128 MB in 0.46 seconds =278.26 MB/sec
    > Timing buffered disk reads: 64 MB in 1.33 seconds = 48.12 MB/sec
    >
    > sarge:
    >
    > Timing cached reads: 196 MB in 3.38 seconds = 57.98 MB/sec
    > Timing buffered disk reads: 130 MB in 3.01 seconds = 43.22 MB/sec
    >
    > Seems to directly relate to the issue? I dont know.

    It looks like that. But the big difference here doesn't lie in the hard
    drive, but in memory and/or CPU. From the hdparm manpage:

    -T [...] This displays the speed of reading directly from the Linux
        buffer cache without disk access. This measurement is essentially
        an indication of the throughput of the processor, cache, and
        memory of the system under test.

    So you better check for correct settings of clock speed and the like.
    Look for differences in BIOS settings and check your RAM.

    J.

    -- 
    I spend money without thinking on products and clothes that I believe
    will enhance my social standing.
    [Agree]   [Disagree]
                     <http://www.slowlydownward.com/NODATA/data_enter2.html>
    
    

    -- 
    To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
    with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
    


  • Next message: Rafael Ostertag: "Re: php and apache2 errors"

    Relevant Pages

    • Re: buffer cache question
      ... Subject: Re: buffer cache question ... >> looks like you're barely using any of your high memory. ... >> NBD need to support highmem for buffering? ... >> If know right, the kernel does buffering, not NBD! ...
      (Linux-Kernel)
    • Re: Increase disk cache and buffers in 5.3?
      ... Set min as being something less than 1/2 of memory ... Luckly, when FreeBSD does get too aggressive in freeing process memory, ... softupdates code by allowing for larger true buffer cache (which is related ... actually did allow for full decoupling of the dirty buffer ...
      (comp.unix.bsd.freebsd.misc)
    • [HPADM] Followup: Ignite and Memroy Usage
      ... I have a another system that I am guessing has a lot of memory devoted to buffer cache, but I don't think that it is shrinking when more memory is need. ... the usage to Ignite. ... areas like processes, shared memory, shared libraries, memory ...
      (HP-UX-Admin)
    • Re[2]: How does disk caching work?
      ... FreeBSD has a unified buffer cache. ... >> MEMORY IS A BUFFER CACHE for all device IO. ...
      (freebsd-performance)
    • Virtual Memory
      ... It came with 128 MB memory. ... What are the correct settings for virtual memory? ... determination of the optimum settings? ...
      (microsoft.public.windowsxp.general)