Change to MZ
Saturday September 11th, 1999
I've made a change to MozillaZine's back-end that will be a great benefit if any MySQL problems crop up. In the past, when you visited the front page, I used PHP to dynamically grab the count of responses per article - a task that required connecting to the database. Now, the page is static, and it is regenerated every time someone adds a comment in the forums. This means that I was able to do away with all the dynamic code on the front page, without any sacrifice.
Now, if MySQL problems crop up, they'll affect the subpages which require dynamic content from the database (forums, polls), but the front page will still be reachable.
There may be some bugs that I haven't found yet, so let me know if you find any.
Thanks to Ben Goodger for his advice, which allowed me to accomplish this task in a sensible way.
#7 "mysql problems"
Sunday September 12th, 1999 11:58 AM
You are replying to this message
I will bet good money that your problem was an administration problem and not a mysql problem.
I use php and mysql on a number of heavy loaded servers and have never had either program crash. In fact i have never had any problems at all with these programs.
I have in the past shutdown mysql incorrectly and had to remove it's pid which usually resides in /tmp in order to get it to start. But that was an administration blunder on my part.