I have a replication setup running which gets stuck on a master log sequence of deleting rows from the heatmaps table “log_hsr_event”. I’m not 100% sure if that’s the only table that is affected. This table has no PRIMARY key. I deleted a heatmap that leads to a lot of deletes in this (and probably other heatmap) table(s).
With Binlog-Format ROW or (probably also) MIXED, deletes from a table without PRIMARY key leads to excessive table scans on every deletion, so deleting a single row takes more than 10 minutes which stalls the replication (Seconds_Behind_Master: 866279).
Would it be possible to introduce one for the tables without a primary key?