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

by

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.

More Related Contents:

  1. Python read from txt and save into mysql
  2. Lost connection to MySQL server during query
  3. How to install Python MySQLdb module using pip?
  4. Does Python support MySQL prepared statements?
  5. Escape string Python for MySQL
  6. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  7. Classification using movie review corpus in NLTK/Python
  8. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  9. Load CSV data into MySQL in Python
  10. Enable Python to Connect to MySQL via SSH Tunnelling
  11. Inserting a Python datetime.datetime object into MySQL
  12. How to replace Django’s primary key with a different integer that is unique for that table
  13. MySQL — Joins Between Databases On Different Servers Using Python?
  14. Using a Python dict for a SQL INSERT statement
  15. Python Mysql, “commands out of sync; you can’t run this command now”
  16. How do I escape % from python mysql query
  17. Bulk insert with SQLAlchemy ORM
  18. RuntimeError: working outside of application context
  19. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  20. ImportError: No module named MySQLdb
  21. Can’t install mysql-python (newer versions) in Windows
  22. Using Django database layer outside of Django?
  23. How to move a model between two Django apps (Django 1.7)
  24. How do i cast char to integer while querying in django ORM?
  25. flake8 complains on boolean comparison “==” in filter clause
  26. How do I get time from a datetime.timedelta object?
  27. Python issue:Unable to find vcvarsall.bat [duplicate]
  28. Context manager for Python’s MySQLdb
  29. Retrieve query results as dict in SQLAlchemy
  30. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

Leave a Comment