Database superservice
Egon Willighagen
egonw at sci.kun.nl
Tue Jan 1 12:38:51 CET 2002
On Monday 31 December 2001 19:23, Francis J. Lacoste wrote:
> On Mon, Dec 31, 2001 at 08:49:54AM +0100, Egon Willighagen wrote:
> > So this gives:
> > > > date/time
> > > > user
> > > > remote_host
> > > > action (query, connect, quit, loadDB)
> > > > database
> >
> > kept, seem ok.
>
> Yes.
>
> > > > table
> >
> > dropped.
>
> Yes.
>
> > > > query_type (insert, select, etc...)
> >
> > This becomes "query" giving the full SQL query...
>
> I agree.
>
> > Additional fields are:
> >
> > execution_time
> > no_records
>
> Drop execution_time and execution_time.
>
> Add fields:
>
> success
> result
>
> > Discussion:
> >
> > pid, session_id
>
> Use a connection_id field which contains the "appropriate" "connection
> label" for the backend and that can be used for session analysis in
> conjunction with the timestamp, username and database fields.
Ok, gonna work with this... i'll commit to cvs head, is that ok?
When is the next release planned? To make sure my work does not
interfere with the release schedule...
Egon
--
To UNSUBSCRIBE, email to development-request at logreport.org with a subject of
"unsubscribe". Trouble? Send an email with subject "help" to
development-request at logreport.org
More information about the Development
mailing list