MySQL Connector for Python

Question

I am using mysql.connector for Python. Below are my connection parameters. How can I set a timeout or increase the default timeout?

class Config(object):
    """Configure me so examples work

    Use me like this:

        mysql.connector.Connect(**Config.dbinfo())
    """

    HOST = dbhost
    DATABASE = dbdatabase
    USER = dbusername
    PASSWORD = dbpassword
    PORT = 3306

    CHARSET = 'utf8'
    UNICODE = True
    WARNINGS = True

    @classmethod
    def dbinfo(cls):
        return {
            'host': cls.HOST,
            'port': cls.PORT,
            'database': cls.DATABASE,
            'user': cls.USER,
            'password': cls.PASSWORD,
            'charset': cls.CHARSET,
            'use_unicode': cls.UNICODE,
            'get_warnings': cls.WARNINGS,
            }

johnsyweb · Accepted Answer · 2013-01-05 01:46:29Z

5

According to MySQL Connector/Python :: 6 Connector/Python Connection Arguments in the official documentation:

To set a timeout value for connections, use connection_timeout.

answered Jan 5, 2013 at 1:46

johnsyweb

143k26 gold badges197 silver badges253 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

johnsyweb Over a year ago

The Python documentation doesn't specify. The MySQL documentation specifies "seconds", so I'd guess the same, but would measure myself to be sure.

officialrahulmandal · Accepted Answer · 2020-09-30 21:56:27Z

2

If you are using mysql.connector.connect to connect with DB you can simply use connection_timeout parameter to define a timeout externally make sure value given will be in seconds instead of milliseconds.

conn = mysql.connector.connect(
    pool_name=pool['name'], 
    pool_size=pool['size'],
    host=config['host'], 
    port=config['port'], 
    user=config['user'],
    passwd=config['passwd'],
    db=config['db'],
    charset=config['charset'], 
    use_unicode=True,
    connection_timeout=10
)

answered Sep 30, 2020 at 21:56

officialrahulmandal

3,2362 gold badges30 silver badges35 bronze badges

Comments

Robert Bean · Accepted Answer · 2013-01-05 01:49:12Z

0

I found something here: http://dev.mysql.com/doc/refman/5.5/en/connector-python-connectargs.html I think you are looking for the parameter connection_timeout (connect_timeout*)

answered Jan 5, 2013 at 1:49

Robert Bean

8792 gold badges11 silver badges23 bronze badges

Comments

SilverNak · Accepted Answer · 2017-09-23 10:23:00Z

0

This works for me:

conn = mysql.connector.connect(
    pool_name=pool['name'], 
    pool_size=pool['size'],
    host=config['host'], 
    port=config['port'], 
    user=config['user'],
    passwd=config['passwd'],
    db=config['db'],
    charset=config['charset'], 
    use_unicode=True,
    connect_timeout=1000
)

If you use MySQLdb:

conn = MySQLdb.connect(
    host=config['host'], 
    port=config['port'], 
    user=config['user'], 
    passwd=config['passwd'],
    db=config['db'], 
    charset=config['charset'], 
    use_unicode=True,
    connect_timeout=1000
)

edited Sep 23, 2017 at 10:23

SilverNak

3,3914 gold badges32 silver badges45 bronze badges

answered Sep 23, 2017 at 9:39

LuciferJack

79912 silver badges13 bronze badges

1 Comment

Magnus Lind Oxlund Over a year ago

What's the unit? Seconds?

Collectives™ on Stack Overflow

MySQL Connector for Python

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related