Is there any parameter to release memory? I see memory bloats on high concurrency and continuous runs
Hi,
Is there any parameter or any options available for MonetDB to release the memory consumed? As one of the application I tested would run on high concurrency and may run SQL overnight. In such cases I see a memory bloat which may come up to 200gb and will never come down. Please advise?
Regards, Sreejith
This may well be the result of a bug that slipped through into the release. We will be releasing a bug fix release soon that should have this bug fixed.
On 25/07/17 11:15, Sharma, Sreejith wrote:
Hi,
Is there any parameter or any options available for MonetDB to release the memory consumed? As one of the application I tested would run on high concurrency and may run SQL overnight. In such cases I see a memory bloat which may come up to 200gb and will never come down. Please advise?
Regards,
Sreejith
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks Sjoerd. So does that mean MonetDB release memory after the execution or will it release only when OS requests for?
-----Original Message----- From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Sjoerd Mullender Sent: Tuesday, July 25, 2017 3:11 PM To: users-list@monetdb.org Subject: [EXTERNAL] Re: Is there any parameter to release memory? I see memory bloats on high concurrency and continuous runs
This may well be the result of a bug that slipped through into the release. We will be releasing a bug fix release soon that should have this bug fixed.
On 25/07/17 11:15, Sharma, Sreejith wrote:
Hi,
Is there any parameter or any options available for MonetDB to release the memory consumed? As one of the application I tested would run on high concurrency and may run SQL overnight. In such cases I see a memory bloat which may come up to 200gb and will never come down. Please advise?
Regards,
Sreejith
users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/t52TqvdQvS7rnjzlyxH_sIfvswbZuj9XTI9 8I7Wm760=?d=gnASg2OqxhGABurvxeboc61_-buoDvaSG3EUqK4uc92U91mbnRnnDp6hj5 JNAuHt6sSEoMKuI6HdzkjFcKb4qQqoTuPnfCOvk-84FA7EHmTLzxKTHvKV2Oc3_1nw3RFo V-1n2gT1KKLh4tAsP3iz8FXv_Yeq7FOoJiiG8Ix4XISRBDXxtuWJVXOmv3Hadhry03nXbR GoHqV08UX4XXORLGwZLafFe5jyjTa1Adw3oqdYL8mtCyiqUwUWSyA85gaujGSJzFr8-uY8 5rkRpOjYqIhoZhix8KYgrsBqXGfXaSYSpofOuH59e674Q3Xe23OfG1_jMv6M_2fWw5batX pAzy2X9uUYCALYN6Y8y5v4xQbwUuJq8PuAU-OR3eCrhOKv_maX66PfVMMC243Oqf_NegPs y6bxcxjbs1LaK-hCeaQmg8iGfQt7UyIW_WQaRgSkUpcuYnhN8dd2ipj4EtP0DfKK6pCfl- 2uy2dhMYTXvbFANvJEtlVr8CeSEigpr6jo&u=https%3A%2F%2Fwww.monetdb.org%2Fm ailman%2Flistinfo%2Fusers-list
-- Sjoerd Mullender
The problem is that intermediate results are kept around in memory longer than needed. The fix is to release the memory as soon as it's not needed anymore which means that the server doesn't grow as much anymore. The memory didn't leak in the sense that at the end of the query it was all released, but that's too late.
On 25/07/17 12:11, Sharma, Sreejith wrote:
Thanks Sjoerd. So does that mean MonetDB release memory after the execution or will it release only when OS requests for?
-----Original Message----- From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Sjoerd Mullender Sent: Tuesday, July 25, 2017 3:11 PM To: users-list@monetdb.org Subject: [EXTERNAL] Re: Is there any parameter to release memory? I see memory bloats on high concurrency and continuous runs
This may well be the result of a bug that slipped through into the release. We will be releasing a bug fix release soon that should have this bug fixed.
On 25/07/17 11:15, Sharma, Sreejith wrote:
Hi,
Is there any parameter or any options available for MonetDB to release the memory consumed? As one of the application I tested would run on high concurrency and may run SQL overnight. In such cases I see a memory bloat which may come up to 200gb and will never come down. Please advise?
Regards,
Sreejith
users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/t52TqvdQvS7rnjzlyxH_sIfvswbZuj9XTI9 8I7Wm760=?d=gnASg2OqxhGABurvxeboc61_-buoDvaSG3EUqK4uc92U91mbnRnnDp6hj5 JNAuHt6sSEoMKuI6HdzkjFcKb4qQqoTuPnfCOvk-84FA7EHmTLzxKTHvKV2Oc3_1nw3RFo V-1n2gT1KKLh4tAsP3iz8FXv_Yeq7FOoJiiG8Ix4XISRBDXxtuWJVXOmv3Hadhry03nXbR GoHqV08UX4XXORLGwZLafFe5jyjTa1Adw3oqdYL8mtCyiqUwUWSyA85gaujGSJzFr8-uY8 5rkRpOjYqIhoZhix8KYgrsBqXGfXaSYSpofOuH59e674Q3Xe23OfG1_jMv6M_2fWw5batX pAzy2X9uUYCALYN6Y8y5v4xQbwUuJq8PuAU-OR3eCrhOKv_maX66PfVMMC243Oqf_NegPs y6bxcxjbs1LaK-hCeaQmg8iGfQt7UyIW_WQaRgSkUpcuYnhN8dd2ipj4EtP0DfKK6pCfl- 2uy2dhMYTXvbFANvJEtlVr8CeSEigpr6jo&u=https%3A%2F%2Fwww.monetdb.org%2Fm ailman%2Flistinfo%2Fusers-list
-- Sjoerd Mullender _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Sharma, Sreejith -
Sjoerd Mullender