Testing mysql

[theMAD2]

Hi

I've been having a problem with (fasthosts) mysql server lately; every now and then my database program pauses for a couple of minutes before returning a page, and when it does, it returns the page as a download (not rendered in the browser window). I guess the page is incomplete or something. I think it's the connection from php to mysql, as standard php pages load fine, it's just pages which require database interaction. This is the same across browsers/computers/internet connections.

Does anybody know of any good database stress tests, or anyway I can prove this problem to fasthosts?

Thanks

 

[theMAD2]

Anyone?

I tried making a script with a loop which connects to the database like 20 times, but I want it to run a click every 5 seconds or so. Is there anyway I can do this so the results come up in realtime? It seems the whole loop will run and then the page is returned, which is quite a wait and you can't see if it's failing as well. Maybe this would be better with some sort of AJAX solution?

 

[theMAD2]

I've been looking through the script I am running and there is no mysql_close; at the end of the index.php, could this be causing the problem? I thought as soon as the script has finished it will close the mysql connection anyway, but I've always added mysql_close; as good practice.

I've also been looking at the mysql server using the mysql server administration tool, are there any points I should be looking at here in the server health variables? There seem to be a constant aprox 30 threads connected at any one time, busy server I guess