Bugs item #1651599, was opened at 2007-02-04 05:58
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1651599&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: relational (relational)
Assigned to: Niels Nes (nielsnes)
Summary: caching of inserts causes extreme memory consumption
Initial Comment:
I'm not sure if this is a bug, but at least it is very annoying:
Depending on the data (on more homogenous data, for example data with less null
columns it seems to happen far more slowly), inserting rows into tables fills
the memory quite fast. The memory consumption seems to be correlated to the
number after "sql_cache.s" in the output lines like "function
sql_cache.s54_1(A0:int,A1:int,A2:int,A3:int,A4:int,A5:int,A6:int):void# 0
(s54_1:void)<-(A0:int)(A1:int)(A2:int)(A3:int)(A4:int)(A5:int)(A6:int)" printed
when MonetDB5 has been compiled using the -DDEBUG_CALLMAL preprocessor flag,
which leads me to the assumption that the inserted rows fill up some kind of
row data cache.
If this is the intended behavior, it would be fine to know if there is a way to
flush the cache (partially?) or otherwise limit or explicitly decrease the
memory usage of a running server (maybe using mal/mil). Currently, I'm forced
to restart the server periodically.
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-02-04 17:11
Message:
Logged In: YES
user_id=43556
Originator: NO
fixed 2 problems
1) query use 'insert into foo select v1,v2 ..'
That case could use the require cheap upcasts as the v1,v2 etc had a
refcount of 2 within the convert function (than upcasts are unsave)
2) cheap upcasts from decimals to floats weren't possible, but now that
is added
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2007-02-04 16:57
Message:
Logged In: YES
user_id=43556
Originator: NO
Added this test as caching.SF-1651599.sql (src/test/BugTracker/Tests)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1651599&group_id=56967
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
