Set database connection timeout in CodeIgniter 3

Question

We are working with 2 databases, our local database and an external database. But now our external database is down (we're still under development so it's good we came across this issue) and it now tries to connect to the external database for 30 seconds, how can I change the connection timeout of the Database to something like 1 - 2 seconds? I am using Codeigniter with the PDO drivers on my databases. Is there anyone with a clean solution for this problem?

Have you tried setting PDO::ATTR_TIMEOUT? What is your database though? — VolenD
– VolenD, Commented Sep 19, 2015 at 19:10
That's one way to fix the issue, but I don't know if you're using codeigniter, it lets you choose between multiple drivers, (mysql, mysqli and PDO). I would like to know if it's possible to fix this issue without editting to core (which would be the PDO driver as I am using PDO to talk to a Mysql database) @user3584460 — Jordy
– Jordy, Commented Sep 19, 2015 at 19:15

VolenD · Accepted Answer · 2015-09-19 21:03:02Z

11

+100

It is not a documented feature, but you can do this from the database config file (application/config/database.php) by adding options setting e.g.:

$db['default']['options'] = array(PDO::ATTR_TIMEOUT => 5);

The other settings which use the same internal mechanism (e.g. PDO::MYSQL_ATTR_INIT_COMMAND set with $db['default']['stricton'] and PDO::MYSQL_ATTR_COMPRESS set with $db['default']['compress']) are not affected by this.

If you want to dig deeper or check which options are set, you can log $this->options in db_connect function in system/database/drivers/pdo/pdo_driver.php and also check database/drivers/pdo/subdrivers/pdo_mysql_driver.php.

answered Sep 19, 2015 at 21:03

VolenD

3,74221 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jordy Over a year ago

Exactly what I was looking for, working like a charm! Thanks alot!! I cannot yet give you the bounty but will do so once I can.

Collectives™ on Stack Overflow

Set database connection timeout in CodeIgniter 3

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related