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.