Re: write sets and read sets

Thanks for your response Stewart.

I would like to apologize ahead of time as I'm not familiar with the code yet. Also, my questions where applicable are regarding to the InnoDB or BDB storage engines.

On Thu, 2007-07-05 at 22:08 +1000, Stewart Smith wrote:
> On Wed, 2007-07-04 at 21:58 +0200, Alex Pilchin wrote:
> > Hi,
> > Could someone please tell me some of the ways one can extract the read
> > and write sets for a query or a transaction. I understand using
> > Triggers might be one approach.
>
> You're wanting to know this inside the server or from SQL?

I would like to get information on all potential ways of extracting those read/write sets. It doesn't matter if it's in SQL or inside the server. My only criteria is reasonable efficiency of retrieving this information and simplicity of doing so.

>
> in the handler interface there is read and write sets.

Cool, so I guess that means they are available for use with InnoDB or BDB as well, right?

Cheers,
Alex

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com