I've been given the task of tuning up a MySQL database on a production server. While messing around with some different things I noticed that we have a large of amount of transactions being rolled back (Com_rollback).

*Is there a way to have it log just transactions that were rolled back? Or just UPDATES, DELETES, and INSERTS?

*Do I just have to turn on logging and parse all the queries? If I log all queries will there be a way for me to differentiate the rolled back transactions from the rest of the queries?

Thanks in advance for any help you can provide.

-Paco