[Monetdb-developers] slow query log
Fabian.Groffen at cwi.nl
Tue Oct 21 11:01:32 CEST 2008
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 
> > 2) mapi_log(...) 
> 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 ?
More information about the developers-list