使用 OMS 迁移Postgresql 数据到 OBMysql租户时的CPU负载过高

KOMODO · 2025 年6 月 25 日 18:31

【使用环境】测试环境
【 OB or 其他组件】OMS
【使用版本】4.2.9_CE
【问题描述】通过OMS 配置增量同步的方式将postgresql 15部分表的数据实时迁移到OceanBase_CE 4.3.5.0 。
虽然任务配置的是 2 读 2 写内存配置了 2～3G。
但是当出现大批量数据更新时，容器的 cpu使用会瞬间升高，最高达到过 1800～2000%。
想知道这部分的 cpu 是哪个组件导致的？是否有参数可以配置？
以下是部分测试环境的 docker stats 信息

CONTAINER ID NAME 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 5182b0065b4d OMS_429_20250624 CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS
581.78% 946.2MiB / 187.4GiB 0.49% 0B / 0B 463MB / 1.01GB 393
581.78% 1.643GiB / 187.4GiB 0.88% 0B / 0B 463MB / 1.01GB 393
581.78% 1.643GiB / 187.4GiB 0.88% 0B / 0B 463MB / 1.01GB 393
673.67% 1.643GiB / 187.4GiB 0.88% 0B / 0B 464MB / 1.01GB 398
673.67% 1.643GiB / 187.4GiB 0.88% 0B / 0B 464MB / 1.01GB 398
673.67% 1.643GiB / 187.4GiB 0.88% 0B / 0B 464MB / 1.01GB 398
775.75% 2.33GiB / 187.4GiB 1.24% 0B / 0B 465MB / 1.01GB 399
775.75% 2.33GiB / 187.4GiB 1.24% 0B / 0B 465MB / 1.01GB 399
775.75% 2.33GiB / 187.4GiB 1.24% 0B / 0B 465MB / 1.01GB 399
1200.79% 2.824GiB / 187.4GiB 1.51% 0B / 0B 467MB / 1.01GB 402
1200.79% 2.824GiB / 187.4GiB 1.51% 0B / 0B 467MB / 1.01GB 402
1200.79% 2.824GiB / 187.4GiB 1.51% 0B / 0B 467MB / 1.01GB 402
1802.30% 3.192GiB / 187.4GiB 1.70% 0B / 0B 468MB / 1.01GB 407
1802.30% 3.192GiB / 187.4GiB 1.70% 0B / 0B 468MB / 1.01GB 407
1802.30% 3.192GiB / 187.4GiB 1.70% 0B / 0B 468MB / 1.01GB 407
1205.16% 3.614GiB / 187.4GiB 1.93% 0B / 0B 473MB / 1.01GB 409
1205.16% 3.614GiB / 187.4GiB 1.93% 0B / 0B 473MB / 1.01GB 409
1205.16% 3.614GiB / 187.4GiB 1.93% 0B / 0B 473MB / 1.01GB 409
1296.07% 3.93GiB / 187.4GiB 2.10% 0B / 0B 473MB / 1.01GB 411
1296.07% 3.93GiB / 187.4GiB 2.10% 0B / 0B 473MB / 1.01GB 411
1296.07% 3.93GiB / 187.4GiB 2.10% 0B / 0B 473MB / 1.01GB 411
1296.07% 3.93GiB / 187.4GiB 2.10% 0B / 0B 473MB / 1.01GB 411
2019.36% 4.25GiB / 187.4GiB 2.27% 0B / 0B 473MB / 1.01GB 423
2019.36% 4.25GiB / 187.4GiB 2.27% 0B / 0B 473MB / 1.01GB 423
2019.36% 4.25GiB / 187.4GiB 2.27% 0B / 0B 473MB / 1.01GB 423
2279.45% 4.614GiB / 187.4GiB 2.46% 0B / 0B 474MB / 1.01GB 426
2279.45% 4.614GiB / 187.4GiB 2.46% 0B / 0B 474MB / 1.01GB 426
2279.45% 4.614GiB / 187.4GiB 2.46% 0B / 0B 474MB / 1.01GB 426
1869.40% 4.715GiB / 187.4GiB 2.52% 0B / 0B 474MB / 1.01GB 440
1869.40% 4.715GiB / 187.4GiB 2.52% 0B / 0B 474MB / 1.01GB 440
1869.40% 4.715GiB / 187.4GiB 2.52% 0B / 0B 474MB / 1.01GB 440
301.22% 4.721GiB / 187.4GiB 2.52% 0B / 0B 474MB / 1.01GB 440
301.22% 4.721GiB / 187.4GiB 2.52% 0B / 0B 474MB / 1.01GB 440
301.22% 4.721GiB / 187.4GiB 2.52% 0B / 0B 474MB / 1.01GB 440
477.77% 4.752GiB / 187.4GiB 2.54% 0B / 0B 475MB / 1.01GB 447
477.77% 4.752GiB / 187.4GiB 2.54% 0B / 0B 475MB / 1.01GB 447

5182b0065b4d OMS_429_20250624 93.73% 6.165GiB / 187.4GiB 3.29% 0B / 0B 3.17GB / 1.04GB 721
5182b0065b4d OMS_429_20250624 93.73% 6.165GiB / 187.4GiB 3.29% 0B / 0B 3.17GB / 1.04GB 721
5182b0065b4d OMS_429_20250624 406.89% 6.304GiB / 187.4GiB 3.36% 0B / 0B 3.17GB / 1.04GB 728
5182b0065b4d OMS_429_20250624 406.89% 6.304GiB / 187.4GiB 3.36% 0B / 0B 3.17GB / 1.04GB 728
5182b0065b4d OMS_429_20250624 406.89% 6.304GiB / 187.4GiB 3.36% 0B / 0B 3.17GB / 1.04GB 728
5182b0065b4d OMS_429_20250624 1553.32% 6.607GiB / 187.4GiB 3.53% 0B / 0B 3.17GB / 1.05GB 721
5182b0065b4d OMS_429_20250624 1553.32% 6.607GiB / 187.4GiB 3.53% 0B / 0B 3.17GB / 1.05GB 721
5182b0065b4d OMS_429_20250624 1553.32% 6.607GiB / 187.4GiB 3.53% 0B / 0B 3.17GB / 1.05GB 721
5182b0065b4d OMS_429_20250624 859.09% 6.62GiB / 187.4GiB 3.53% 0B / 0B 3.17GB / 1.05GB 722
5182b0065b4d OMS_429_20250624 859.09% 6.62GiB / 187.4GiB 3.53% 0B / 0B 3.17GB / 1.05GB 722
5182b0065b4d OMS_429_20250624 859.09% 6.62GiB / 187.4GiB 3.53% 0B / 0B 3.17GB / 1.05GB 722
5182b0065b4d OMS_429_20250624 859.09% 6.62GiB / 187.4GiB 3.53% 0B / 0B 3.17GB / 1.05GB 722
5182b0065b4d OMS_429_20250624 732.23% 6.666GiB / 187.4GiB 3.56% 0B / 0B 3.17GB / 1.06GB 738
5182b0065b4d OMS_429_20250624 732.23% 6.666GiB / 187.4GiB 3.56% 0B / 0B 3.17GB / 1.06GB 738
5182b0065b4d OMS_429_20250624 732.23% 6.666GiB / 187.4GiB 3.56% 0B / 0B 3.17GB / 1.06GB 738
5182b0065b4d OMS_429_20250624 826.65% 6.785GiB / 187.4GiB 3.62% 0B / 0B 3.23GB / 1.07GB 721
5182b0065b4d OMS_429_20250624 826.65% 6.785GiB / 187.4GiB 3.62% 0B / 0B 3.23GB / 1.07GB 721
5182b0065b4d OMS_429_20250624 826.65% 6.785GiB / 187.4GiB 3.62% 0B / 0B 3.23GB / 1.07GB 721
5182b0065b4d OMS_429_20250624 851.33% 6.928GiB / 187.4GiB 3.70% 0B / 0B 3.26GB / 1.07GB 757
5182b0065b4d OMS_429_20250624 851.33% 6.928GiB / 187.4GiB 3.70% 0B / 0B 3.26GB / 1.07GB 757
5182b0065b4d OMS_429_20250624 851.33% 6.928GiB / 187.4GiB 3.70% 0B / 0B 3.26GB / 1.07GB 757
5182b0065b4d OMS_429_20250624 716.69% 6.861GiB / 187.4GiB 3.66% 0B / 0B 4.19GB / 1.09GB 722