OGG进程中断Time Since Chkpt 50个小时后,解决报错后GERRH恩特好条

正常情况下,OGG遇到异常报错,导致OGG进程中断Time Since Chkpt 50个小时后,解决报错后,启动该进程,一般来说2分内,会执行成功最少一个事务,会写入新的检查点,延迟的50个小时,会自动转换为lag at chkpt 50小时延迟。

异常情况或者说需要优化调整的情况是,启动进程,发现time since chkpt 延迟一直递增,不减少。说明存在事务未执行完毕。
实际遇到的情况1,进程同步4个表,其中一个表很大10G,并且目标端无主键!!!

因此目标端执行一条update sql执行效率非常低。 如何处理???
http://www.kuwo.cn/playlist_detail/1387709226
http://www.kuwo.cn/playlist_detail/448180487
http://www.kuwo.cn/playlist_detail/880901106
http://www.kuwo.cn/playlist_detail/1547779898
http://www.kuwo.cn/playlist_detail/1387773201
http://www.kuwo.cn/playlist_detail/767192681
http://www.kuwo.cn/playlist_detail/1430060176
http://www.kuwo.cn/playlist_detail/38709641
http://www.kuwo.cn/playlist_detail/235215267
http://www.kuwo.cn/playlist_detail/1532376722
http://www.kuwo.cn/playlist_detail/1754826422
http://www.kuwo.cn/playlist_detail/1377874581
http://www.kuwo.cn/playlist_detail/474481195
http://www.kuwo.cn/playlist_detail/1010398698
http://www.kuwo.cn/playlist_detail/256858199
http://www.kuwo.cn/playlist_detail/1673800532
http://www.kuwo.cn/playlist_detail/370763673
http://www.kuwo.cn/playlist_detail/672881967
http://www.kuwo.cn/playlist_detail/1716972306
http://www.kuwo.cn/playlist_detail/373788079
http://www.kuwo.cn/playlist_detail/951530554
http://www.kuwo.cn/playlist_detail/597355453
http://www.kuwo.cn/playlist_detail/1547542684
http://www.kuwo.cn/playlist_detail/1716838566
http://www.kuwo.cn/playlist_detail/1566797679
http://www.kuwo.cn/playlist_detail/1670480420
http://www.kuwo.cn/playlist_detail/456602395
http://www.kuwo.cn/playlist_detail/1911868696
http://www.kuwo.cn/playlist_detail/1646273196
http://www.kuwo.cn/playlist_detail/437560039
http://www.kuwo.cn/playlist_detail/1573010494
http://www.kuwo.cn/playlist_detail/1427999238
http://www.kuwo.cn/playlist_detail/1664588464
http://www.kuwo.cn/playlist_detail/1453630187
http://www.kuwo.cn/playlist_detail/1454474276
http://www.kuwo.cn/playlist_detail/1664105234
http://www.kuwo.cn/playlist_detail/890081038
http://www.kuwo.cn/playlist_detail/385881507
http://www.kuwo.cn/playlist_detail/1454485880
http://www.kuwo.cn/playlist_detail/431589721
http://www.kuwo.cn/playlist_detail/1326565008
http://www.kuwo.cn/playlist_detail/1357844536
http://www.kuwo.cn/playlist_detail/1637164060
http://www.kuwo.cn/playlist_detail/1709209092
http://www.kuwo.cn/playlist_detail/566944625
http://www.kuwo.cn/playlist_detail/767215585
http://www.kuwo.cn/playlist_detail/291663213
http://www.kuwo.cn/playlist_detail/284650961
http://www.kuwo.cn/playlist_detail/2054857332
http://www.kuwo.cn/playlist_detail/572889605
http://www.kuwo.cn/playlist_detail/1641258313
http://www.kuwo.cn/playlist_detail/1353691518
http://www.kuwo.cn/playlist_detail/1658056590
http://www.kuwo.cn/playlist_detail/1448845649
http://www.kuwo.cn/playlist_detail/1642182526
http://www.kuwo.cn/playlist_detail/1455515798
http://www.kuwo.cn/playlist_detail/927702470
http://www.kuwo.cn/playlist_detail/1759135890
http://www.kuwo.cn/playlist_detail/620249441
http://www.kuwo.cn/playlist_detail/1327313119
http://www.kuwo.cn/playlist_detail/1385598018
http://www.kuwo.cn/playlist_detail/2088617102
http://www.kuwo.cn/playlist_detail/1331308272
http://www.kuwo.cn/playlist_detail/1441546208
http://www.kuwo.cn/playlist_detail/2064878180
http://www.kuwo.cn/playlist_detail/763682675
http://www.kuwo.cn/playlist_detail/1383085270
http://www.kuwo.cn/playlist_detail/1324139744
http://www.kuwo.cn/playlist_detail/1719717094
http://www.kuwo.cn/playlist_detail/1561847800
http://www.kuwo.cn/playlist_detail/355493023
http://www.kuwo.cn/playlist_detail/2134296559
http://www.kuwo.cn/playlist_detail/1386321520
http://www.kuwo.cn/playlist_detail/796317385
http://www.kuwo.cn/playlist_detail/777533135
http://www.kuwo.cn/playlist_detail/1351714969
http://www.kuwo.cn/playlist_detail/1671731057
http://www.kuwo.cn/playlist_detail/1645077701
http://www.kuwo.cn/playlist_detail/1626177454
http://www.kuwo.cn/playlist_detail/1549515592
http://www.kuwo.cn/playlist_detail/749372729
http://www.kuwo.cn/playlist_detail/1706215716
http://www.kuwo.cn/playlist_detail/1361710632
http://www.kuwo.cn/playlist_detail/312661361
http://www.kuwo.cn/playlist_detail/1497420824
http://www.kuwo.cn/playlist_detail/1370066860
http://www.kuwo.cn/playlist_detail/747732327
http://www.kuwo.cn/playlist_detail/425208273
http://www.kuwo.cn/playlist_detail/892579580
http://www.kuwo.cn/playlist_detail/1706674612
http://www.kuwo.cn/playlist_detail/319597415
http://www.kuwo.cn/playlist_detail/1589744098
http://www.kuwo.cn/playlist_detail/1445495682
http://www.kuwo.cn/playlist_detail/997711394
http://www.kuwo.cn/playlist_detail/396118567
http://www.kuwo.cn/playlist_detail/1506401656
http://www.kuwo.cn/playlist_detail/1675254438
http://www.kuwo.cn/playlist_detail/1552262034
http://www.kuwo.cn/playlist_detail/1544809688
http://www.kuwo.cn/playlist_detail/366862953
http://www.kuwo.cn/playlist_detail/1087499602
http://www.kuwo.cn/playlist_detail/1552003562
http://www.kuwo.cn/playlist_detail/745437117
http://www.kuwo.cn/playlist_detail/168086839
http://www.kuwo.cn/playlist_detail/1448638290
http://www.kuwo.cn/playlist_detail/45165215
http://www.kuwo.cn/playlist_detail/1761164990
http://www.kuwo.cn/playlist_detail/1548934332
http://www.kuwo.cn/playlist_detail/1927749020
http://www.kuwo.cn/playlist_detail/274481917
http://www.kuwo.cn/playlist_detail/1645276404
http://www.kuwo.cn/playlist_detail/313892923
http://www.kuwo.cn/playlist_detail/1502310726
http://www.kuwo.cn/playlist_detail/350316621
http://www.kuwo.cn/playlist_detail/271543139
http://www.kuwo.cn/playlist_detail/1437577490
http://www.kuwo.cn/playlist_detail/1709845230
http://www.kuwo.cn/playlist_detail/1580042100
http://www.kuwo.cn/playlist_detail/1373621432
http://www.kuwo.cn/playlist_detail/1581032870
http://www.kuwo.cn/playlist_detail/983782844
http://www.kuwo.cn/playlist_detail/1389625104
http://www.kuwo.cn/playlist_detail/884700370
http://www.kuwo.cn/playlist_detail/250273221
http://www.kuwo.cn/playlist_detail/1665068538
http://www.kuwo.cn/playlist_detail/457593059
http://www.kuwo.cn/playlist_detail/263309623
http://www.kuwo.cn/playlist_detail/1366670240
http://www.kuwo.cn/playlist_detail/1428734302
http://www.kuwo.cn/playlist_detail/374638997
http://www.kuwo.cn/playlist_detail/990141888
http://www.kuwo.cn/playlist_detail/230751773
http://www.kuwo.cn/playlist_detail/1647142862
http://www.kuwo.cn/playlist_detail/1004061432
http://www.kuwo.cn/playlist_detail/1361581848
http://www.kuwo.cn/playlist_detail/2102670716
http://www.kuwo.cn/playlist_detail/306462335
http://www.kuwo.cn/playlist_detail/1960323650
http://www.kuwo.cn/playlist_detail/1602117905
http://www.kuwo.cn/playlist_detail/1552599544
http://www.kuwo.cn/playlist_detail/1427974215
http://www.kuwo.cn/playlist_detail/1554738670
http://www.kuwo.cn/playlist_detail/1449021422
http://www.kuwo.cn/playlist_detail/1619572960
http://www.kuwo.cn/playlist_detail/1356706468
http://www.kuwo.cn/playlist_detail/1392551942
http://www.kuwo.cn/playlist_detail/1434703277
http://www.kuwo.cn/playlist_detail/447187123
http://www.kuwo.cn/playlist_detail/1327301794
http://www.kuwo.cn/playlist_detail/2008629764
http://www.kuwo.cn/playlist_detail/898189254
http://www.kuwo.cn/playlist_detail/308935795
http://www.kuwo.cn/playlist_detail/429879417
http://www.kuwo.cn/playlist_detail/798772217
http://www.kuwo.cn/playlist_detail/628799925
http://www.kuwo.cn/playlist_detail/1330547854
http://www.kuwo.cn/playlist_detail/1632586018
http://www.kuwo.cn/playlist_detail/1625776280
http://www.kuwo.cn/playlist_detail/436680237
http://www.kuwo.cn/playlist_detail/1542596620
http://www.kuwo.cn/playlist_detail/1667847082
http://www.kuwo.cn/playlist_detail/2095951840
http://www.kuwo.cn/playlist_detail/1498236479
http://www.kuwo.cn/playlist_detail/2126001956
http://www.kuwo.cn/playlist_detail/1556417926
http://www.kuwo.cn/playlist_detail/1423813448
http://www.kuwo.cn/playlist_detail/1562545456
http://www.kuwo.cn/playlist_detail/1639122035
http://www.kuwo.cn/playlist_detail/1324290986
http://www.kuwo.cn/playlist_detail/443640159
http://www.kuwo.cn/playlist_detail/902867188
http://www.kuwo.cn/playlist_detail/1368347460
http://www.kuwo.cn/playlist_detail/268754545
http://www.kuwo.cn/playlist_detail/2120492889
http://www.kuwo.cn/playlist_detail/1542241232
http://www.kuwo.cn/playlist_detail/1652993320
http://www.kuwo.cn/playlist_detail/1646820050
http://www.kuwo.cn/playlist_detail/794640823
http://www.kuwo.cn/playlist_detail/893010695
http://www.kuwo.cn/playlist_detail/1437735882
http://www.kuwo.cn/playlist_detail/1559967270
http://www.kuwo.cn/playlist_detail/1355273950
http://www.kuwo.cn/playlist_detail/1714566948
http://www.kuwo.cn/playlist_detail/1428905663
http://www.kuwo.cn/playlist_detail/1400920748
http://www.kuwo.cn/playlist_detail/1031289950
http://www.kuwo.cn/playlist_detail/1379107684
http://www.kuwo.cn/playlist_detail/1373740052
http://www.kuwo.cn/playlist_detail/796352439
http://www.kuwo.cn/playlist_detail/1604194672
http://www.kuwo.cn/playlist_detail/2086802942
http://www.kuwo.cn/playlist_detail/1437372410
http://www.kuwo.cn/playlist_detail/1571957930
http://www.kuwo.cn/playlist_detail/1623708496
http://www.kuwo.cn/playlist_detail/1440288482
http://www.kuwo.cn/playlist_detail/1448341266
http://www.kuwo.cn/playlist_detail/450868309
http://www.kuwo.cn/playlist_detail/1367799176
http://www.kuwo.cn/playlist_detail/64097969
http://www.kuwo.cn/playlist_detail/1444812982
http://www.kuwo.cn/playlist_detail/347250513
http://www.kuwo.cn/playlist_detail/747691307
http://www.kuwo.cn/playlist_detail/1439696810
http://www.kuwo.cn/playlist_detail/806692219
http://www.kuwo.cn/playlist_detail/360822883
http://www.kuwo.cn/playlist_detail/1670609626
http://www.kuwo.cn/playlist_detail/1716267880
http://www.kuwo.cn/playlist_detail/1319025056
http://www.kuwo.cn/playlist_detail/1538648531
http://www.kuwo.cn/playlist_detail/7647995
http://www.kuwo.cn/playlist_detail/1558341762
http://www.kuwo.cn/playlist_detail/1327786402
http://www.kuwo.cn/playlist_detail/1546385416
http://www.kuwo.cn/playlist_detail/1561968972
http://www.kuwo.cn/playlist_detail/2061912900
http://www.kuwo.cn/playlist_detail/270529949
http://www.kuwo.cn/playlist_detail/1662223948
http://www.kuwo.cn/playlist_detail/1637081074
http://www.kuwo.cn/playlist_detail/1366835960
http://www.kuwo.cn/playlist_detail/1634093165
http://www.kuwo.cn/playlist_detail/1422590448
http://www.kuwo.cn/playlist_detail/1353581680
http://www.kuwo.cn/playlist_detail/1331621130
http://www.kuwo.cn/playlist_detail/1459751476
http://www.kuwo.cn/playlist_detail/1561438846
http://www.kuwo.cn/playlist_detail/431557531
http://www.kuwo.cn/playlist_detail/1456543708
http://www.kuwo.cn/playlist_detail/928450738
http://www.kuwo.cn/playlist_detail/234381405
http://www.kuwo.cn/playlist_detail/270665141
http://www.kuwo.cn/playlist_detail/1648841650
http://www.kuwo.cn/playlist_detail/1555569769
http://www.kuwo.cn/playlist_detail/310384155
http://www.kuwo.cn/playlist_detail/1527721824
http://www.kuwo.cn/playlist_detail/1073273058
http://www.kuwo.cn/playlist_detail/371173859
http://www.kuwo.cn/playlist_detail/1626908572
http://www.kuwo.cn/playlist_detail/1355178702
http://www.kuwo.cn/playlist_detail/1510665834
http://www.kuwo.cn/playlist_detail/505904799
http://www.kuwo.cn/playlist_detail/2032707514
http://www.kuwo.cn/playlist_detail/1555018348
http://www.kuwo.cn/playlist_detail/1448261550
http://www.kuwo.cn/playlist_detail/1713354632
http://www.kuwo.cn/playlist_detail/1315004030
http://www.kuwo.cn/playlist_detail/1632385702
http://www.kuwo.cn/playlist_detail/430384291
http://www.kuwo.cn/playlist_detail/526916019
http://www.kuwo.cn/playlist_detail/1536879260
http://www.kuwo.cn/playlist_detail/1352569978
http://www.kuwo.cn/playlist_detail/426791671
http://www.kuwo.cn/playlist_detail/1556502673
http://www.kuwo.cn/playlist_detail/1363763786
http://www.kuwo.cn/playlist_detail/273486879
http://www.kuwo.cn/playlist_detail/1360133408
http://www.kuwo.cn/playlist_detail/308445899
http://www.kuwo.cn/playlist_detail/350054349
http://www.kuwo.cn/playlist_detail/1452254576
http://www.kuwo.cn/playlist_detail/1455554606
http://www.kuwo.cn/playlist_detail/797771569
http://www.kuwo.cn/playlist_detail/1504783042
http://www.kuwo.cn/playlist_detail/1572781677
http://www.kuwo.cn/playlist_detail/745406475
http://www.kuwo.cn/playlist_detail/2048214822

上一篇:微信公众号与HTML 5混合模式揭秘2——分享手机相册中照片


下一篇:oracle 数据库备份