Since playing back binary logs is just like doing normal queries the
tips on this page mostly apply.
http://dev.mysql.com/doc/mysql/en/insert-speed.html
Depending on your shell scripting level you might have to mysqlbinlog
to a file then
add in lock statments or whatever you decide to use.
-Eric
I was running a table in InnoDB, and the table had about 6 indexes, none
of which seemed to be affected when I ran mysqlbinlog against the tables
in order to apply bin-logs from production against a test system. I was
manage to process upwards of 2300 queries per second by throwing about
1.8 GB of
