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

Filed under:
|

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

Related posts about grails

Related posts about mysql