Hello Johan,
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
> spindles.
>
> 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
load test.
Do you have any techniques you can share?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
