Hi Jerry,
Someone has already answered why the load stays at 1.3 to 1.5.
Sounds like one query may be slowing down the others, mytop
(/usr/ports/databases/mytop) might help identify that query also try
enabling the slow-log and track down any long queries. Have you tuned
any of the cache parameters for the large amount of memory you have?
Examples can be found in the support-files directory of MySQL. What
options were used to compile MySQL? This can affect FreeBSD, the
ports (/usr/ports/databases/mysql323-server) has excellent parameters
for building MySQL (see the make file or my previous posts on this
subject).
To answer your other question, running two daemons on the same
databases in not necessasarily a good idea. First, you will have to
have one listen on a different port and second there may be file
locking issues. However, if you install from the ports you can build
MySQL with WITH-LINUXTHREADS=yes which will use both processors, but
that may not help you if the problem is a locked table or slow query,
I have found processor usage on my 800mhz systems to be typically 12
to 25% of one processor.
Third of course is the option of purchasing a support contract from
MySQL AB. Their commercial support is excellent ( see
http://www.mysql.com/support/arrangements/types.html
or
http://www.mysql.com/support/index.html
) I recommend this if you are running a server that must be up (like
we are!).
Hope this helps,
Ken
----- Original Message -----
From: "PR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 19, 2001 2:27 AM
Subject: FreeBSD and multiple daemons
> I'm having a problem with my server getting bogged down once in a
while and
> I'm pretty sure it's due to the mysql daemon getting maxed out with
what it
> can do... when this happens there might be anywhere from 100 to 150
> processes in the processlist and it might take as much as 30 seconds
to
> return a query via a web browser. When it happens mysql is usually
using
> almost 100% cpu, but load stays around 1.3 to 1.5. I'm running
FreeBSD
> 4.3-Release and mysql 3.23.40 We recently upgraded both because of
some
> of the past comments about the sleeping threads on the list in
slightly
> older versions. The server is dual P3-1G, 1g ram with SCSI drives
on
> single channel raid card.
>
> Is there a very stable way to run multiple daemons on FreeBSD? A
howto or
> some such thing that might describe setting it up. I can run the
memory up
> to 4g on the machine if necessary to handle the extra memory
requirements.
> Also, are there changes I'll have to make to my apps that use mysql
to deal
> with this? I searched the list for multiple daemons and didn't find
much
> there, maybe I'm using the wrong keywords to search for. Any
pointers or
> help would be greatly appreciated.
>
> Jerry
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
