On Thu, Aug 28, 2003 at 04:14:13PM -0400, Ken Menzel wrote: > Hi Nick, > This is due (so I am told) to a problem in FreeBSD threads. I have > this happen once in a while also. There have been some threads > changes for 4.9 but I am not sure there is any change in this. > > The common suggestion is to compile with LINUXTHREADS option using the > ports tree. This will solve that and give you better performance on a > multi CPU system. (cd /usr/ports/databases/mysql41-server; more > Makefile ) > or see http://jeremy.zawodny.com/blog/archives/000458.html
You can probably eliminiate (or nearly eliminate) the problem by using skip-name-resolve in my.cnf on FreeBSD. That's the root of this problem, IIRC. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 166,176,320 queries (450/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]