mysql.connect_timeout in php vs connect_timeout in MySQL

Question

What is the difference between :

mysql.connect_timeout

that we can find in php.ini

and

connect_timeout

that belongs to MySQL configuration (show variables).

Knowing that Apache server and MySQL server are two distant VPS with a VIP between them, what is the value considered by the whole environment (Varnish + Apache + MySQL)?

Barmar · Accepted Answer · 2014-08-19 08:17:51Z

12

mysql.connect_timeout tells PHP how long it should wait for a response from the MySQL server when it tries to connect.

connect_timeout in MySQL configuration tells the MySQL server how long to wait for a connect packet from the client before responding with a Bad handshake error.

Apache is not involved in either of these timeouts, they're just between PHP and MySQL. First PHP connects to MySQL; if it doesn't get a response before mysql.connect_timeout, it will report an error. Once that succeeds, PHP sends a connect packet to MySQL; if it doesn't do that within connect_timeout, MySQL will report an error and close the connection.

answered Aug 19, 2014 at 8:17

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Comments

Paul Frederiksen · Accepted Answer · 2014-08-19 08:17:49Z

0

The shortest timeout within the stack would be essentially act as your timeout. If you hit a timeout, the longer timeout will never get hit, so it won't matter.

answered Aug 19, 2014 at 8:17

Paul Frederiksen

3842 silver badges8 bronze badges

1 Comment

mcmacerson Over a year ago

Paul is this really true given that mysql.connect_timeout handles PHP to MySQL and connect_timeout handles MySQL to PHP?

Collectives™ on Stack Overflow

mysql.connect_timeout in php vs connect_timeout in MySQL

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related