【 使用环境 】
生产环境
【 OB or 其他组件 】
oblogproxy oracle模式
【 使用版本 】
OceanBase企业版3.2.4，oblogproxy-2.3.0，oracle模式
【问题描述】
oblogproxy启动后，flink-cdc同步50张表增量数据，oblogproxy所在主机cpu占用极高，主机cpu 128核，表数据量在10w-2000w不等
oblogproxy配置conf/conf.json：
{
“service_port”: 2983,
“encode_threadpool_size”: 8,
“encode_queue_size”: 20000,
“max_packet_bytes”: 67108864,
“record_queue_size”: 20000,
“read_timeout_us”: 2000000,
“read_fail_interval_us”: 1000000,
“read_wait_num”: 20000,
“send_timeout_us”: 2000000,
“send_fail_interval_us”: 1000000,
“check_quota_enable”: false,
“check_clog_enable”: true,
“command_timeout_s”: 10,
“log_quota_size_mb”: 5120,
“log_quota_day”: 7,
“log_gc_interval_s”: 43200,
“log_level”: 2,
“loh_flush_strategy”: 1,
“log_flush_level”: 2,
“log_flush_period_s”: 1,
“log_max_file_size_mb”: 1024,
“log_retention_h”: 360,
“oblogreader_path_retain_hour”: 168,
“oblogreader_lease_s”: 300,
“oblogreader_path”: “./run”,
“bin_path”: “./bin”,
“oblogreader_timezone_conf”: “…/…/conf/timezone_info.conf”,
“oblogreader_obcdc_path_template”: “…/…/obcdc/obcdc-%d.x-access/libobcdc.so”,
“oblogreader_obcdc_ce_path_template”: “…/…/obcdc/obcdc-ce-%d.x-access/libobcdc.so”,
“allow_all_tenant”: true,
“auth_user”: true,
“auth_use_rs”: false,
“auth_allow_sys_user”: true,
“ob_sys_username”: “xxx”,
“ob_sys_password”: “xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”,
“counter_interval_s”: 2,
“metric_enable”: true,
“metric_interval_s”: 10,
“debug”: false,
“verbose”: false,
“verbose_packet”: false,
“verbose_record_read”: false,
“readonly”: false,
“count_record”: false,
“channel_type”: “plain”,
“tls_ca_cert_file”: “”,
“tls_cert_file”: “”,
“tls_key_file”: “”,
“tls_verify_peer”: true,
“liboblog_tls”: false,
“liboblog_tls_cert_path”: “”,
“binlog_log_bin_basename”: “./run”,
“binlog_timezone_conf”: “…/…/…/conf/timezone_info.conf”,
“binlog_obcdc_path_template”: “…/…/…/obcdc/obcdc-%d.x-access/libobcdc.so”,
“binlog_obcdc_ce_path_template”: “…/…/…/obcdc/obcdc-ce-%d.x-access/libobcdc.so”,
“binlog_ignore_unsupported_event”: true,
“binlog_max_event_buffer_bytes”: 67108864,
“binlog_mode”: false,
“table_whitelist”: “”,
“binlog_nof_work_threads”: 16,
“binlog_bc_work_threads”: 2,
“binlog_max_file_size_bytes”: 524288000,
“binlog_convert_timeout_us”: 10000,
“binlog_checksum”: true,
“binlog_heartbeat_interval_us”: 100000,
“binlog_ddl_convert_jvm_options”: “-Djava.class.path=./deps/lib/etransfer.jar|-Xmx256M|-Xtrace|-XX:+CreateMinidumpOnCrash”,
“binlog_ddl_convert_class”: “com/alipay/oms/etransfer/util/OB2MySQLConvertTool”,
“binlog_ddl_convert_func”: “parser”,
“binlog_ddl_convert_func_param”: “(Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String;”,
“binlog_gtid_display”: true,
“binlog_ddl_convert”: true,
“binlog_memory_limit”: “3G”,
“binlog_working_mode”: “storage”
}
【复现路径】问题出现前后相关操作
【问题现象及影响】
oblogproxy服务所在主机因cpu占用过高宕机
【附件】