PHP MySQL Set Connection Timeout

PHP MySQL set Connection Timeout

The connect_timeout parameter is only valid at connection time. It's useful to check if your DB server is reachable in 20 seconds or so. Once connected the specified timeout is no longer valid.

I don't find any query timeout parameter on official mysql manual page: http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html so I don't think this is possibile.

Mysql connection timeout issue

Finally it works me after doing mysqli_reconnect and given indexing to particular fields.

PHP can't connect to MySQL Database (timeout)

I guess you're running your php code on your own machine and MySQL on a hosting service.

Many hosting services simply don't allow connections to MySQl from outside their private networks. Because cybercreeps. If that's your situation you need a different hosting service.

Others require some special configuration setting. It sometimes appears on cpanel as something like "Remote database access". Ask their tech support. And make sure you use the correct hostname when connecting.

If you are new to this stuff you may get the best setup for your learning by installing MySql locally. Trying to learn both database programming and the necessary network engineering for a remote connection at the same time? Huuuge pain in the xxs neck. Can you install WAMP? Amps?

Setting a connect timeout with PDO

$DBH = new PDO(
    "mysql:host=$host;dbname=$dbname", 
    $username, 
    $password,
    array(
        PDO::ATTR_TIMEOUT => 5, // in seconds
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
    )
);

---

Related Topics