MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: slave low speed in replication
Posted by: h ch
Date: March 30, 2010 06:43PM

yes the trigger still is the trouble-maker ,the trigger on slave cause a lot of lock time,that's the reason that slave can not catch with the master.

BTW,the SlowLog write the SELECT query ,and how can i know the INSERT/UPDATE/REPLACE/DELETE query fro slowlog?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
slave low speed in replication
3235
h ch
March 29, 2010 01:02AM
Re: slave low speed in replication
1887
Rick James
March 30, 2010 08:28AM
Re: slave low speed in replication
1811
h ch
March 30, 2010 06:43PM
Re: slave low speed in replication
1518
Rick James
March 30, 2010 09:48PM
Re: slave low speed in replication
1704
h ch
March 31, 2010 01:05AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.