Brian E. Beck writes:
> 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)
>
> --Brian
>
What you are getting looks like a mutex contention problem.
Make sure you build MySQL with OpenBSD native threads and not with MIT
threads.
If you use native threads, use our super-smack program to find out how
OpenBSD threads perform. If they don't perform well (compare results
with Linux 2.4 kernel), write to OpenBSD.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
