Will php autoreconnect to MySQL?

Question

$con = mysql_connect("localhost:".$LOCAL_DB_PORT, $LOCAL_DB_USER, $LOCAL_DB_PASS);
mysql_select_db("hr", $con);
mysql_query("set names utf8", $con);

while(true)
{
    do_stuff($con);
    sleep(50);
}

If connection timesout in 50 seconds,will $con still work?

Answer 1

If the connection times out, it won't work.

To answer the question from the comment, to cope with the problem, refer to php.net manual page for mysql_connect() which says:

If a second call is made to mysql_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned.

so if you want to make sure you always have an open connection, just try to open a new one with the same arguments after the code you substituted with sleep() is done executing.

Answer 2

Simple answer: why don't you try it and see?

I believe codeburger is correct: if the MySQL connection times out, then it's gone. You could use a persistent connection with mysql_pconnect. You will need to call that function after sleep each time but it will use an existing connection, saving overhead.