Re: Replication server is running behind
Dear Scott,
1) How does your hardware on the slave compare to that of the master? - Same as of Master.
2) Are you using row, statement, or mixed replication format? - Statement Based
3) What is the InnoDB buffer pool size on the slave compared to the master (or key cache if you are using MyISAM)? - Same as of Master (12 GB)
4) Is there any other activity hitting the slave (backups, read-only queries, etc.)? - Yes some read-only queries are running but there is no load.
Please suggest what alternatives we need to take care.
Regards,
Samira Kumar Dash
Subject
Views
Written By
Posted
2355
July 12, 2012 04:43AM
916
July 12, 2012 12:08PM
Re: Replication server is running behind
983
July 13, 2012 01:58AM
1128
July 13, 2012 02:13AM
872
July 14, 2012 08:31AM
1009
July 14, 2012 09:33AM
890
July 15, 2012 11:42AM
953
July 16, 2012 07:49AM
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.