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.
> From: "andrew.2.moore@stripped" <andrew.2.moore@stripped>
> To: nunziodaveri@stripped; mysql@stripped
> Sent: Wed, September 8, 2010 4:19:19 PM
> Subject: Re: Replaying the mysqld.log file from production onto QA???
> Try using a mysqldump.
> ----- Reply message -----
> From: "ext Nunzio Daveri" <nunziodaveri@stripped>
> Date: Wed, Sep 8, 2010 19:25
> Subject: Replaying the mysqld.log file from production onto QA???
> To: "mysql@stripped" <mysql@stripped>
> Hello all, I am trying to "REPLAY" the mysqld.log file from a production
> server onto a QA server with 5.5 running and was wondering if there is an
> way of replaying the mysqld.log file? Just want to make sure all of the
> of inserts, updates, selects and deletes work just as well on the 5.5 box,
> since we are turning on replication and copying tables from another server
> this server. Any ideas please?
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel