Set timeout for MySQL Connect in PHP

Question

What is the simplest way to timeout a SELECT statement and handle the error?

<?php  
$conn = mysqli_connect("localhost", "db", "user", "pass");

SELECT COUNT(1) FROM `table` WHERE...

I have tried the following without success.

$conn -> options(MYSQLI_OPT_CONNECT_TIMEOUT, 10); 

$conn = mysqli_connect("localhost", "db", "user", "pass", connect_timeout=10);

SELECT /*+ MAX_EXECUTION_TIME(10) */ COUNT(1) FROM `table` WHERE...

SELECT SQL_TIMEOUT=10 FROM `table` WHERE..

All I want to do is abort the SELECT statement if the search term is too vague and too much time is spent scanning the table.

Pasting the following code just below the initial connection line does nothing. The query still takes about seven seconds and no error message is generated:

$conn->query('SET max_statement_time = 1'); // time in seconds

Are you trying to reduce timeout for the connection opening or for the SQL execution? — Dharman, Jun 13 '22 at 13:00
Possible duplicates of : [PHP MySQL set Connection Timeout](https://stackoverflow.com/questions/9562124/php-mysql-set-connection-timeout) — Alive to die - Anant, Jun 13 '22 at 13:13

score 0 · Answer 1 · edited Jun 14 '22 at 10:52

0

I just needed to replace with:

$conn->query('SET SESSION MAX_EXECUTION_TIME = 3');

edited Jun 14 '22 at 10:52

Dharman

30,962
25
85
135

answered Jun 13 '22 at 19:22

Ned Hulton

477
3
12
27

Set timeout for MySQL Connect in PHP

1 Answers1