Re: mysql and system/nice cpu usage

TM4525_at_aol.com
Date: 10/31/04

  • Next message: TM4525_at_aol.com: "Re: 5.3-RC1 - Hangs on high net load(?)" 
    Date: Sun, 31 Oct 2004 12:11:56 EST
To: ofsen@enderunix.org

    In a message dated 10/31/04 11:03:12 AM Eastern Standard Time,
    ofsen@enderunix.org writes:
    >but never come across with a problem like that. I am thinking to use Zend
    >Optimizer. Maybe that helps me ..
    >
    >If that doesn't help I was thinking to run sql on a seperate machine.

    You might try tuning kern.vm.kmem.size if thats not in the tuning suggestions.
    The OS tends to allocate way more memory than needed for the kernel if
    you have a lot of memory in the system; you probably don't need more than
    100M or so unless you're running bgp or something unusual. Once you start
    swapping with mysql and php you're dead.

    Moving to another system can help, but be aware that if your network is
    busy it can add some "different" inefficiencies. If you do go to a separate
    system connect it with a dedicated NIC if possible, to alleviate network
    backup. If you have a multiple bus machine, moving your NIC to a separate
    bus from the HDD can significantly increase performance. When you have
    the NIC and HDD on the same bus, heavy network traffic can cause disk
    operations to back up and substantially slow database applications. Make
    sure the busses are really separate (and not cascaded), otherwise it won't
    help.

    Also if you're on a 32bit bus machine you'll have a lot more contention than
    with a pci-x bus. Most people think that if you have enough bus then it
    doesnt matter, but thats dead wrong. Bus contention between devices is
    a major performance factor.
    _______________________________________________
    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: TM4525_at_aol.com: "Re: 5.3-RC1 - Hangs on high net load(?)"

    Relevant Pages

    • Re: Ping Sionnnach and others that have read James Dobson
      ... back, of course!), banks to have separate lines for women ... etc. Haredi women are throwing rocks at "immodest" ... a woman who sat next to each other on a bus in Beit Shemesh ... How this sort of fundamentalism, which it is, could possibly ...
      (rec.pets.dogs.behavior)
    • Re: Civil marriage for non-Jews in Israel
      ... want to separate can do so, ... at odds with the permitted and express purpose of the area. ... the *purpose* of the non-segregated bus was to permit ... The *purpose* of the bus was to move people from point A to point B. ...
      (soc.culture.jewish.moderated)
    • shades of the jewish taliban
      ... Following the example of "kosher" bus lines that initiated separate seating ... separate "teller for women only" at its Bnei Brak branch at the PAGI (Poale ... Agodat Yisrael) Bank. ...
      (soc.culture.israel)
    • Re: Men and Women Can Really Get Along?
      ... I mean SWan and I used to ... own space- I have my Bus, and she has a room or a little house ideally. ... separate from hers. ... It's nice to hang out when that's what we both want ...
      (alt.gathering.rainbow)
    • Re: CAN over IP
      ... > messages on the bus and performs the message syntax and CRC check. ... > the frame by violating the syntax at he end of the frame. ... Agreed - this is the typical CAN network implementation. ... due to collision" in CAN because there doesn't need to be one! ...
      (comp.arch.embedded)