[Monetdb-developers] Fw: Re: Fw: Re: Fw: Re: related to jdbc

anshul gangwar anshul1886 at yahoo.co.in
Mon Mar 15 14:23:26 CET 2010


hello ,
       actually we are working on java based tool whose main focus is to visualize the plans 
used by the optimizer for final execution of query but in monetdb optimization is runtime  so we have to somehow access that plan through jdbc and what are the maincomponents of the plan i.e can be represented as node in tree

We are not able to use that , actually that is giving error 
MAPI  = monetdb at localhost:50000
ACTION= mapi_start_talking
ERROR = !xchange_challenge: frontend mal not found



Dear Anshul,


Op 15-03-10 05:42, anshul gangwar schreef:
>     We want to debug the monetdb server , in other words we want final
>     execution plan and query execution times etc.

Then most likely you will love the stethoscope tool! It gives an awesome
view in the MonetDB kernel *and* it provides you realtime information
about the queries that have
 been executed. That is not all, you can just
start and stop it without(!) restarting the server, while still making
nifty graphs from this program.

I think this is totally what you need.


There is a lot documentation written for this tool, so you don't have to
be a rocket scientist to use it :)

<http://monetdb.cwi.nl/MonetDB/Documentation/Stethoscope.html>

The last line on the page will give you an example commandline. If you
did not yet change your default monetdb password you can use this one:

stethoscope -umonetdb -Pmonetdb +tis algebra.* bat.* group.* sql.* aggr.*


Please report back how useful this was for your debuging and use of
MonetDB. We appreciate your interest.



Yours Sincerely,

Stefan de Konink
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14
 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEAREKAAYFAkudwdMACgkQYH1+F2Rqwn0+AwCfTg5FruAc6QDgOIT4ZJZ4bOWB
hTAAnjkWylxX7JafSLI21qZFE6BMydoO
=8rz4
-----END PGP SIGNATURE-----



      Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20100315/33caea37/attachment.html>


More information about the developers-list mailing list