Re: Replaying the mysqld.log file from production onto QA???

[Johan De Meersman]

On Fri, Sep 10, 2010 at 1:56 PM, Shawn Green (MySQL) <
shawn.l.green@stripped> wrote:

> 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?
>

Alas, no. I suspect the rather expensive Avalanches we got might be able to,
but that's not particularly helpful to him :-)

I wrote a little thing many years ago that pulled Apache logs from
production over SSH and multithreaded them at the staging server, but SQL
stuff would be much more time-critical - can't select before the insert :-)



-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel