Jerry,
Thats a reasonably serious hardware platform, you should not encounter 30
second delays, did you compile mysql yourself or use a pre-compiled
binary...
Sid
> -----Original Message-----
> From: PR [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, August 19, 2001 4:28 PM
> To: [EMAIL PROTECTED]
> 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
