How can I change the default Mysql connection timeout when connecting through python

Question

I connected to a mysql database using python con    mysql connect  localhost    dell-pc        test   The program that I wrote takes a lot of time in full execution i e  around 10 hours  Actually  I am trying to read distinct words from a corpus   After reading was finished there was a timeout error   I checked Mysql default timeouts which were    ---------------------------- ----------    Variable name                Value       ---------------------------- ----------    connect timeout              10           delayed insert timeout       300          innodb lock wait timeout     50           innodb rollback on timeout   OFF          interactive timeout          28800        lock wait timeout            31536000     net read timeout             30           net write timeout            60           slave net timeout            3600         wait timeout                 28800       ---------------------------- ----------    How can I change the default timeout

User · Accepted Answer

Do  con query  SET GLOBAL connect timeout 28800   con query  SET GLOBAL interactive timeout 28800   con query  SET GLOBAL wait timeout 28800    Parameter meaning  taken from MySQL Workbench in Navigator  Instance  gt  Options File  gt  Tab  quot Networking quot   gt  Section  quot Timeout Settings quot    connect timeout  Number of seconds the mysqld server waits for a connect packet before responding with  Bad handshake  interactive timeout Number of seconds the server waits for activity on an interactive connection before closing it wait timeout Number of seconds the server waits for activity on a connection before closing it  BTW  28800 seconds are 8 hours  so for a 10 hour execution time these values should be actually higher

User · Answer

You change default value in MySQL configuration file  option connect timeout in mysqld section  -   mysqld  connect timeout 100   If this file is not accessible for you  then you can set this value using this statement -  SET GLOBAL connect timeout 100

User · Answer

MAX EXECUTION TIME is also an important parameter for long running queries Will work for MySQL 5 7 or later   Check the current value   SELECT   GLOBAL MAX EXECUTION TIME    SESSION MAX EXECUTION TIME    Then set it according to your needs   SET SESSION MAX EXECUTION TIME 2000  SET GLOBAL MAX EXECUTION TIME 2000

User · Answer

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  mysql connect call  For example   con    mysql connect host  localhost   user  dell-pc   passwd     db  test             connect timeout 1000    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  mysql connect  see MySQLdb API documentation

[python] How can I change the default Mysql connection timeout when connecting through python?

Examples related to python

Examples related to mysql

Examples related to corpus