MYSQLI_OPT_READ_TIMEOUT

[LeVadim]

Hello Laravel Community!

I have a need to set a client-side timeout for the database SELECT queries, I have come along the following parameter - MYSQLI_OPT_READ_TIMEOUT .

I have tried setting it up in the database.php under "options", however, that did not work.

The goal is to ensure that if the "select" query is taking longer than "x" seconds, terminate it from the client side.

This would ensure that client is closing the queries because they are running too long, instead of the MySQL database terminating them.

Kindly share your thoughts on this. Thank you.

database.php is below:

        'mysql' => [
            'read' => [
                'host' => [
                    env('DB_HOST', '127.0.0.1')
                ],
            ],
            'write' => [
                'host' => [
                    env('DB_HOST', '127.0.0.1')
                ],
            ],
            'sticky' => true,
            'driver' => 'mysql',
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
            'options'   => [
                PDO::ATTR_PERSISTENT    => true,
                MYSQLI_OPT_READ_TIMEOUT => 1
            ]
        ],

I am supposing I should use PDO::ATTR_TIMEOUT => 2, however, it was not working either and moreover, ATTR_TIMEOUT is for connections.. not for MYSQL READ TIMEOUTS.

Best regards,
Vadim