Re: mysql and system/nice cpu usage

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

  • Next message: Gerard Samuel: "Determining original FBSD version" 
    To: Chuck Swiger <cswiger@mac.com>
Date: Sun, 31 Oct 2004 18:01:48 +0200

    Everything that is stated in tuning man page was done. What is interesting
    that this site was running more than 8 months without problem. But a few
    weeks ago system was started to behave like that.

    By the way isn't it interesting that mysql creates load on system and nice?
    I think mysql should create load on "user". That is why I have send this
    problem to FreeBSD mailing list. I am using FreeBSD for more that 4 years
    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.

    Chuck Swiger writes:

    > Omer Faruk Sen wrote:
    >> 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. [ ... ]
    >> 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
    >
    > Well, you've managed to saturate the available CPU power with the
    > workload. If you've already done some performance tuning at the FreeBSD
    > level by adjusting your kernel config and followed "man tuning", you
    > aren't likely to get much further by tweaking FreeBSD's config.
    >
    > Look into optimizing your database utilization by checking the SQL query
    > histogram, particularly if your site ends up doing transaction(s) for each
    > HTTP hit. People write books on database management and tuning, and you
    > should look there rather than to a FreeBSD list for advice. :-)
    >
    > You could also get another machine and run the database and webserver on
    > seperate systems to help site performance by dividing and concentrating
    > the workload. Consider switching from MySQL to postgres or a database you
    > actually pay for: Oracle, Sybase, Frontbase, etc.
    >
    > You could also consider another web middleware/scripting evironment than
    > PHP which handles database interactions more efficiently: Zope, JSP,
    > WebObjects.
    >
    > --
    > -Chuck
    >
     

     -----------------------
    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: Gerard Samuel: "Determining original FBSD version"

    Relevant Pages

    • 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: What am I doing wrong with MOUNT?
      ... > I'm brand new to FreeBSD and Unix world in general. ... > site supported by FreeBSD that uses MySQL. ... > 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-questions)
    • Re: [PHP] Problems connecting to mysql
      ... I have host as '%' in the user table in the mysql database. ... *should* be possible to connect from a linux to bsd box and vice versa. ... And what about the logs of your MySQL server on the FreeBSD box? ...
      (php.general)
    • 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-questions)
    • Re: Best Search App
      ... There isn't much in terms of tuning that can be ... Fulltext in MySQL is too slow once you get a db ... I played around with Zend's version of Lucene, ... You aren't going to get much better than a database. ...
      (comp.lang.php)