python mysql 连接超时时间,通过python连接时，如何更改默认的Mysql连接超时？

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 ?

解决方案

Do:

con.query('SET GLOBAL connect_timeout=28800')

con.query('SET GLOBAL wait_timeout=28800')

con.query('SET GLOBAL interactive_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.