Laliwala IT Services

Laliwala IT Services
Website Development

Liferay Question Answer1

Rishi Dev Gupta : Mysql Connection in sleep state
Hi all

I am using LFR 5.2.3/mysql 5.0.

I am facing the issue that when we put some load then after the load is completed therea re too many connections in "sleep" state in mysql. The process list can be seen using "show processlist" command.

Is there something wrong with my configuration. Ideally the connection should not be in sleep mode once the session in liferay is over. Mysql should release the resources with processes.

If anybody have faced the same issue and have fixed it let me know.

Thanks to all



Mazhar Anwar : RE : Mysql Connection in sleep state

There is nothing wrong with your setting. This is Hibernate's working behaviour.

for more info please check following properties in portal.properties.

jdbc.default.maxPoolSize=100
jdbc.default.minPoolSize=10

Regards,
Faris Abdulla : Hi Mazhar,
I also have the same problem, but it happens for my second database.
For my application I'm using 2 database 'A' and 'B'. My 75% of the details are stored in database 'A' and remaining in database 'B'.
The issue is that the database 'A' is accessed all the time. But 'B' is rarely accessed. So if the 'B' is not accessed for more than 1 day the MySQL connection of 'B' got sleep state and the data is not able to access.
In that case I need to restart my server or atleast anyone should access the data in 'B' daily at once.
How can I achieve this. Please help me on this..
Thanks, Faris
Roshan Qureshi : Please put your settings and also stack trace of the exception you are getting at your end.