Generally you don’t need a
SELECT question to run for greater than a set period of time.
This can be a roundabout strategy to make your server doesn’t die from slow-running queries.
Clearly, it is best to tweak your database and doubtlessly run your SELECT queries by an EXPLAIN plan first. This lets you create applicable indexes and discover why issues are sluggish within the first place.
However: generally you continue to end up desirous to kill queries that will run over a sure period of time.
Find out how to abort sluggish queries
Your unique question:
SELECT b.area as area ...
Your new question:
SET STATEMENT max_statement_time=30 FOR SELECT b.area as area ...
Discover the addition of the
SET STATEMENT max_statement_time=30 proper earlier than the
That is measured in seconds, so the above question will robotically be killed after 30 seconds.