» MySQL Timeout für einzelne SELECT Queries

SELECT 
MAX_STATEMENT_TIME = 1000 --in milliseconds
* 
FROM table;

Zitat

max_statement_time applies as follows:

The global max_statement_time value provides the default for the session value for new connections. The session value applies to

SELECT

statements executed within the session that include no MAX_STATEMENT_TIME = N option or for which N is 0.

max_statement_time applies to read-only

SELECT

statements. Statements that are not read only are those that invoke a stored function that modifies data as a side effect.

max_statement_time is ignored for

SELECT

statements in stored programs.

This variable was added in MySQL 5.7.4 and renamed to max_execution_time in MySQL 5.7.8.

MAX_STATEMENT_TIME

SELECT

SELECT

// guard the mysql database
$mysql_guard_lock = 'locks/mysql_guard_lock';
if (!file_exists($mysql_guard_lock) && @mkdir($mysql_guard_lock)) {
	$sql = 'SHOW FULL PROCESSLIST';
	$result = $db->sql_query($sql, false, __LINE__, __FILE__);
	while ($row = $db->sql_fetchrow($result)) {
		if ($row['Command'] == 'Query' && $row['Time'] > 5 && strpos($row['Info'], 'BOOLEAN') !== false) {
			$sql = 'KILL QUERY ' . intval($row['Id']);
			$db->sql_query($sql, false, __LINE__, __FILE__);
		}
	}
	$db->sql_freeresult($result);
	rmdir($mysql_guard_lock);
}

PROCESSLIST

BOOLEAN

SELECT

BOOLEAN

SELECT

sys_getloadavg()

Mach mit!