Database Replication Breaks Every Week


HammerTime
Member
Registered: 20.02.13 13:54
Timezone: UTC +0
Posts: 5

That might be your problem then. MyISAM uses table-based locks and InnoDB row-based. Maybe you're getting some deadlocks or it's just hanging because it's waiting too long. Try making that table InnoDB too (on the master):

ALTER TABLE download_category_mapping ENGINE=InnoDB;

That may fix your problem. It might also speed up your application too wink.