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
