Re: Replication doesn't work under heavy load

2004-10-04 Thread Jeff Smelser
On Monday 04 October 2004 01:18 am, Batara Kesuma wrote: > I have a cron running this every night. > DELETE message_inbox FROM message_inbox LEFT JOIN message ON message.id > = message_inbox.message_id WHERE message.id IS NULL > > Message table also has about the same amount of rows. > > I notice t

Replication doesn't work under heavy load

2004-10-03 Thread Batara Kesuma
Hi, I just noticed that replication on my servers failed when they were under heavy load. I have 1 master and 2 slaves. For example, I have table for all incoming messages. message_inbox | CREATE TABLE `message_inbox` ( `member_id` mediumint(8) unsigned NOT NULL default '0', `message_id` in