Unanswered: Log specific query types (or transactions)
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?