List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 10 2010 2:00pm
Subject:RE: Replaying the mysqld.log file from production onto QA???
View as plain text  
If possible, use web server logging to get the timings.

As I explained in my previous essay, this is not at all simple or easy.

If you run a benchmark more than once, be sure to reboot the system between 
runs.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com

>-----Original Message-----
>From: Shawn Green (MySQL) [mailto:shawn.l.green@stripped]
>Sent: Friday, September 10, 2010 7:56 AM
>To: Johan De Meersman
>Cc: Nunzio Daveri; andrew.2.moore@stripped; mysql@stripped
>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 
>> <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
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




Thread
Replaying the mysqld.log file from production onto QA???Nunzio Daveri8 Sep
  • Re: Replaying the mysqld.log file from production onto QA???Baron Schwartz10 Sep
Re: Replaying the mysqld.log file from production onto QA???andrew.2.moore8 Sep
  • Re: Replaying the mysqld.log file from production onto QA???Nunzio Daveri9 Sep
    • Re: Replaying the mysqld.log file from production onto QA???Johan De Meersman10 Sep
      • Re: Replaying the mysqld.log file from production onto QA???MySQL)10 Sep
        • Re: Replaying the mysqld.log file from production onto QA???Johan De Meersman10 Sep
          • Re: Replaying the mysqld.log file from production onto QA???Johnny Withers10 Sep
        • RE: Replaying the mysqld.log file from production onto QA???Jerry Schwartz10 Sep