List:General Discussion« Previous MessageNext Message »
From:André Bjärby Date:November 26 1999 10:30am
Subject:Re: DBI->connect failed: Too many connections
View as plain text  
Apisilp Trunganont wrote:

> Dear,
>
> I'm using FreeBSD 3.2-RELEASE with Apache 1.3.9 as web
> server.
> I use mySQL 3.22.25 with DBI and Perl DBD. My web
> server has
> heavy access to database. In the afternoon, there are
> some error
> messages in <apache>/logs/error_log like this.
>
> DBI->connect failed: Too many connections at
> /usr/local/apache/cgi-bin/cafe/readboard.cgi line 44
>
> >From readboard.cgi in line 44 :
> $cafedb =
> DBI->connect("DBI:mysql:cafe",$Cafe_DBUsr,$Cafe_DBPwd);
>
> I think that it causes from many processes try to
> connect database
> but database limits connection number.
>
> Could you please give me an advice, how to fix this
> problem?
>
> Sincerely,
> MacroArt
> __________________________________________________
> Do You Yahoo!?
> Thousands of Stores.  Millions of Products.  All in one place.
> Yahoo! Shopping: http://shopping.yahoo.com
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread19646@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

Start the server with max_connections=200 or whatever is sufficient.

Thread
DBI->connect failed: Too many connectionsApisilp Trunganont26 Nov
  • Re: DBI->connect failed: Too many connectionsMatthias Urlichs26 Nov
  • Re: DBI->connect failed: Too many connectionsAndré Bjärby26 Nov