On 21-10-2008 09:50:41 +0200, Martin Kersten wrote: > Stefan de Konink wrote: > > Is there currently a syntax to log every incoming SQL query to a file? > > > > I found options like: > > 1) ODBCDEBUG [1] > > 2) mapi_log(...) [2] > > > mclient links into the Linux history mechanism and logfile may help
That's only for the console input, isn't it? > > But is there something easy to capture all incoming query with their > > timings; so a real slow queries log can be created? > > > If you run from an application, then it is easy to keep the log there. > It includes valuable information about connections too. what about the SQL server's PROFILE capabilities [1]? [1] http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/PROFILE-Statement.html#PROFILE-Statement ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
