Windoze PHP server having issues....really slow and more
Posted: Fri Feb 18, 2005 6:32 pm
I have just reconfigured two machines (one mysql db, one php web server) here to run my LMS application.
I first noticed problems with it running really slowly in phpMyAdmin (first with phpMyAdmin on the web server, then with phpMyAdmin on the db server).
Thing is, it runs fine sometimes, (when I call some pages) and really slowly on others. It's like it will work beautifully for 10 page calls in a row, and then choke down and take 2 minutes to load the next (for no particular page order or reason).
I have been living with that and that's ok. My real problem surfaced today when the LMS application started having problems. A user created a new course and then submitted a new lesson in the course and it went to a "page can not be displayed" error. When she hit back and refreshed the form page, it shows that the lesson had been inserted to the db about 30 times...which tells me that it is processing it (muliple times) and might even be getting caught in some kind of loop which is making it throw the page not displayed error.
The second issue may not have ANYTHING to do with the first, but since I've had those two issues I thought they might be somewhat related. I KNOW it's not a coding issue on the LMS because it works great (most of the time), but every once in a while, we have this problem.
I have chatted with Feyd about the way I have the db server set up (the machine that I think is the problem given that when I have phpMyAdmin directly on that machine, it's still really slow) and we can't seem nail down any issues that could be driving this. I mentioned to him that I did the same install that I've done for every other mySQL install with the exception that I set it up for 500+ concurrent connections...could that be killing this? Why would it be looping the insert statement?
I'm at a total loss here.
please help if you have any ideas or suggestions.
thx,
Burr
I first noticed problems with it running really slowly in phpMyAdmin (first with phpMyAdmin on the web server, then with phpMyAdmin on the db server).
Thing is, it runs fine sometimes, (when I call some pages) and really slowly on others. It's like it will work beautifully for 10 page calls in a row, and then choke down and take 2 minutes to load the next (for no particular page order or reason).
I have been living with that and that's ok. My real problem surfaced today when the LMS application started having problems. A user created a new course and then submitted a new lesson in the course and it went to a "page can not be displayed" error. When she hit back and refreshed the form page, it shows that the lesson had been inserted to the db about 30 times...which tells me that it is processing it (muliple times) and might even be getting caught in some kind of loop which is making it throw the page not displayed error.
The second issue may not have ANYTHING to do with the first, but since I've had those two issues I thought they might be somewhat related. I KNOW it's not a coding issue on the LMS because it works great (most of the time), but every once in a while, we have this problem.
I have chatted with Feyd about the way I have the db server set up (the machine that I think is the problem given that when I have phpMyAdmin directly on that machine, it's still really slow) and we can't seem nail down any issues that could be driving this. I mentioned to him that I did the same install that I've done for every other mySQL install with the exception that I set it up for 500+ concurrent connections...could that be killing this? Why would it be looping the insert statement?
I'm at a total loss here.
please help if you have any ideas or suggestions.
thx,
Burr