Brian, Sorry for the late post, I would also recommend an upgrade to
3.23.39 this did help me on FreeBSD with a similar problem (that did
not happen very often).
Also if you are compiling from source make sure you use flags similar
to this to configure:
CC=gcc CFLAGS=-O3 CXX=gcc \
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure
$DEBUG --enable-large-files --with-berkeley-db --with-innodb
bash-2.04$
----- Original Message -----
From: "Brian E. Beck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 12:44 AM
Subject: MySQL on OpenBSD 2.8
> I guess I've lurked long enough.
>
> I am a relative newbie to MySQL (and to all things SQL, actually.)
>
> I am running MySQL 3.23.37 on my OpenBSD 2.8 server. (I currently
support
> 6 different, non-related databases on the server)
>
> Here is the problem... MySQL seems to open too many threads and
die...
> (i.e., if I run "top" mysqld sems to take up over 90% of the CPU
cycles,
> for hours, if I let it.) Once it does this, I can't shut it down
with
> mysqladmin. It will not respond to anything... No queries, no
mysqladmin
> functions. Nothing. I had a friend of mine write a "monitor
script",
> which simply checks every 45 seconds to see the CPU usage of mysqld,
and if
> it is over 90% for longer than 2 minutes, it kill -9's it, and
restarts it.
> (A VERY sloppy solution)
>
> We did not have this problem when we were running MySQL 3.23.36 on
RedHat
> 7.0. ( I didn't modify the codes I use either)
>
> We have recompiled, to update the threads, etc.
>
> Can someone help me figure this out, and if so what logs do I need
to send
> to the list to help determine the problem? (Or should I upgrade to
> 3.23.39?)
>
> I appreciate all that you advise, as I have been reading this list
for a
> while now, and have gained many pearls of wisdom from it.
>
> --Brian
>
> --------------------------------------------------------------------
-
> 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
