On 9/10/2010 7:47 AM, Johan De Meersman wrote:
> On Thu, Sep 9, 2010 at 4:12 PM, Nunzio Daveri <nunziodaveri@stripped>wrote:
>> So.. I am trying to mimic replaying production like queries so joins, temp
>> tables etc... are stuff I am trying to test as well. Just doing a dump and
>> import is no more than export and importing, I also want to test selects,
>> updates :-) Thanks for replying :-)
> Then you'll have to first activate full logging on your production server.
> This may take quite some diskpace, and IOs, so keep the logfiles on separate
> Extracting the queries from the log shouldn't be all that hard; but there's
> too little timing information in there to do a time-true replay - and I
> don't know of any app that does that, either.
He already did! Those are the logs he needs to replay. He has the logs
already but needs tools to extract the commands and repeat them as a
Do you have any techniques you can share?
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN