I have a simple Master-Slave replication set up, but Slave keeps falling behind do to what appears to be a simple checkout system. Master can keep up because it runs multi-threaded, but since the checkout is on a single table on a single database, the slave cannot multi-thread to catch up.
Consequently my binary logs are full of queries like:
UPDATE db.foo SET process_id = 123 WHERE id = 456 AND process_id IS NULL;
UPDATE db.foo SET process_id = 234 WHERE id = 567 AND process_id IS NULL;
I've analyzed the
general_log (turned on slave temporarily) to estimate 9/10 queries are a regex of the above query.
- Can I prevent these queries from being logged? How?
- Can I scrub them from log before it's relayed to slave? How?
- Any other suggestion?