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

2010-09-10 Thread Baron Schwartz
The mysqld.log isn't in an executable format, but mk-query-digest can understand it and convert it into a "slow query log" format. Then you can use mk-upgrade to validate that your queries produce the same result. Good for you for thinking to do this -- most people just upgrade and then panic whe

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

2010-09-10 Thread Johnny Withers
Would something like: http://www.maatkit.org/doc/mk-log-player.html Work? I know the timings won't be the same as how the queries actually came in, but it could be a start, JW On Fri, Sep 10, 2010 at 8:38 AM, Johan De Meersman wrote: > On Fri

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

2010-09-10 Thread Jerry Schwartz
ri; andrew.2.mo...@nokia.com; mysql@lists.mysql.com >Subject: Re: Replaying the mysqld.log file from production onto QA??? > >Hello Johan, > >On 9/10/2010 7:47 AM, Johan De Meersman wrote: >> On Thu, Sep 9, 2010 at 4:12 PM, Nunzio Daveri >> wrote: >> >>> So.. I am t

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

2010-09-10 Thread Johan De Meersman
On Fri, Sep 10, 2010 at 1:56 PM, Shawn Green (MySQL) < shawn.l.gr...@oracle.com> 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

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

2010-09-10 Thread Shawn Green (MySQL)
Hello Johan, On 9/10/2010 7:47 AM, Johan De Meersman wrote: On Thu, Sep 9, 2010 at 4:12 PM, Nunzio Daveri 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

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

2010-09-10 Thread Johan De Meersman
l.com > 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" > Date: Wed, Sep 8, 2010 19:25 > Subject: Repla

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

2010-09-09 Thread Nunzio Daveri
From: "andrew.2.mo...@nokia.com" To: nunziodav...@yahoo.com; mysql@lists.mysql.com 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&q

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

2010-09-08 Thread andrew.2.moore
Try using a mysqldump. - Reply message - From: "ext Nunzio Daveri" Date: Wed, Sep 8, 2010 19:25 Subject: Replaying the mysqld.log file from production onto QA??? To: "mysql@lists.mysql.com" Hello all, I am trying to "REPLAY" the mysqld.log file from a pro

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

2010-09-08 Thread Nunzio Daveri
Hello all, I am trying to "REPLAY" the mysqld.log file from a production 5.1.4 server onto a QA server with 5.5 running and was wondering if there is an easy way of replaying the mysqld.log file? Just want to make sure all of the kinds of inserts, updates, selects and deletes work just as well