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 ?

Answer 1

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 > Options File > Tab "Networking" > Section "Timeout Settings")

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