How to increase query execution time limit in MySQL

Question

We are getting timeout error when we are trying to fetch data which has multiple joins and many calculations in stored procedures.

To improve performance, we definitely need to reduce joins but for now I expect query to give results to web by increasing the timeout limit is it possible or the max time is 30 seconds?

https://stackoverflow.com/questions/14726789/how-can-i-change-the-default-mysql-connection-timeout-when-connecting-through-py — Pavel Oganesyan, Nov 29 '22 at 07:04
Let's see a sample of a slow query. Please include `SHOW CREATE TABLE`. — Rick James, Nov 30 '22 at 06:13

score 0 · Answer 1 · answered Nov 29 '22 at 08:57

0

try running the query from the database or console and see if the results appear? and how much execution time?

if the results of the query appear, then the problem is in the application time limit. try increasing the timeout in the application config

answered Nov 29 '22 at 08:57

Ramadika Bagaswara

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Dec 02 '22 at 05:21

How to increase query execution time limit in MySQL

1 Answers1