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 08:08:14 GMT
> However, it may not be a DB problem at all, and something completely
> different. It's all localhost connections, right, so it's not the
> network?

Correct. MySQL runs on the same server as httpd. And I connect using
"localhost" ...

----- Original Message -----
From: "Nathan Ollerenshaw" <nathan@valuecommerce.ne.jp>
To: <users@httpd.apache.org>
Sent: Thursday, October 02, 2003 4:02 AM
Subject: Re: [users@httpd] "Too many connections" error fix?


> On Oct 2, 2003, at 4:33 PM, URLTrak Support wrote:
>
> > PIBKAC? Maybe. I haven't had any problems until recently. My
> > membership base
> > is growing, the tracking stored in the tables is growing. I have almost
> > 900,000 rows in this tracking table. And some queries load slower than
> > others, I've noticed. Time to do some thorough bench marking.
>
> My colloquial experience with InnoDB is that it's faster than MyISAM.
>
> Don't take my word for it, however, take a dump and benchmark as you
> say.
>
> Play around with the innodb settings. A lot of performance can be
> gained for just that alone. (Same could also be said for MyISAM)
>
> However, it may not be a DB problem at all, and something completely
> different. It's all localhost connections, right, so it's not the
> network?
>
> Nathan.
>
> --
> Nathan Ollerenshaw - Unix Systems Engineer
> ValueCommerce - http://www.valuecommerce.ne.jp/
>
>
> ---------------------------------------------------------------------
> 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