From: Johan De Meersman Date: September 10 2010 1:38pm Subject: Re: Replaying the mysqld.log file from production onto QA??? List-Archive: http://lists.mysql.com/mysql/222927 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000325575efeb3e79d048fe7dcbc --000325575efeb3e79d048fe7dcbc Content-Type: text/plain; charset=ISO-8859-1 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 --000325575efeb3e79d048fe7dcbc--