Home Software Engineering Find out how to Abort SQL statements after a set time in MariaDB

Find out how to Abort SQL statements after a set time in MariaDB

0
Find out how to Abort SQL statements after a set time in MariaDB

[ad_1]

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 SELECT.

That is measured in seconds, so the above question will robotically be killed after 30 seconds.

[ad_2]

LEAVE A REPLY

Please enter your comment!
Please enter your name here