I am new to umbraco, currently using version 7.13.2 with MySQL database.
We are doing UAT on our server and found out some production issues.
Where there are alot of concurrent user access to a page which using "ApplicationContext.Current.Services.MediaService.GetMediaByPath", Umbraco would automatically create alot of database connection.
After some research, it seem like this is a behaviour that Umbraco used to handle concurrent access to DB. But I am wondering why the connection is keeping open, and eventually the sleep connection is keep increasing and reach my max size of connection pool.
The problem solved, and the answer posted at "https://stackoverflow.com/questions/57714573/umbraco-database-connection-reach-max-pool-size/57814592#57814592"
Max size of connection pool reached due to concurrent user
Hi,
I am new to umbraco, currently using version 7.13.2 with MySQL database. We are doing UAT on our server and found out some production issues.
Where there are alot of concurrent user access to a page which using "ApplicationContext.Current.Services.MediaService.GetMediaByPath", Umbraco would automatically create alot of database connection.
After some research, it seem like this is a behaviour that Umbraco used to handle concurrent access to DB. But I am wondering why the connection is keeping open, and eventually the sleep connection is keep increasing and reach my max size of connection pool.
Thanks Aven Cheong
The problem solved, and the answer posted at "https://stackoverflow.com/questions/57714573/umbraco-database-connection-reach-max-pool-size/57814592#57814592"
Thanks Aven Cheong
is working on a reply...