Here is one Chuck...
Tonight our site crashed due to the max number of SQL connections being met.
Now.. there were issues with the server configuration, which we have fixed.. and that isn't the issue I'm posting about. The issue is the WHAT that caused us to realize that we need to rethink our configuration.
One of our users was using a download accelerator called Megaupload while browsing the gallery. Here is what we got from tech support.
It looks like the user causing the mess before was using the gallery and an upload application called megaupload. They had over 50 connections to the mysql server (as it takes 60 seconds to timeout a connection) your connection count got full.... |
It appears the user was just using a mass downloading or uploading tool to automate browsing. Somewhere along the lines of 20-50 pictures a minute. If each TCP connection takes 60 seconds to time out, and the max was set at 100 it would only take that one user 3-5 minutes to hog up most of the connections.
So my question is this.. is there a way to block individuals from going through our gallery with these types of programs?