List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:July 16 2003 9:59pm
Subject:Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?
View as plain text  
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)
Thread
MySQL, FreeBSD, LinuxThreads, and > 950 connections?Jeremy Zawodny16 Jul
  • Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?Dan Nelson16 Jul
    • Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?Jeremy Zawodny16 Jul
      • Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?Dan Nelson17 Jul
        • Re: MySQL, FreeBSD, LinuxThreads, and > 950 connections?Jeremy Zawodny17 Jul