mySQL timeouts

[Anon]

Can someone give me a general idea to troubleshoot the mySQL timeout problem that I am having?

When i get the error message it states that the maximum execution time for a script has been exceded, it also gives me the line# of the hangup.

It is always the part of my code that connects to the database... I am at a loss.

Any ideas would be great.

Steve

[[deleted]]

PHP has a default maximum execution time of 30 seconds.
This means that by default, all PHP scripts will stop running after 30 seconds.
This is for server-safety, in case you accidently write something like
while (1)
{
// use large amounts of CPU
};

In your case, if the timeout happes at the database connect stage, you have probably typed the hostname of your database wrong, and PHP spends 30 seconds trying to get the IP for that name from the DNS, or the database doesn't respond within 30 seconds.

Can you access your database using the commandline mysql tools?

[Anon]

Any particular place I should be looking at? The response time is very randm, one minute it connects to the DB and is fast as lightning and then the next I get the hangup.

Would it have anything to do with a persistant connection? And if I make a persistant connection do i have to close the connection at the end of the script?

hehe.. As you can see I am fairly new to databases.. I think its time to hit Barnes and Noble and read up on it.

Any problem solving hints appreciated.

Steve

[[deleted]]

One thing you could try is putting the hostname and IP of the database server into the hosts-file ('hosts' on windows and /etc/hosts on unix)
that would cause your servert to skip the DNS lookup. That might help.

Also, check the error-logs on the database server, there may be some other problem.