Hi Drew, Ok, your question may be a bit more complicated. When your CPU load goes up to 90% are there many processes running? What version on FreeBSD are you on (4.3 which is pretty good?)? Becuase there were bugs in threads on the 4.2 FBSD release. There was a MySQL change relating to the problem of a runaway process chewing up CPU time on FreeBSD, even though it is not in the MySQL change log. The change came about on 3.23.37. So do you feel the 90% is a legitimate number or some sort of anonmaly? Thats why I used the word consistent, because of the bug with a runaway process, I did not want to confuse a bug with a legitimate need for more CPU power with a bug that chews up CPU randomly! This is how I compile now for FreeBSD : CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --enable-large-files --with-berkeley-db --with-innodb You have asked an excellent question. I hope you find this answer helpful, as may others who use FreeBSD (I hope!). Personally I am eager to see the new threads package that is in the works. P.S. I hope you don't mind I cc'ed the list with my reply as it was a good question and I don't think it has been put into one message this way. Ken ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 9:31 PM Subject: Re: Multiple CPU's in Freebsd > Hi Ken, > I have just read your message that you sent to Rafael re > Multiple CPU's in FreeBSD with MySQL. and I was wondering what > exactly did you mean by: > > But first I must ask if you have check how much CPU % is > > currently in use? Is consistently high? > > At current I am running FreeBSD4.1 on a machine that has 2 > CPU's and every so often the CPU% that I get from the output of > the unix command top is very high 90+ percent which in turn starts > disallowing connections. Is this what you were talking about > because I am searching for an answer to this question. Other > things I have found tended to point the finger at the version of > FreeBSD that I was using and that I should upgrade. But you > asked this question which propped up my ears that it may have > something to do with Multi CPU's. Thanks in advance for the help > you might have and that you have already given. > > Drew > > Andrew Toussaint > Richardson-Shaw Pty Ltd > [EMAIL PROTECTED] > > --------------------------------------------------------------------- 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
