Hello Johan,
On 9/10/2010 7:47 AM, Johan De Meersman wrote:
On Thu, Sep 9, 2010 at 4:12 PM, Nunzio Daveri <nunziodav...@yahoo.com>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=arch...@jab.org
