MySQL connection times out after a while (Python, MySQL, FLASK)

Question

I'm currently running an flask python application running on an NGINX server with the help of uWGI. The static pages are always reachable but the pages that use a connection (MySQL) time out after 2 minutes. What's going on? They become simply become unavailable.

Things I have tried:

Not using a global
working with pools
turning off firewall

.

# using python version 2.7.10
from flask import Flask, jsonify, request, session
import mysql.connector.pooling

#Make a connection with the DB

dbconfig = {
  "host" : "12.34.5.78",
  "database": "db",
  "user":     "user",
  "password": "pass"
}

conn = mysql.connector.connect(pool_name = "mypool",
                      pool_size = 6,
                      **dbconfig)

#Define the root
app = Flask(__name__)

#Landings page
@app.route('/')
def index():
    return "Hello World."

# return all resources by name
@app.route('/resources', methods=['GET'])
def allResourceNames():
    conn1 = mysql.connector.connect(pool_name="mypool")
    reader = conn1.cursor()
    query = ("SELECT name FROM resources")
    reader.execute(query)
    resources = []
    for name in reader:
    resources.append({'name' : name[0]})
    reader.close()
    conn1.close()
    return jsonify({"resources" : resources})

if __name__ == "__main__":
    app.run(debug=True)

tuergeist · Accepted Answer · 2016-11-02 10:00:24Z

3

According to MySQL Python Connector Doc you may want to set connection_timeout as connect option. E.g.,

conn = mysql.connector.connect(pool_name = "mypool",
                  pool_size = 6, connection_timeout=3600,
                  **dbconfig)

answered Nov 2, 2016 at 10:00

tuergeist

9,4413 gold badges39 silver badges58 bronze badges

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

2 Comments

tuergeist Over a year ago

Could you please post the error msg you're getting in your post? thanks

Stephen Over a year ago

It worked by the way. But i'm not sure why. I simply changed the connection_timeout=1 and now it's actually quite a bit faster. Could you explain what's actually happening?

Collectives™ on Stack Overflow

MySQL connection times out after a while (Python, MySQL, FLASK)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related