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 that when the cron is running, the changes made to this table
> don't replicate properly to slave DB. Anyone has same experience? I
> checked 'show slave status' but no Last_error or Last_errno was found.

Define properly?

Jeff


pgpLp7xvfln8d.pgp
Description: PGP signature

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` int(10) unsigned NOT NULL default '0',
  `new` enum('y','n','replied') NOT NULL default 'y',
  `datetime` datetime default NULL,
  KEY `idx_1` (`member_id`,`new`),
  KEY `idx_2` (`member_id`,`datetime`)
) TYPE=InnoDB 

This table has about 2789678 rows.

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 that when the cron is running, the changes made to this table
don't replicate properly to slave DB. Anyone has same experience? I
checked 'show slave status' but no Last_error or Last_errno was found.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]