Another outage today. Worse this time, as all sites on the server were inaccessible. I'm sure my few customers are very pleased they hosted with me!
I don't know exactly what was wrong. But I strongly suspect this was the same MySQL problem. Somewhere there is a script that is (or scripts that are) connecting the MySQL, but then not releasing the connection when they are done. And with enough requests this eventually results in too many connections to the database.
Probably those requests would time out eventually and everything would start working on it's own, but rebooting the server made this happen right away.
Hopefully no one was mid post when this happened.
I am going to try to get to the bottom of this. I will keep you all posted.
I'm not doing MySQL (yet), so my hands are clean! I'm thinking about ways to do the bumper sticker generator, and will probably use MySQL for persistence of submitted content -- probably just the input parameters rather than the completed gifs.
Mark, can you hurry up and become and expert in all this? I can already see that your CSS knowledge outstrips mine. It will probably only be a few weeks before your PHP knowledge does as well. Let me know when you want a .tar of all the source!
In other news, I have just discovered the 'show status' command in mysql (in command line mode.) This should help me monitor the situation and see if MySQL is actually the culprit as I suspect.
Interesting to note that since the server was rebooted an hour ago the MySQL server is averaging around 4 requests per second! Damn computers are amazing (I'm sure that's not even a high number, but it seems high to me.) Each page request from a surfer generates tens of MySQL requests, so I'm not saying apache is serving 4 pages a second - the load is much smaller than that.
|
I don't know exactly what was wrong. But I strongly suspect this was the same MySQL problem. Somewhere there is a script that is (or scripts that are) connecting the MySQL, but then not releasing the connection when they are done. And with enough requests this eventually results in too many connections to the database.
Probably those requests would time out eventually and everything would start working on it's own, but rebooting the server made this happen right away.
Hopefully no one was mid post when this happened.
I am going to try to get to the bottom of this. I will keep you all posted.
- jim 6-23-2004 9:10 pm
I'm not doing MySQL (yet), so my hands are clean! I'm thinking about ways to do the bumper sticker generator, and will probably use MySQL for persistence of submitted content -- probably just the input parameters rather than the completed gifs.
- mark 6-23-2004 9:25 pm [add a comment]
Mark, can you hurry up and become and expert in all this? I can already see that your CSS knowledge outstrips mine. It will probably only be a few weeks before your PHP knowledge does as well. Let me know when you want a .tar of all the source!
In other news, I have just discovered the 'show status' command in mysql (in command line mode.) This should help me monitor the situation and see if MySQL is actually the culprit as I suspect.
Interesting to note that since the server was rebooted an hour ago the MySQL server is averaging around 4 requests per second! Damn computers are amazing (I'm sure that's not even a high number, but it seems high to me.) Each page request from a surfer generates tens of MySQL requests, so I'm not saying apache is serving 4 pages a second - the load is much smaller than that.
- jim 6-23-2004 10:05 pm [add a comment]