httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "URLTrak Support" <urlt...@hotmail.com>
Subject Re: [users@httpd] "Too many connections" error fix?
Date Thu, 02 Oct 2003 06:34:43 GMT
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.

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


> Nathan Ollerenshaw wrote:
>
> > If you see a lot of SELECT all taking a long time to complete, you will
> > probably find that any INSERT or UPDATEs going on are locking the whole
> > table and stopping the SELECTs from completing (I'm sure there is a
> > better explanation but I'm not a real DBA).
>
> Not true:
>
> <http://www.mysql.com/doc/en/Table_locking.html>
>
> "In MySQL Version 3.23.7 and above, you can insert rows into MyISAM
> tables at the same time other threads are reading from the table. Note
> that currently this only works if there are no holes after deleted rows
> in the table at the time the insert is made. When all holes has been
> filled with new data, concurrent inserts will automatically be enabled
> again."
>
> 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


Mime
View raw message