Re: mysql and system/nice cpu usage

From: Chuck Swiger (cswiger_at_mac.com)
Date: 10/31/04

  • Next message: David Kelly: "Re: Soekris engineering "routers"" 
    Date: Sun, 31 Oct 2004 07:18:59 -0500
To: Omer Faruk Sen <ofsen@enderunix.org>

    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
_______________________________________________
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: David Kelly: "Re: Soekris engineering "routers""

    Relevant Pages

    • Re: Re: Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP
      ... read, update, add and delete records located in tables in a MySQL database ... on a Web server on the Internet directly from my desktop Access application, ... the workstation needs a secure shell client running in order to enable the ... the MySQL database on your workstation ...
      (comp.databases.ms-access)
    • Re: Auto_new VBA to autoname a document and autosave to a specific
      ... Window's Registry. ... You say that it errors when coming across the first PrivateProfileString ... When a database is on a different server from the Web server. ...
      (microsoft.public.word.vba.general)
    • Re: What is analysis?
      ... like to hear from everybody with a degree in software engineering. ... database with 20 or 30 columns. ... The management in the group that handled the customer database was business ... IT technicians had grown up in the files and records era, ...
      (comp.databases.theory)
    • Re: Re: Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP
      ... Can the Access database application be co-located with the MySQL database on ... Which Web server is being used? ... a slightly complex problem pops up, the spoon-fed developer is going to be ...
      (comp.databases.ms-access)
    • For Discussion:.....ORCL
      ... database, middleware, and application software. ... database management software, application server software, analytics, ... Software License Updates and Products Support segment provides customers ... Oracle Corporation was founded in 1977 and is headquartered in Redwood ...
      (misc.invest.stocks)