List:General Discussion« Previous MessageNext Message »
From:Sonam Chauhan Date:November 16 2000 3:46am
Subject:Re: Question on detailed logging
View as plain text  
Thank you Philemon! The comments do make their way to the update 
logs... exactly what I needed.

Best regards,
Sonam


Benjamin Pflugmann wrote:
> 
> Hi.
> 
> On Tue, Nov 14, 2000 at 02:44:21PM +1100, sonamc@stripped wrote:
> > sasha@stripped wrote:
> > > Sonam Chauhan wrote:
> [...]
> > I was hoping I could leverage the logs by extending the Database Driver
> <--> MySQL
> > 'conversation' to pass an additional 'comment' parameter on every database
> query
> > executed. This does mean additional coding for the DB API and the MySQL server.
> > but it give admins the capability for fine-grained audits.
> 	
> At least in MySQL 3.22.21, the queries are logged as they are sent to
> the server, i.e. with SQL comments (tested with the update log).
> 
> So you could try to write something like:
> 
> SELECT whatever FROM my_table WHERE any_condition /* user: foobar */
> 
> and grep for '/* user: ' in the log when you want to search for such
> rows. This method surely can extended to whatever you need in detail,
> given comments are still passed to the logs in your version (and in
> future ones).
> 
> Bye,
> 
>         Philemon.
> 
> PS: Either the "internals" or "mysql" list is too much on the CC. I
> just not sure which...

-- 
Sonam Chauhan
Electronic Commerce
Corporate Express Australia Ltd.
Phone: +61-2-9335-0725 Fax: +61-2-9335-0753
Thread
Problems while pre-compilation configureingRobert Wirth24 Mar
  • Problems while pre-compilation configureingMichael Widenius24 Mar
  • Re: Question on detailed loggingsasha13 Nov
  • Re: Question on detailed loggingSonam Chauhan14 Nov
  • Re: Question on detailed loggingsasha14 Nov
  • Re: Question on detailed loggingSonam Chauhan14 Nov
  • Re: Question on detailed loggingSonam Chauhan16 Nov