ASP.NET Application with MySQL hosted on IIS

The application loses connection to MYSQL database after sometime and requires me to restart mysql service then it continues to connect.

what kind of error message is prompting out?

do you still need assistance here?

Yes I still do

But my problem is that I cant identify the real error message behind the behaviour as this does not happen in development environment but only happens in production

do you have some MySQL monitoring tools installed on your server to see if there's any abnormalities ?

alternatively, run some scripts below and see you got high volume on these?

show status where variable_name = 'Threads_connected'

Select allOpen in new window

show processlist

Select allOpen in new window

and make sure you free the resources, such as close the Connections before you leave your codes?