MySQL performance drop with FC2 kernels

From: N T (fc.list_at_gmail.com)
Date: 11/30/04

  • Next message: Paul Bradshaw: "Re: change cyrus-imapd ssl certificate FC3" 
    Date: Tue, 30 Nov 2004 16:40:12 -0500
To: fedora-list@redhat.com

    I am seeing that performance using MySQL 4.1.7 drops by a significant
    amount if I use a FC2 kernel (2.6.8-1.521smp or 2.6.9-1.6_FC2smp)
    compared to running a stock 2.6.9 kernel downloaded from kernel.org.
    The vanilla kernel was compiled using the i686-smp config that FC2
    used. I see similar issues when running MySQL 4.0.xx. All MySQL
    versions were installed from the RPMs available from
    <http://www.mysql.com>.

    The benchmark being used to measure performance was RUBiS
    <http://rubis.objectweb.org/>. While vanilla 2.6.9 can service ~220
    reqs/s, FC2's version of 2.6.9 can only deliver ~120 reqs/sec.

    I have a Dell Poweredge with a hyperthreaded Pentium IV. However, I am
    not sure what other information might be relevant to narrow this
    problem. There was a thread on FedoraForum.org
    <http://www.fedoraforum.org/forum/archive/index.php/t-20064.html>
    about a similar problem but I did not see any resolution there.

    Any ideas?

    Thanks,
    Niraj 

    -- 
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
  • Next message: Paul Bradshaw: "Re: change cyrus-imapd ssl certificate FC3"

    Relevant Pages

    • RE: MySQL Performance Woody Vs Sarge
      ... The 2.4 Kernel on Sarge for the packaged MySQL was much faster, ... # hdparm /dev/md0 ...
      (Debian-User)
    • Unusual swap usage...Is this bug #89226?
      ... I'm running RH 7.3 with the latest kernel update. ... machine is a MySQL server that gets most of its activity overnight during ... tuning the MySQL memory usage, but that doesn't affect the swap usage. ... references updating -rmap to correct this problem, but the bug is not ...
      (RedHat)
    • Re: [OT] Server for Debian + MySQL
      ... On a 32bit machine, you can use a PAE enabled kernel to allow the operating system to address all the memory, but you're still stuck with a 4GB per-process limit, which means if this will be a dedicated MySQL server, you're wasting 12GB of memory. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". ...
      (Debian-User)
    • Re: mdconfig unable to allocate memory
      ... >>So, in short, is there any rule of thumb to follow when tweaking these ... Since that was just resuling in kernel panics pretty much ... This machine is for MySQL, and there's a wild un-backed-up claim on ... I think I'm just missing the point of having a swap backed memory ...
      (freebsd-current)
    • Re: FreeBSD and MySQL - mysqld eats CPU alive
      ... > long-standing issue betweeen FreeBSD and MySQL. ... Very heavily loaded machine, 15 GB database, over 300 ... One thing it might have been - did you change the HZ value in your kernel ... conf file, perhaps for device polling? ...
      (freebsd-questions)