Hi Jerry,
The load figure on a machine is the average number of processes needing
to use the CPU on the machine. Since all of the MySQL activity is in
threads under a single process, it only counts as one towards the load
average, so a load of 1.3-1.5 with a maxed out CPU is valid. (Yes, I
know this doesn't help with your problem, but it explpains the load
figure)
What are the mysql processes doing in the processlist when you list it?
If a large number are all writing to the same table, then locking/index
update conflicts could be slowing the system down.
Make sure you've got enough RAM allocated to disk cache to get all of
your database tables into memory. If I remember correctly, FreeBSD
is hard-coded to use 10% of the RAM as disk cache. So if your database
size is greater than 100Mb and your queries are trying to access ALL of
the tables, then you'll have a great deal of slow disk I/O going on.
There's an OS command to up the size of the disk cache, but I don't
remember it off the top of my head. It's the kind of thing that I have
to use once when wetting up a machine and then forget until I set up the
next one.
Hope that helps,
Rene
PR wrote:
> 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.
--
Rene Churchill http://www.vtwebwizard.com
Internet Consulting 802-244-5151
Specializing in Web Programming
---------------------------------------------------------------------
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
