Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
From: "URLTrak Support" <urltrak@hotmail.com>
To: <users@httpd.apache.org>
References: <Law15-F16mvjkO22ZhC00004588@hotmail.com>
 <Law15-F16mvjkO22ZhC00004588@hotmail.com>
 <3.0.6.32.20031002151005.007ff4e0@mail.internode.on.net>
 <BAY2-DAV12FN03a5sqM00000e3c@hotmail.com>
 <8D4F141E-F49E-11D7-967B-000A95A07AB8@valuecommerce.ne.jp>
 <3F7BC470.E056BC70@dessent.net> <BAY2-DAV36KiMQpv9Lj00000e68@hotmail.com>
 <3F7BCBC8.F7539E00@dessent.net>
Date: Thu, 2 Oct 2003 03:00:57 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-ID: <BAY2-DAV60vIhkeTxtf00000e50@hotmail.com>
Subject: Re: [users@httpd] "Too many connections" error fix?

I didn't say anything about getting hundreds of connections. I said I have a
high traffic site and I keep getting "too many connections" error message.
This is causing the database to be inaccessible. I don't know what is
causing this. I'm trying to find out. Not much documenation on this issue
out there that I could find (from searching google).

I ran that "mysqladmin processlist" command and I got nothing that could
help me. Here's what I see after running that as root via ssh (putty):

+-------+---------+-----------+-------------+---------+------+-------+------
------------+
| Id    | User    | Host      | db          | Command | Time | State | Info
|
+-------+---------+-----------+-------------+---------+------+-------+------
------------+
| 7985  | urltrak | localhost | urltrak_com | Sleep   | 5811 |       |
|
| 8021  | urltrak | localhost | urltrak_com | Sleep   | 5764 |       |
|
| 13046 | urltrak | localhost | urltrak_com | Sleep   | 13   |       |
|
| 13060 | root    | localhost |             | Query   | 0    |       | show
processlist |
+-------+---------+-----------+-------------+---------+------+-------+------
------------+

I do not see much there to help me.

Nicole

----- Original Message -----
From: "Brian Dessent" <brian@dessent.net>
To: <users@httpd.apache.org>
Sent: Thursday, October 02, 2003 2:55 AM
Subject: Re: [users@httpd] "Too many connections" error fix?


> URLTrak Support wrote:
> >
> > Thanks. I will have to do some thorough researching before making any
major
> > changes. The site is too high traffic to take chances at this point. I
need
> > certainties before taking actions.
> >
> > So do you think that by modifying the my.cnf to reflect higher
connections
> > allowed will help? It helped for a while, at 500 connections. I just
bumped
> > it up to 600 tonight. I will have to wait to see if this helps.
> >
> > Any suggestion on a good number in httpd.conf for MaxClients or some
other
> > var? Someone said that I should have a higher max_connections number
than
> > the one defined in the httpd.conf for MaxClients.
>
> I don't understand where all these connections are going?  There should
> be, at most, one MySQL connection per Apache worker process, which you
> said was set to a maximum of 150 (MaxClients).  If persistent
> connections are enabled then each worker will create a connection and
> then keep it open until that process ends.  How in the world are you
> getting all these hundreds of connections then?  I agree with the person
> that said to run the "SHOW PROCESSLIST" command, that will show you
> exactly what's going on.
>
> Brian
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>    "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org