21 Oct
2008
21 Oct
'08
9:01 a.m.
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:
- ODBCDEBUG [1]
- 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.h...