Max Apache / PHP Concurrent Connections?
Posted: Thu Mar 15, 2007 4:45 am
Background:
I'm working on a site at the moment for quite a large client. They have a tracking system for their newsletters that picks up stuff like click throughs opens etc by replacing all links with a link to their site along with a link code on the url. The page then redirects them to the actual link via a redirect based on data from a mysql db using the link code. Pretty standard stuff I imagine. I've seen it a few times before.
Anyway, during the test phase they were sending to around 10'000 employees and everything worked fine. Since moving to live they are now sending to around 100'000 employees / clients etc and the tracking is going crazy. Hardly anything it coming through. The 100'000 gets sent out in around 3 hours, in over night batches.
One of the points put forward for investigation was this...
Is there a limit to the amount of hits that apache/php can handle in a space of time. For example if lots of people all accessed the links (via the tracking page) at the same time, would apache/php failed to handle the requests.
The website is hosted at a pretty serious datacentre, right on the UK backbone, with over 100Mbps connections to the Internet and client has unlimited use, so I don't think bandwidth is an issue
Any advice here would be great as I seem to have been dumped with the job of producing a document on why the tracking failed so miserably...
I'm working on a site at the moment for quite a large client. They have a tracking system for their newsletters that picks up stuff like click throughs opens etc by replacing all links with a link to their site along with a link code on the url. The page then redirects them to the actual link via a redirect based on data from a mysql db using the link code. Pretty standard stuff I imagine. I've seen it a few times before.
Anyway, during the test phase they were sending to around 10'000 employees and everything worked fine. Since moving to live they are now sending to around 100'000 employees / clients etc and the tracking is going crazy. Hardly anything it coming through. The 100'000 gets sent out in around 3 hours, in over night batches.
One of the points put forward for investigation was this...
Is there a limit to the amount of hits that apache/php can handle in a space of time. For example if lots of people all accessed the links (via the tracking page) at the same time, would apache/php failed to handle the requests.
The website is hosted at a pretty serious datacentre, right on the UK backbone, with over 100Mbps connections to the Internet and client has unlimited use, so I don't think bandwidth is an issue
Any advice here would be great as I seem to have been dumped with the job of producing a document on why the tracking failed so miserably...