Hi,
I've read from the FreeBSD SMP kernel developer's list that the FreeBSD
threads implementation is not as mature as Linux is. Even then, either OS'
thread implementations are not as mature as commercially available systems.
It was suggested that Solaris be used for mysql.
--
Vibol Hou
http://khmer.cc
Noor Dawod writes:
> Hello Jan and all,
>
> I have issued a "show processlist" all the time during the time that
> mysqld is at high loads, but I didn't notice slow queries of some kind.
> Furthermore, I personally go over all queries and tables produced by our
> developers to insure proper syntax and indexing, so I am pretty positive
> there are no slow queries.
>
> The only solution to this situation is to shut down mysqld completely,
> then restart it back. The minute mysqld goes over 95% of CPU usage, it
> would never go below that. I need to manually shut it down, then start
> it again.
>
> By the way, on our development server, there are TWO mysqld processes,
> each uses different ports. They have been up and running for ages now
> without a problem. Of course, such a server doesn't get as much hits as
> the productional and much more powerful server does.
>
> Someone on the list have suggested that BSD's threading support sucks
> (does it?) and he had the same problem exactly. Only after moving to
> Debian that he saw the end of these problems...
>
> What do you suggest?
>
> Noor
>
>
> -----Original Message-----
> From: Jan Tegtmeier [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 21, 2001 4:53 PM
> To: [EMAIL PROTECTED]
> Subject: Unexplained high-loads on FreeBSD
>
>
> Hi Noor,
>
> have you tried to run a "show processlist" within mysql during these
> OVERHEAT situations to find out if there is a query forcing this high
> load? You could also activate the logfile for slow queries (starting
> mysqld with --log-slow-queries[=file_name])... maybe you will get some
> info from this without having the monitor the server by yourself all
> the time.
>
> Do you shut down mysqld to proceed or is the CPU usage going down
> after some time?
>
> Mit freundlichen Grüßen
> Jan Tegtmeier
> NetGate Internetservice
>
>
> ---------------------------------------------------------------------
> 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
>
--
Vibol Hou
http://khmer.cc
---------------------------------------------------------------------
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
