472,103 Members | 1,554 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,103 software developers and data experts.

Memory increasing with heavy load

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.
Jan 15 '07 #1
1 1256
4,258 Expert 4TB
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:
Jan 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Kayra Otaner | last post: by
4 posts views Thread by Chris | last post: by
7 posts views Thread by Rich Denis | last post: by
reply views Thread by Gujju | last post: by
8 posts views Thread by BillE | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.