[Monetdb-developers] Fw: Re: Fw: Re: related to jdbc
We want to debug the monetdb server , in other words we want final execution plan and query execution times etc.
We are working on linux so any way through jdbc
Just as a sidenote: JDBC vs OBDC is not necessarily a question of the OS; both JDBC and ODBC are available and supported on various OSs, among which Windows and Linux (there is UnixODBC for Linux).
Can we get the debugger output through jdbc
Which debugger and/or debugger output are you referring to / talking about? Or in other words, what do you want to debug? Your JDBC client? The JDBC driver? The MonetDB server? The MonetDB kernel? Stefan
You can enable the ODBC debug output by your ODBC configuration.
For example:
Trace = Yes TraceFile = /tmp/debug.log ForceTrace = Yes
Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEAREKAAYFAkudHEYACgkQYH1+F2Rqwn2n1ACeJkxR8di3h1McltuRXsDZRxri V9UAoIchyOqm2pqGDrCWITtWUJngAkhg =Qz4/ -----END PGP SIGNATURE-----
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 | The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 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-----
participants (2)
-
anshul gangwar -
Stefan de Konink