Re: [MonetDB-users] killing queries

On Fri, Jan 04, 2008 at 02:35:34AM +0800, Rahul Chopra wrote:

Thanks for the information, I understand.

Other than killing the client application, is there a way to separately connect to the server and gracefully kill the query or connection?

No currently not. Maybe you could open a feature request for this. Have a list of features users would like we can more easily decide on which to work. Niels

...

----- Original Message ----- From: "Niels Nes" To: "Communication channel for MonetDB users" Subject: Re: [MonetDB-users] killing queries Date: Thu, 3 Jan 2008 17:47:45 +0100

On Fri, Jan 04, 2008 at 12:06:37AM +0800, Rahul Chopra wrote:

...

How can I safely kill queries?

I notice if I ctrl-c out of mclient when executing a long run query, mserver5 still seems to be using a lot of memory, maybe it has not deallocated it all? Also, if I start a new mclient session queries now run slower. Of course, one should always avoid ctrl-c, but in case we do have multiple queries running and we wish to kill a long running one for some reason, is there a way to safely do so? (Like, start a new mclient session, and execute some kind of admin commands). Resources taken because of killed clients should disappear. This can however take some time as the cleanup is only done within the interpreter loop. Also we keep the used persistent tables in memory. They only get freed when running out of memory or when idle for some time.

I'm not sure which version your using, but also the current released version has some memory leaks which maybe the reason for your memory growth and slowdown.

Niels

...

TIA

= Espresso Machines - Free Shipping Espresso Machines, coffee beans and pods, cappuccino cups and spoons. Free shipping. No sales tax. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=8427826bf39d56eb7c331a1f...

-- Powered by Outblaze

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

--

Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

...

= Area Homes Realty Online Home Search Area Homes Realty is a full service residential real estate company servicing Eastern Massachusetts. Our website is a valuable resource of information whether you are buying or selling. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=6d65a7e04b5c96a53badb070...

-- Powered by Outblaze

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl