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

[Jerry Schwartz]

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: [phone]
E-mail: ***@gii.co.jp
Web site: www.the-infoshop.com

-----Original Message-----
Sent: Friday, September 10, 2010 7:56 AM
To: Johan De Meersman
Subject: Re: Replaying the mysqld.log file from production onto QA???
Hello Johan,

On Thu, Sep 9, 2010 at 4:12 PM, Nunzio Daveri

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

[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 when something doesn't work right.

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 on the 5.5 box, esp
since we are turning on replication and copying tables from another server onto
this server.  Any ideas please?
TIA...
Nunzio