Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?

[Jeremy Zawodny]

On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote:
> In the last episode (Jul 16), Jeremy Zawodny said:
> > Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x
> > and handling more than 950 connections?
> > 
> > If so, did you need to do anything special to make it work?  I'm
> > seeing this:
> > 
> > Can't create a new thread (errno 35). If you are not out of available
> > memory, you can consult the manual for a possible OS-dependent bug
> 
> I don't suppose you're hitting a maxproc resource limit?  Check "limits
> -a" and "sysctl -a | grep maxproc".

Does't seem that way, no.

bash-2.05b# limits -a
Resource limits (current):
  cputime          infinity secs
  filesize         infinity kb
  datasize          1048576 kb
  stacksize           65536 kb
  coredumpsize     infinity kb
  memoryuse        infinity kb
  memorylocked     infinity kb
  maxprocesses         3686
  openfiles           14745
  sbsize           infinity bytes
  vmemoryuse       infinity kb

bash-2.05b# sysctl -a | grep maxproc   
kern.maxproc: 4096
kern.maxprocperuid: 3686

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 6 days, processed 211,735,955 queries (355/sec. avg)