Inserting data into Database uses up lots of memory
Posted by:
Evarest S
Date: June 02, 2012 08:32AM
Hi,
I'm running a script that inserts quite a lot of data in a MySQL Database. Currently, it's running at ~3000 inserts every minute, each about 2kB big.
The problem is that it appears that each insert uses about 2kB of memory, which is not freed after the insert. So, slowly but unstoppable the memory of my server is being uses up.
After about 20 minutes, memory usage increases with ~100 MB.
Is this normal behaviour? And if so, is there anything I can do to free up memory every once in a while?
The script will run 24/7. However, even when I stop the script, the memory is not freed up. So restarting the script did not help me...
Thanks!
Subject
Views
Written By
Posted
Inserting data into Database uses up lots of memory
1835
June 02, 2012 08:32AM
929
June 06, 2012 03:51AM
951
June 12, 2012 02:11PM
872
June 14, 2012 05:41AM
886
June 14, 2012 05:42PM
905
June 11, 2012 10:36PM
1054
June 12, 2012 02:18PM
1060
June 13, 2012 11:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.