Hello! Im using pyDAL with falcon (http://falconframework.org/) for microservices building but im having troubles in the way pyDAL handle the connections, i think pydal isnt telling my MySQL server to close the connection after each query, i've writen an example method with just a select, and put the Connection limit of MySQL in 500, after i make 500 requests to my API, the MySQL gives me "Too many connections".
In my code i simply declare a DAL object wit this: db = DAL(uri, pool_size=0, check_reserved=['all'], lazy_tables=False, migrate=True, folder=os.path.dirname(os.path.realpath(__file__))+"/database") And create an example table with two fields, make a simple query like: db(db.comentario.fk_app_id == 1).select() So, i dont know if there are any suggestions on this case, like a method in pyDAL to manually close the connection after each transaction and create a new one. I'm using pydal 16.3, Thanks for your help! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
