Grails MySql processList
Posted
by Masiar Ighani
on Stack Overflow
See other posts from Stack Overflow
or by Masiar Ighani
Published on 2009-07-13T08:05:07Z
Indexed on
2010/03/22
3:01 UTC
Read the original article
Hit count: 446
Hello,
i have a grails application with a webflow. I store my inner flow objects of interest in the converstaion scope. After entering and leaving the flow a few times, i see that the single user connected to the DB (MySql) generates a lot of threads on the MySql Server which are not released. The processlist in mysql show me the threads in sleeping mode and a netstat on the client shows me established connections to the mysql server. I assume the connections are held active and not released. But why is that? What do grails exactly do when entering and leaving a flow? Why are so many connections opened and not closed?
Any help would be appreciated.
regards, masiar
© Stack Overflow or respective owner