php mysql timeout setting method

php mysql timeout setting method: first check the source code of MySQL; then get the actual values ​​of "MYSQL_OPT_READ_TIMEOUT" and "MYSQL_OPT_WRITE_TIME"; finally call "mysql_option" directly.

Set the timeout for PHP to connect to mysql

The timeout for PHP to connect to mysql can be divided into three types:

连接超时
读超时
写超时

Because PHP currently has two connection methods to connect to mysql, libmysql and mysqlnd (recommended).

First of all, libmysql

In the underlying library of libmysql, MYSQL_OPT_CONNECT_TIMEOUT, MYSQL_OPT_READ_TIMEOUT, MYSQL_OPT_WRITE_TIME setting items are provided, and related APIs are provided.

Source code location

mysql-VERSION/sql-common/client.c 3020行

MYSQL_OPT_CONNECT_TIMEOUT can be set directly. But MYSQL_OPT_READ_TIMEOUT and MYSQL_OPT_WRITE_TIME are not imported by mysqli.

So you need to check the source code of MySQL, get the actual values ​​of MYSQL_OPT_READ_TIMEOUT and MYSQL_OPT_WRITE_TIME, and then call mysql_option directly. However, mysql_pdo is hard-coded, so there is no way to set MYSQL_OPT_READ_TIMEOUT and MYSQL_OPT_WRITE_TIME.

Source code location:

mysql-VERSION/include/mysql.h 160 lines

But MYSQL_OPT_READ_TIMEOUT is in mysql5.6 version and before (we use 5.6 online), This parameter has the following three limitations.

只能在TCP／IP协议下工作
MySQL server版本必须大于5.1.2
只能在windows下生效。

The second is mysqlnd

For libmysql and mysqlnd, they are the underlying libraries of mysql, mysqli, and mysqlpdo. These three extensions are the APIs exposed to the outside world. , so their support for these three timeouts is the same from the code level.

But for MYSQL_OPT_READ_TIMEOUT, mysqlnd is configured in multiple places at the php.ini level

mysqlnd.net_read_timeout

This configuration will take a long time to execute sql, and the error "2006-MySQL Server has gone away" is reported.

This parameter is very similar to libmysql's MYSQL_OPT_READ_TIMEOUT. However, the parameter MYSQL_OPT_READ_TIMEOUT has usage scenarios, which have been explained in the previous summary.

MYSQL_OPT_CONNECT_TIMEOUT and MYSQL_OPT_WRITE_TIME are the same as libmysql.

Recommended: "PHP Tutorial"

In short

• Use mysqlnd

• Configure mysqlnd.net_read_time

The above is the detailed content of php mysql timeout setting method. For more information, please follow other related articles on the PHP Chinese website!