巡检报告详情
接口URL
/api/v1/observe/inspect/reports/rpt-ispt-2455dfcdc495ce05-1703665829
请求方式
GET
Content-Type
application/json
认证方式
Bearer auth
成功响应示例
{
"Data": {
"CreatedAt": "2023-12-27T16:30:29.784+08:00",
"Creator": "admin",
"Data": {
"bigTableTop20": [],
"clusterTopology": [
{
"instance": "172.17.0.4:4000",
"start_time": "2023-12-27T07:43:46Z",
"status_address": "172.17.0.4:10080",
"type": "tidb",
"version": "6.5.0"
},
{
"instance": "172.17.0.4:4001",
"start_time": "2023-12-27T07:43:47Z",
"status_address": "172.17.0.4:10081",
"type": "tidb",
"version": "6.5.0"
},
{
"instance": "172.17.0.4:2379",
"start_time": "2023-12-27T07:43:38Z",
"status_address": "172.17.0.4:2379",
"type": "pd",
"version": "6.5.0"
},
{
"instance": "172.17.0.4:20161",
"start_time": "2023-12-27T07:43:41Z",
"status_address": "172.17.0.4:20181",
"type": "tikv",
"version": "6.5.0"
},
{
"instance": "172.17.0.4:20160",
"start_time": "2023-12-27T07:43:41Z",
"status_address": "172.17.0.4:20180",
"type": "tikv",
"version": "6.5.0"
}
],
"collectStatisticFailedTop20": [],
"collectStatisticLongestTop20": [],
"componentVariables": [
{
"Expect": "false",
"Instance": "172.17.0.4:4000",
"Key": "binlog.enable",
"Type": "tidb",
"Value": "false"
},
{
"Expect": "true",
"Instance": "172.17.0.4:4000",
"Key": "binlog.ignore-error",
"Type": "tidb",
"Value": "false"
},
{
"Expect": "false",
"Instance": "172.17.0.4:4000",
"Key": "enable-telemetry",
"Type": "tidb",
"Value": "true"
},
{
"Expect": "50",
"Instance": "172.17.0.4:4000",
"Key": "log.file.max-backups",
"Type": "tidb",
"Value": "0"
},
{
"Expect": "30",
"Instance": "172.17.0.4:4000",
"Key": "log.file.max-days",
"Type": "tidb",
"Value": "0"
},
{
"Expect": "300",
"Instance": "172.17.0.4:4000",
"Key": "log.file.max-size",
"Type": "tidb",
"Value": "300"
},
{
"Expect": "true",
"Instance": "172.17.0.4:4000",
"Key": "new_collations_enabled_on_first_bootstrap",
"Type": "tidb",
"Value": "true"
},
{
"Expect": "1073741824",
"Instance": "172.17.0.4:4000",
"Key": "performance.txn-total-size-limit",
"Type": "tidb",
"Value": "104857600"
},
{
"Expect": "/tmp",
"Instance": "172.17.0.4:4000",
"Key": "tmp-storage-path",
"Type": "tidb",
"Value": "/tmp/1000_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage"
},
{
"Expect": "107374182400",
"Instance": "172.17.0.4:4000",
"Key": "tmp-storage-quota",
"Type": "tidb",
"Value": "-1"
},
{
"Expect": "false",
"Instance": "172.17.0.4:4001",
"Key": "binlog.enable",
"Type": "tidb",
"Value": "false"
},
{
"Expect": "true",
"Instance": "172.17.0.4:4001",
"Key": "binlog.ignore-error",
"Type": "tidb",
"Value": "false"
},
{
"Expect": "false",
"Instance": "172.17.0.4:4001",
"Key": "enable-telemetry",
"Type": "tidb",
"Value": "true"
},
{
"Expect": "50",
"Instance": "172.17.0.4:4001",
"Key": "log.file.max-backups",
"Type": "tidb",
"Value": "0"
},
{
"Expect": "30",
"Instance": "172.17.0.4:4001",
"Key": "log.file.max-days",
"Type": "tidb",
"Value": "0"
},
{
"Expect": "300",
"Instance": "172.17.0.4:4001",
"Key": "log.file.max-size",
"Type": "tidb",
"Value": "300"
},
{
"Expect": "true",
"Instance": "172.17.0.4:4001",
"Key": "new_collations_enabled_on_first_bootstrap",
"Type": "tidb",
"Value": "true"
},
{
"Expect": "1073741824",
"Instance": "172.17.0.4:4001",
"Key": "performance.txn-total-size-limit",
"Type": "tidb",
"Value": "104857600"
},
{
"Expect": "/tmp",
"Instance": "172.17.0.4:4001",
"Key": "tmp-storage-path",
"Type": "tidb",
"Value": "/tmp/1000_tidb/MC4wLjAuMDo0MDAxLzAuMC4wLjA6MTAwODE=/tmp-storage"
},
{
"Expect": "107374182400",
"Instance": "172.17.0.4:4001",
"Key": "tmp-storage-quota",
"Type": "tidb",
"Value": "-1"
},
{
"Expect": "false",
"Instance": "172.17.0.4:2379",
"Key": "dashboard.enable-telemetry",
"Type": "pd",
"Value": "true"
},
{
"Expect": "50",
"Instance": "172.17.0.4:2379",
"Key": "log.file.max-backups",
"Type": "pd",
"Value": "0"
},
{
"Expect": "30",
"Instance": "172.17.0.4:2379",
"Key": "log.file.max-days",
"Type": "pd",
"Value": "0"
},
{
"Expect": "300",
"Instance": "172.17.0.4:2379",
"Key": "log.file.max-size",
"Type": "pd",
"Value": "300"
},
{
"Expect": "3",
"Instance": "172.17.0.4:2379",
"Key": "replication.max-replicas",
"Type": "pd",
"Value": "3"
},
{
"Expect": "true",
"Instance": "172.17.0.4:2379",
"Key": "schedule.enable-cross-table-merge",
"Type": "pd",
"Value": "true"
},
{
"Expect": "0.7",
"Instance": "172.17.0.4:2379",
"Key": "schedule.high-space-ratio",
"Type": "pd",
"Value": "0.7"
},
{
"Expect": "0.8 ",
"Instance": "172.17.0.4:2379",
"Key": "schedule.low-space-ratio",
"Type": "pd",
"Value": "0.8"
},
{
"Expect": "30m0s",
"Instance": "172.17.0.4:2379",
"Key": "schedule.max-store-down-time",
"Type": "pd",
"Value": "30m0s"
},
{
"Expect": "false",
"Instance": "172.17.0.4:20161",
"Key": "coprocessor.split-region-on-table",
"Type": "tikv",
"Value": "false"
},
{
"Expect": "50",
"Instance": "172.17.0.4:20161",
"Key": "log.file.max-backups",
"Type": "tikv",
"Value": "0"
},
{
"Expect": "30",
"Instance": "172.17.0.4:20161",
"Key": "log.file.max-days",
"Type": "tikv",
"Value": "0"
},
{
"Expect": "300",
"Instance": "172.17.0.4:20161",
"Key": "log.file.max-size",
"Type": "tikv",
"Value": "300"
},
{
"Expect": "3",
"Instance": "172.17.0.4:20161",
"Key": "raftstore.apply-pool-size",
"Type": "tikv",
"Value": "2"
},
{
"Expect": "3",
"Instance": "172.17.0.4:20161",
"Key": "raftstore.store-pool-size",
"Type": "tikv",
"Value": "2"
},
{
"Expect": "true",
"Instance": "172.17.0.4:20161",
"Key": "readpool.coprocessor.use-unified-pool",
"Type": "tikv",
"Value": "true"
},
{
"Expect": "6",
"Instance": "172.17.0.4:20161",
"Key": "readpool.unified.max-thread-count",
"Type": "tikv",
"Value": "4"
},
{
"Expect": "true",
"Instance": "172.17.0.4:20161",
"Key": "storage.block-cache.shared",
"Type": "tikv",
"Value": "true"
},
{
"Expect": "false",
"Instance": "172.17.0.4:20160",
"Key": "coprocessor.split-region-on-table",
"Type": "tikv",
"Value": "false"
},
{
"Expect": "50",
"Instance": "172.17.0.4:20160",
"Key": "log.file.max-backups",
"Type": "tikv",
"Value": "0"
},
{
"Expect": "30",
"Instance": "172.17.0.4:20160",
"Key": "log.file.max-days",
"Type": "tikv",
"Value": "0"
},
{
"Expect": "300",
"Instance": "172.17.0.4:20160",
"Key": "log.file.max-size",
"Type": "tikv",
"Value": "300"
},
{
"Expect": "3",
"Instance": "172.17.0.4:20160",
"Key": "raftstore.apply-pool-size",
"Type": "tikv",
"Value": "2"
},
{
"Expect": "3",
"Instance": "172.17.0.4:20160",
"Key": "raftstore.store-pool-size",
"Type": "tikv",
"Value": "2"
},
{
"Expect": "true",
"Instance": "172.17.0.4:20160",
"Key": "readpool.coprocessor.use-unified-pool",
"Type": "tikv",
"Value": "true"
},
{
"Expect": "6",
"Instance": "172.17.0.4:20160",
"Key": "readpool.unified.max-thread-count",
"Type": "tikv",
"Value": "4"
},
{
"Expect": "true",
"Instance": "172.17.0.4:20160",
"Key": "storage.block-cache.shared",
"Type": "tikv",
"Value": "true"
}
],
"execTimeLongestTop20": [],
"maxMemoryUsageTop20": [],
"noIndexTable": [],
"noUniqueIndexTable": [],
"sqlMode": [
{
"Value": "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION",
"Variable_name": "sql_mode"
}
],
"sumExecTimeLongestTop20": [],
"systemVariables": [
{
"Expect": "22:00 +0800",
"Key": "tidb_auto_analyze_start_time",
"Value": "00:00 +0000"
},
{
"Expect": "04:00 +0800",
"Key": "tidb_auto_analyze_end_time",
"Value": "23:59 +0000"
},
{
"Expect": "READ-COMMITTED",
"Key": "transaction_isolation",
"Value": "REPEATABLE-READ"
},
{
"Expect": "2h",
"Key": "tidb_gc_life_time",
"Value": "10m0s"
},
{
"Expect": "1 ",
"Key": "tidb_analyze_version",
"Value": "2"
},
{
"Expect": "off",
"Key": "tidb_enable_clustered_index",
"Value": "ON"
},
{
"Expect": "0.1",
"Key": "tidb_auto_analyze_ratio",
"Value": "0.5"
},
{
"Expect": "OFF",
"Key": "tidb_enable_telemetry",
"Value": "ON"
},
{
"Expect": "CANCEL",
"Key": "tidb_mem_oom_action",
"Value": "CANCEL"
}
],
"tableTop20": [],
"tidbClsuterCapacity": [
{
"ADDRESS": "172.17.0.4:20161",
"AVAILABLE": "862GiB",
"CAPACITY": "1.719TiB",
"LABEL": "null",
"LEADER_COUNT": "26",
"LEADER_SIZE_MB": "26",
"LEADER_WEIGHT": "1",
"REGION_COUNT": "43",
"REGION_SIZE_MB": "43",
"REGION_WEIGHT": "1",
"STORE_ID": "1",
"STORE_USE": "-50045.433%%",
"TIKV_STATUS": "Up"
},
{
"ADDRESS": "172.17.0.4:20160",
"AVAILABLE": "862GiB",
"CAPACITY": "1.719TiB",
"LABEL": "null",
"LEADER_COUNT": "17",
"LEADER_SIZE_MB": "17",
"LEADER_WEIGHT": "1",
"REGION_COUNT": "43",
"REGION_SIZE_MB": "43",
"REGION_WEIGHT": "1",
"STORE_ID": "4",
"STORE_USE": "-50045.433%%",
"TIKV_STATUS": "Up"
}
],
"tidbGCVariables": [
{
"VARIABLE_NAME": "bootstrapped",
"VARIABLE_VALUE": "True"
},
{
"VARIABLE_NAME": "tidb_server_version",
"VARIABLE_VALUE": "109"
},
{
"VARIABLE_NAME": "system_tz",
"VARIABLE_VALUE": "Etc/UTC"
},
{
"VARIABLE_NAME": "new_collation_enabled",
"VARIABLE_VALUE": "True"
},
{
"VARIABLE_NAME": "tikv_gc_leader_uuid",
"VARIABLE_VALUE": "632a8eb0c900006"
},
{
"VARIABLE_NAME": "tikv_gc_leader_desc",
"VARIABLE_VALUE": "host:562a5231aa38, pid:6079, start at 2023-12-27 07:43:46.988359769 +0000 UTC m=+4.900375316"
},
{
"VARIABLE_NAME": "tikv_gc_leader_lease",
"VARIABLE_VALUE": "20231227-08:31:47.051 +0000"
},
{
"VARIABLE_NAME": "tikv_gc_auto_concurrency",
"VARIABLE_VALUE": "true"
},
{
"VARIABLE_NAME": "tikv_gc_enable",
"VARIABLE_VALUE": "true"
},
{
"VARIABLE_NAME": "tikv_gc_run_interval",
"VARIABLE_VALUE": "10m0s"
},
{
"VARIABLE_NAME": "tikv_gc_life_time",
"VARIABLE_VALUE": "10m0s"
},
{
"VARIABLE_NAME": "tikv_gc_last_run_time",
"VARIABLE_VALUE": "20231227-08:23:47.030 +0000"
},
{
"VARIABLE_NAME": "tikv_gc_safe_point",
"VARIABLE_VALUE": "20231227-08:13:47.030 +0000"
},
{
"VARIABLE_NAME": "tikv_gc_scan_lock_mode",
"VARIABLE_VALUE": "legacy"
},
{
"VARIABLE_NAME": "tikv_gc_mode",
"VARIABLE_VALUE": "distributed"
}
],
"tooLangerSingleRowsTable": []
},
"DeliveryTime": 1703665837,
"Description": "手动创建的巡检报告",
"InspectID": "ispt-2455dfcdc495ce05",
"Name": "巡检报告001",
"PolicyID": "workday_policy",
"ReportID": "rpt-ispt-2455dfcdc495ce05-1703665829",
"Status": "finished",
"Target": "tidb-5ea28a75",
"TaskID": "tsk-00f4093fd83ac7fd"
},
"Success": true
}