slave low speed in replication
Posted by:
h ch
Date: March 29, 2010 01:02AM
i do not know why
from slave
Read_Master_Log_Pos: 26060892
Exec_Master_Log_Pos: 24607963
change operation for master
| Com_insert | 115368 |
| Com_delete | 59314 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Uptime | 329719 |
and for slave
| Com_insert | 79462 |
| Com_delete | 94723 |
| Com_replace | 39388 |
| Com_replace_select | 115399 |
| Uptime | 238918 |
slave have one table with several triggers do replace operation
so, as u see Com_replace is very high
i do not know if the triggers will cause the problem,because i have modified the trigger last week ,which execute time is 8 min ,so i rewrite the trigger ,now it run very faster
Subject
Views
Written By
Posted
slave low speed in replication
3192
March 29, 2010 01:02AM
1861
March 30, 2010 08:28AM
1793
March 30, 2010 06:43PM
1493
March 30, 2010 09:48PM
1680
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.