描述
导出多张表的分钟级读写次数等各种监控指标
请求地址
/v2/webservice/report/proxy-stats-min-period
请求方法
Post
请求参数说明
| 字段名 | 字段说明 | 类型 | 是否必填 | 描述 | 参考值 |
|---|---|---|---|---|---|
| set_id | 集群ID | number | 是 | 1 | |
| app_id | 项目ID | number | 是 | 2 | |
| zone_id | 区ID | number | 否 | 为否的时候表示，本项目整个集群下的汇总指标 | 3 |
| proxy_id | 进程ID | string | 否 | 查询具体的进程级别的的指标 | |
| report_begin_date | 开始时间 | string | 是 | 开始时间和结束时间跨度不能超过7天 | 2024-07-08 00:00:00 |
| report_end_date | 结束时间 | string | 是 | 开始时间和结束时间跨度不能超过7天 | 2024-07-08 00:01:00 |
示例1，成功
{
"app_id": 4,
"set_id": 1,
"report_begin_date": "2025-02-10 07:00:00",
"report_end_date": "2025-02-10 07:02:00"
}
返回data.list参数说明
| 字段名 | 字段说明 | 类型 | 描述 |
|---|---|---|---|
| app_id | 项目ID | ||
| zone_id | 区ID | ||
| update_time | 上报时间 | ||
| sum_simple_req_num | 简单请求-读写请求 | ||
| sum_simple_read_req_num | 简单请求-读请求 | ||
| sum_simple_write_req_num | 简单请求-写请求 | ||
| …其他字段参考对照表 |
字段名称和指标名称对照表
| 字段名 | 指标类型 | 指标名称 |
|---|---|---|
| sum_simple_read_req_num | 每分钟简单请求次数 | 读请求 |
| sum_simple_write_req_num | 写请求 | |
| sum_simple_req_num | 读写请求 | |
| sum_api2_proxy_trans_req_num | 每分钟事务请求次数 | 读写请求 |
| simple_req_max_process_time | 最大处理时间 | 简单请求 |
| trans_req_max_process_time | 事务请求 | |
| simple_req_average_process_time | 平均处理时间 | 简单请求 |
| trans_req_average_process_time | 事务请求 | |
| sum_simple_read_req_err_num | 每分钟错误数 | 简单读请求 |
| sum_simple_write_req_err_num | 简单些请求 | |
| sum_simple_read_resp_err_num | 简单读响应 | |
| sum_simple_write_resp_err_num | 简单写响应 | |
| sum_trans_req_err_num | 事务读写请求 | |
| sum_trans_resp_err_num | 事务读写响应 | |
| sum_batch_get_timeout_cnt | BatchGet超时数 | |
| sum_batch_get_by_part_key_timeout_cnt | BatchGetbyPartkey超时数 | |
| sum_batch_field_get_by_timeout_cnt | BatchFieldGet超时数 | |
| sum_trans_action_failed_num | TransAction失败次数 | |
| sum_tbus2_tbus_loss_pkg_count | Tbus2Tbus丢包数 | |
| sum_proxy2_tbus_loss_pkg_count | Proxy2Tbus丢包数 | |
| sum_proxy2_api_loss_pkg_count | Proxy2API丢包数 | |
| simple_req_succ_rate | 每分钟读写成功率 | 简单请求 |
| trans_req_succ_rate | 事务请求 | |
| sum_simple_resp_high_latency_num | 每分钟大时延请求数 | 简单读写请求 |
| sum_complex_resp_high_latency_num | 复杂读写请求 | |
| sum_simple_read_resp_mid_latency_num | 每分钟中时延简单请求数 | 读请求 |
| sum_simple_write_resp_mid_latency_num | 写请求 | |
| sum_complex_read_resp_mid_latency_num | 每分钟中时延复杂请求数 | 读请求 |
| sum_complex_write_resp_mid_latency_num | 写请求 | |
| eth_in_use_mbps | 每分钟所有机器总流量 | 入流量 |
| eth_out_use_mbps | 每分钟所有机器总流量 | 出流量 |
| eth_in_out_use_mbps | 每分钟所有机器总流量 | 出入流量 |
| max_thread_cpu_use | 每分钟主线程CPU使用率 | - |
| used_api_connect_count | 每分钟进程连接数及剩余容量 | 主进程连接数 |
| max_api_connect_count | 剩余容量 |
成功返回 (查询fake_table表，07:01:00 - 07:02 的读写数据)
{
"code": 0,
"request_id": "151a5840-230c-4881-9da7-13d42a5ec79d",
"data": {
"list": [
{
"update_time": "2025-02-10 07:00:00",
"report_time": 1739142000,
"proxy_count": 12,
"sum_simple_req_num": 0,
"sum_simple_read_req_num": 0,
"sum_simple_write_req_num": 0,
"sum_api2_proxy_trans_req_num": 0,
"simple_req_max_process_time": 0,
"trans_req_max_process_time": 0,
"simple_req_average_process_time": 0,
"trans_req_average_process_time": 0,
"sum_simple_read_req_err_num": 0,
"sum_simple_write_req_err_num": 0,
"sum_simple_read_resp_err_num": 0,
"sum_simple_write_resp_err_num": 0,
"sum_trans_req_err_num": 0,
"sum_trans_resp_err_num": 0,
"sum_batch_get_timeout_cnt": 0,
"sum_batch_get_by_part_key_timeout_cnt": 0,
"sum_batch_field_get_by_timeout_cnt": 0,
"sum_trans_action_failed_num": 0,
"sum_tbus2_tbus_loss_pkg_count": 0,
"sum_proxy2_tbus_loss_pkg_count": 0,
"sum_proxy2_api_loss_pkg_count": 0,
"simple_req_succ_rate": 100,
"trans_req_succ_rate": 100,
"sum_simple_resp_high_latency_num": 0,
"sum_complex_resp_high_latency_num": 0,
"sum_simple_read_resp_mid_latency_num": 0,
"sum_simple_write_resp_mid_latency_num": 0,
"sum_simple_read_write_resp_mid_latency_num": 0,
"sum_complex_read_resp_mid_latency_num": 0,
"sum_complex_write_resp_mid_latency_num": 0,
"sum_complex_read_write_resp_mid_latency_num": 0,
"eth_in_use_mbps": 3,
"eth_out_use_mbps": 3,
"eth_in_out_use_mbps": 6,
"max_thread_cpu_use": 5,
"used_api_connect_count": 48,
"max_api_connect_count": 12000,
"max_remainning_api_connect_count": 11952
},
{
"update_time": "2025-02-10 07:01:00",
"report_time": 1739142060,
"proxy_count": 12,
"sum_simple_req_num": 0,
"sum_simple_read_req_num": 0,
"sum_simple_write_req_num": 0,
"sum_api2_proxy_trans_req_num": 0,
"simple_req_max_process_time": 0,
"trans_req_max_process_time": 0,
"simple_req_average_process_time": 0,
"trans_req_average_process_time": 0,
"sum_simple_read_req_err_num": 0,
"sum_simple_write_req_err_num": 0,
"sum_simple_read_resp_err_num": 0,
"sum_simple_write_resp_err_num": 0,
"sum_trans_req_err_num": 0,
"sum_trans_resp_err_num": 0,
"sum_batch_get_timeout_cnt": 0,
"sum_batch_get_by_part_key_timeout_cnt": 0,
"sum_batch_field_get_by_timeout_cnt": 0,
"sum_trans_action_failed_num": 0,
"sum_tbus2_tbus_loss_pkg_count": 0,
"sum_proxy2_tbus_loss_pkg_count": 0,
"sum_proxy2_api_loss_pkg_count": 0,
"simple_req_succ_rate": 100,
"trans_req_succ_rate": 100,
"sum_simple_resp_high_latency_num": 0,
"sum_complex_resp_high_latency_num": 0,
"sum_simple_read_resp_mid_latency_num": 0,
"sum_simple_write_resp_mid_latency_num": 0,
"sum_simple_read_write_resp_mid_latency_num": 0,
"sum_complex_read_resp_mid_latency_num": 0,
"sum_complex_write_resp_mid_latency_num": 0,
"sum_complex_read_write_resp_mid_latency_num": 0,
"eth_in_use_mbps": 3,
"eth_out_use_mbps": 3,
"eth_in_out_use_mbps": 6,
"max_thread_cpu_use": 5,
"used_api_connect_count": 48,
"max_api_connect_count": 12000,
"max_remainning_api_connect_count": 11952
},
{
"update_time": "2025-02-10 07:02:00",
"report_time": 1739142120,
"proxy_count": 12,
"sum_simple_req_num": 0,
"sum_simple_read_req_num": 0,
"sum_simple_write_req_num": 0,
"sum_api2_proxy_trans_req_num": 0,
"simple_req_max_process_time": 0,
"trans_req_max_process_time": 0,
"simple_req_average_process_time": 0,
"trans_req_average_process_time": 0,
"sum_simple_read_req_err_num": 0,
"sum_simple_write_req_err_num": 0,
"sum_simple_read_resp_err_num": 0,
"sum_simple_write_resp_err_num": 0,
"sum_trans_req_err_num": 0,
"sum_trans_resp_err_num": 0,
"sum_batch_get_timeout_cnt": 0,
"sum_batch_get_by_part_key_timeout_cnt": 0,
"sum_batch_field_get_by_timeout_cnt": 0,
"sum_trans_action_failed_num": 0,
"sum_tbus2_tbus_loss_pkg_count": 0,
"sum_proxy2_tbus_loss_pkg_count": 0,
"sum_proxy2_api_loss_pkg_count": 0,
"simple_req_succ_rate": 100,
"trans_req_succ_rate": 100,
"sum_simple_resp_high_latency_num": 0,
"sum_complex_resp_high_latency_num": 0,
"sum_simple_read_resp_mid_latency_num": 0,
"sum_simple_write_resp_mid_latency_num": 0,
"sum_simple_read_write_resp_mid_latency_num": 0,
"sum_complex_read_resp_mid_latency_num": 0,
"sum_complex_write_resp_mid_latency_num": 0,
"sum_complex_read_write_resp_mid_latency_num": 0,
"eth_in_use_mbps": 2,
"eth_out_use_mbps": 3,
"eth_in_out_use_mbps": 5,
"max_thread_cpu_use": 5,
"used_api_connect_count": 48,
"max_api_connect_count": 12000,
"max_remainning_api_connect_count": 11952
}
],
"total": 3,
"not_null_total": 3,
"data_from": [
{
"table_name": "proxy_tmonitor_data_set_1_20250210",
"report_date": "2025-02-10",
"set_id": 1
}
]
}
}