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@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/