mysql and system/nice cpu usage

From: Omer Faruk Sen (ofsen_at_enderunix.org)
Date: 10/31/04

  • Next message: Chuck Swiger: "Re: mysql and system/nice cpu usage" 
    To: freebsd-questions@freebsd.org
Date: Sun, 31 Oct 2004 13:45:13 +0200

    Hi,

    I have web server which uses php+mysql. As far as I have searched the best
    thing to use mysql on FreeBSD is to use linuxthreads. For the performance
    and stability I have done following things on my FreeBSD-4.X Stable system:

    Compile mysql with linuxthreads and as static binary. I have read
    http://jeremy.zawodny.com/blog/archives/000697.html. I have used mysql 4.0
    and 4.1 for my setup but had problems on both of the version.

    My problem is the mysql eats away lots of CPU time especially in "nice" and
    "system" which is really very very weird. A snapshot of the top is like
    this:

     ------------------------------
    240 processes: 7 running, 233 sleeping
    CPU states: 10.9% user, 73.9% nice, 12.5% system, 2.7% interrupt, 0.0%
    idle
    Mem: 244M Active, 1309M Inact, 309M Wired, 93M Cache, 199M Buf, 56M Free
    Swap: 3072M Total, 24K Used, 3072M Free
     -----------------------------------

    This system is HTT enabled 2 Xeon 2.8 GHZ with 2 GB RAM. I have disabled SMP
    and recompiled my kernel but my problem (nice and system cpu times..) still
    persists.

    I would appreciate if any of you help me..

    REGARDS.

     

     -----------------------
    Omer Faruk Sen
    http://www.EnderUNIX.ORG
    Software Development Team @ Turkey
    http://www.Faruk.NET
    For Public key: http://www.enderunix.org/ofsen/ofsen.asc
    ********************************************************

    First Turkish FreeBSD book is out! Go check it.
    Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti.
    http://www.acikkod.com/freebsd.php

    _______________________________________________
    freebsd-questions@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-questions
    To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"

  • Next message: Chuck Swiger: "Re: mysql and system/nice cpu usage"

    Relevant Pages

    • Re: MySQL Performance 6.0rc1
      ... Nevertheless I run a production MySQL on a double-Xeon (Supermicro ... etc) which eventually kill MySQL with FreeBSD ... CPU: AMD OpteronProcessor 246 ... <ACPI PCI bus> on pcib0 ...
      (freebsd-current)
    • What am I doing wrong with MOUNT?
      ... I'm brand new to FreeBSD and Unix world in general. ... I installed MySQL version 3.23 from the ports ... of his database that I had MySQL dump on his FreeBSD server and FTP'd it to ... I mounted the new drive 1 to a temporary mount point and used the cp command ...
      (freebsd-newbies)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... I hope this can help us out to get MySQL humming on -STABLE, ... >> To make benchmarks a help provided to improve FreeBSD, ... > This box is currently setup to slave from the master. ... > System crashed while simply slaving from the master. ...
      (freebsd-stable)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... is that the Mysql folks have agreed to setup ... >tests to profile mysql on identical hardware running FreeBSD and Linux ... I was seeing the same sort of super-smack numbers that everyone's been ...
      (freebsd-stable)
    • Re: Mysql server not able to stay running on anything but Linux?
      ... >> As you know from various threads on the FreeBSD ... >> significant issue just reproducing the problem. ... > So far we have had only one crash that seemed to have ... >> MYSQL doesn't ...
      (freebsd-questions)