dynamically change mysqli connection timeout in PHP

Question

how can I dynamically change MySqli connection timeout using PHP? I found the following manual that you can set an option after a connection is opened, but it says it only support Windows since PHP 5.3.1:

http://www.php.net/manual/en/mysqli.options.php

I'm using PHP5.2.4, MySQLi (improved version)

the default connection timeout is 20 seconds in my.cnf, but in a special php script I have I'd like to set it to higher like 500 seconds before it times out.

The manual entry is a bit ambiguous in my mind. It might as well mean, it works everywhere, but on Windows only with PHP 5.3.1 or higher. Are you on a Linux machine? Can you try out? — Pekka
– Pekka, Commented Jan 12, 2010 at 20:24

Yada · Accepted Answer · 2010-01-12 20:28:20Z

2

$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500)

manual

However, making a connection from php to mysql is NOT resource intensive. IMHO, it is a better idea to have a smaller timeout and make multiple connections. Doing so will free up the connections for other processes.

answered Jan 12, 2010 at 20:28

Yada

31.5k25 gold badges105 silver badges145 bronze badges

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

3 Comments

Pekka Over a year ago

His problem (as far as I understand) is that this won't work on his Windows server because he is using PHP < 5.3.0.

Beier Over a year ago

I agree, all my normal connections are subject to 20 second timeout. but this specific script takes long time to run and sometimes idle mysql connection for long, that's why I need longer connection just for this script

Pacerier Over a year ago

@Yada, Why are you posting the solution the question has already stated not to work? How can we make it work in Windows < PHP 5.3.1?

Sk8erPeter · Accepted Answer · 2015-06-03 23:22:21Z

2

the correct solution for mysqli is right after an connection is opened, issue the following query to change session.wait_timeout to longer:

SET @@session.wait_timeout=500

edited Jun 3, 2015 at 23:22

Sk8erPeter

7,0059 gold badges51 silver badges67 bronze badges

answered Jan 12, 2010 at 22:49

Beier

3,16710 gold badges29 silver badges24 bronze badges

Comments

Sk8erPeter · Accepted Answer · 2015-06-03 23:21:48Z

1

I'm very sorry for the confusion, but I'm using Linux server, not Windows. I misunderstood the comment in the PHP docs "supported on Windows with TCP/IP since PHP 5.3.1", I thought that means the option is only supported on Windows server.

OK, so

$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500);

will work perfectly for me.

Thanks

edited Jun 3, 2015 at 23:21

Sk8erPeter

7,0059 gold badges51 silver badges67 bronze badges

answered Jan 12, 2010 at 20:39

Beier

3,16710 gold badges29 silver badges24 bronze badges

2 Comments

AntonioCS Over a year ago

Edit your question and place what you placed here, there :)

Sk8erPeter Over a year ago

Why did you post TWO answers to this thread?! You should "merge" them and delete one of them.

Collectives™ on Stack Overflow

dynamically change mysqli connection timeout in PHP

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related