Friday, 13 September 2013

MySQL WRITE hangs on spring hibernate application

MySQL WRITE hangs on spring hibernate application

not sure where to start in my research.
Recently I have moved my hard drives to a new server. My old server used
to be one core just 4GB RAM. Now I am running 8 cores 32GB RAM. MySQL
version 5.0.77. I have SPring Hibernate setup. Here is a configuration
file
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
primary="true">
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://host:port"/>
<property name="user" value="xxx"/>
<property name="password" value="xxx"/>
<property name="minPoolSize" value="2"/>
<property name="maxPoolSize" value="50"/>
<property name="maxIdleTime" value="3600"/>
<property name="maxStatements" value="500"/>
<property name="automaticTestTable" value="pool_test"/>
<property name="idleConnectionTestPeriod" value="120"/>
So everything seems to be fine, however recently I started to get strange
issue. When I login into the website, its all working, but when I try to
SAVE stuff it hangs. I am looking at the Java Melody monitoring and it
shows me lots of hanged current requests. Looking at the my sql
connections, all of them are SLEEP.
Can it be maybe the MySQL server has to be update? THis is never happened
before on the old server. Any clue where I can start looking ? Thanks in a
advance

No comments:

Post a Comment