Forums

max_user_connections error starting to show up

OperationalError: (_mysql_exceptions.OperationalError) (1226, "User 'EndenDragon' has exceeded the 'max_user_connections' resource (current value: 18)")

So I currently have 6 workers plan for my webapp. I am wondering how much is considered too much connections to mysql? I never thought this is an issue until now. I expect each individual worker to open up to 2 connections to the database (one with sqlalchemy, one with beaker cache [which also is sqlalchemy]). I am wondering how it is hitting the limit. Both uses sqlalchemy (so I presume it closes the connection if they don't use it). Also, with 6 workers and max 2 connections, it should only hit 12 connections, not 18+.

What is going on? I am not too familiar with this territory.

I suggest searching for 'pool_recycle' in this Forum, and also check:

https://help.pythonanywhere.com/pages/UsingSQLAlchemywithMySQL/

I'm also getting this problem, and keep meaning to follow the advice on that link...