Memory increasing with heavy load

[bhardwajvinu]

We are experiencing a problem running MySql 5 whereby under heavy load(with 2 connection and getting raw data from two or three table by a common java task that is running as infinite loop ), memory usage just continues to grow until it exceeds 2Gb and starts the machine swapping.

I also closing all resultset, statement and preparestatement in finally block and after that making it as null. But i could not find any solution.

Here are some vital statistics of our usage:

jdbc driver: mysql-connector-java-5.0.4-bin.jar
os: winXp 32 bit
mysql: mysql 5.0.18
We have approximately 2 connections being opened using snaq connection pool. version 4.8.

[ronverdonk]

Are you running a lot of transactions? These cost a lot of storage.

Another reason could be the Java task. Since it is running in an infinite loop it would accumulate a lot of storage, used or unused (un-released). I would certainly have a look at this side of the system.
Ronald :cool: