I connected to a mysql database using python I checked Mysql default timeouts which were:
How can I change the default timeout ? asked Feb 6, 2013 at 10:30
Animesh PandeyAnimesh Pandey 5,65013 gold badges58 silver badges127 bronze badges 1 Do:
Parameter meaning (taken from MySQL Workbench in Navigator: Instance > Options File > Tab "Networking" > Section "Timeout Settings")
BTW: 28800 seconds are 8 hours, so for a 10 hour execution time these values should be actually higher.
Joshua Pinter 42.8k23 gold badges233 silver badges236 bronze badges answered Oct 26, 2013 at 18:50
6 You change default value in MySQL configuration file (option connect_timeout in mysqld section) -
If this file is not accessible for you, then you can set this value using this statement -
answered Feb 6, 2013 at 10:38
DevartDevart 116k22 gold badges161 silver badges181 bronze badges 2 I know this is an old question but just for the record this can also be done by passing appropriate connection options as arguments to the
Notice the use of keyword parameters (host, passwd, etc.). They improve the readability of your code. For detail about
different arguments that you can pass to answered Nov 14, 2016 at 14:40
nsanensane 1,6463 gold badges21 silver badges30 bronze badges MAX_EXECUTION_TIME is also an important parameter for long running queries.Will work for MySQL 5.7 or later. Check the current value
Then set it according to your needs.
answered Nov 2, 2018 at 19:24
xs2rashidxs2rashid 85311 silver badges16 bronze badges 2 |