MySQL slowdown???

Anon

Hi,

I have a website, http://cyber-nhl.net, that has a file server that runs off of MySQL and PHP.

Now the database is 300K large and sometimes when I call it through PHP or anything for that matter it won't connect or I can't access it. My browser just sits there.

Any Help?

Thanks!

brandonschnell

the web server is pingable & responds on port 80. however, if you telnet to port 80 and request a page it seems to stop responding after:

                                                        <tr>

thats the last i see sent by the web server. since the entire page isn't sent IE hangs waiting for the last parts of the file. eventual IE times out and the page loads.

either the intial file is damaged (run fsck) or the web server has problems (restart apache/reboot the computer)

as i was writing this the site now seems to respond and close the connection properly after i telnet to port 80 and request a file.

brandonschnell

if that portion of the script does have some php/db functions, consider simplifying the script until the problem goes away. troubleshoot the problem down to one line of code and fix that.

Anon

Sometimes it works sometimes it doesn't. Any ideas other than working the script down line by line?

Thanks for your help

brandonschnell

nope. you're actually going to have to troubleshoot this (unless you get lucky). while this may have nothing to do with your script, you're going to need to prove thats the case.

since it seems to hang in the same place (at least for me) then find what code creates the html where it hangs and see what the code does. this should give you an idea of what is failing where.

Anon

Thanks for your help Brandon. Looks like I've got it working now.