Limiting the Execution Time of a Query

How can you limit the execution time of a query from inside the query? 🤔

[k_gold]

Compilers reading and interpreting a comment is as scary as your ISP going through and broadcasting your search history

[ArtemKhodos]

Man, so useful videos. I am your almost real friend now!

[xtz_]

Bro just followed u 2h ago i learned ton of stuff 😂

[StiekemeHenk]

Will it return the selection so far if it has any or will it just error out?

[Rapid-eraser]

Does this option override the cnf max execution option ?

[erkintek]

there was an old saying read that f*king manual, which I rarely do.
instructing optimizer is fantastic that i never heard of.
may you include which versions those are valid?

[adarshchacko]

Didn't quite get the last part... "If you know it is going to run forever you can use it to lengthen the max_execution_time"

[clashclan]

What is the use i don't understand will it throw error if it cross max execution limit?

[thedelanyo]

MySQL is able to read and parse my comments? Awesome and deadline.

[MrNiceGuy]

Great video, this instruction as the name says is to limit the MAX_EXECUTION_TIME, and usually is used to cancel the execution of the query. As you may predict that if the query takes more than X milliseconds, then is not worth to continue and should be canceled.
Not to improve your database readings, like when you mentioned that your query takes 300ms to be completed on a normal scenario, in the same scenario if you apply that instruction you will not get results back, so why would you do that? :D

[johnnicholls]

MySQL is unable to respect the limit under very high concurrent load and queries can run for much longer.
A great feature for killing badly written queries or where the optimiser has mad a poor query plan.

[TariqSajid]

can anyone please recommend best mysql client for mac os which is free ?

[wachdai]

Is this limit the results? For example:
the result after 3 second is 100k, but using this, we only receive 10k?

[rujor]

Huh? ... but what does the command do exactly 🤔?

[chwritex]

Hey Bro Really Loved your channel, I would like to discuss something with you, Are you up to it?

[shafiq_ramli]

I also have friend(s) like you but let me finish reading rust documentation first

[chrishunter]

I came across this bit of rare magic, lol

[aurelian]

Hello, what about other MySQL products, which are not free?

[FunkyELF]

Wow, what a terrible design decision for a comment to affect the query.