MySQL Performance Woody Vs Sarge

From: Simon (dev_at_networker.co.nz)
Date: 05/31/05

  • Next message: Karsten M. Self: "Re: Slow Firefox performance on P4 1.7 GHz 1 GB system" 
    Date: Tue, 31 May 2005 12:39:25 +1200
To: debian-user@lists.debian.org

    Hi There, I have a strange issue with mysql performance... We are
    running sarge on our production web server and woody on our dev
    server... MySQL is the only issue we have:

    Both servers are running MySQL 4.0.24, one Debian_4 (woody) and one
    Debian_5 (sarge)... Both my.cnf files are pretty much the same, both
    servers are 1.5Mhz single processor AMD with 512MB RAM, both running
    software RAID 1 (2 disks) where the mysql data is stored....

    We have a database with about 900,000 records in it... serial numbers
    for products... Looking up the woody box:

    select * from serial_numbers where serial_number is 'XXXXXXXXXXXXXX';

    works (pretty much) instantly, where as the sarge box takes about 3 seconds.

    How do i start figuing out this issue?

    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.

    Thanks,

    Simon 

    -- 
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: Karsten M. Self: "Re: Slow Firefox performance on P4 1.7 GHz 1 GB system"

    Relevant Pages

    • Re: apt-get install from testing got me into trouble with perl and libpng
      ... >>Running with a mixture of woody and sarge is always ... server, ...
      (Debian-User)
    • Re: postfix vs. exim, mailscanner vs. amavis, clamav, IMAP server thoughts?
      ... >I have a server i'm planning to bring online ASAP. ... but simply with the woody versions of them. ... and both postfix and ClamAV are supported by ... At this time I'd be installing Sarge. ...
      (Debian-User)
    • Re: Couple Questions Before I install for first time.
      ... On, Jason Skala wrote: ... > A couple of you replied saying Sarge is the way to go and not Woody? ... > Is sarge stable and secure enough for a live server? ...
      (Debian-User)
    • Re: sarge?
      ... > servers are still using Woody, but most end-users who have a clue have ... > into sarge last week - just a couple of months after it was released) ... And it is IMPOSSIBLE to use Woody on a new server ... If you suggest using Sarge on a server, I point out that it doesn't ...
      (Debian-User)
    • Re: woody to sarge?
      ... > What would be the proper way of upgrading a Debian system (2.4 kernel, ... > sendmail, apache, mysql) from Woody to Sarge? ...
      (Debian-User)