This is a screenshot of the process list of my MySQL DB. There are queries which are stuck for the past 20000+ seconds. I know there are issues in the code. My question is, is there any way to know which queries are these?
I am new to this . . . any help will be highly appreciated.
There are no queries here.
Sleep
means these are open connections waiting for the next request.