Re: Bizarre replication delays
Posted by:
Irfan Ali
Date: December 07, 2011 11:30PM
Record is totally neglected or insert after delay on db1 ?
If record is not inserting on db1 than might be your insert query is bigger than allowed packet size. If that's the case try increasing it on db1.
Also, check Read_Master_Log_Pos & Exec_Master_Log_Pos values are changing on db1 or not. Check error logs on both gw8 and db1.
Check slave_net_timeout variable value if it set it to default, minimize it 30-60 seconds is OK. Also check for slave_load_tmpdir & tmpdir has enough space or not.
Subject
Views
Written By
Posted
1941
December 06, 2011 05:03PM
1101
December 07, 2011 04:00PM
Re: Bizarre replication delays
900
December 07, 2011 11:30PM
918
December 08, 2011 08:49AM
779
December 08, 2011 01:32PM
619
December 08, 2011 02:06PM
779
December 09, 2011 12:22PM
861
December 09, 2011 12:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.