Inspection metrics|V1.5.0| docs|Distributed Database

This topic describes the inspection metrics of obdiag V1.5.0 in details.

Type	Task	Inspection purpose
Cluster	core_file_find	Checks for OBServer nodes that have caused the generation of core dump files.
	deadlocks	Checks for deadlocks.
	major	Checks for major compaction tasks that have been in execution for more than 36 hours.
	part_trans_action_max	Checks whether the number of transaction participants exceeds 200.
	tenant_log_size	Checks whether the size of logs in the log disk is three times or more of the memory size.
	data_path_settings	Checks whether the data disk and log disk are set to the same disk.
	global_indexes_too_much	Checks whether the number of global indexes exceeds 20.
	mod_too_large	Checks for users who have occupied more than 10 GB of modules.
	task_opt_stat_gather_fail	Checks for failed history collection tasks.
CPU	oversold	Checks for OBServer nodes that are not in the ACTIVE state.
Disk	disk_full	Checks for full disk usage. A warning is sent if disk usage exceeds 80% and an error is sent if it exceeds 90%.
	disk_hole	Checks for disk holes.
Error code	find_err_*	Checks for error codes of serious errors.
System	aio	Checks whether the asynchronous I/O is correctly configured.
	dependent_software	Checks whether the dependencies of basic software are correctly configured.
	parameter	Checks whether the kernel parameters are configured as required.
	ulimit_parameter	Checks whether the ulimit parameters are configured as required.
version	bad_version	Checks whether an unrecommended OBServer version is used.
Sysbench	sysbench_free_test_cpu_count	The value of this parameter should be 80% to 100% of the total CPU cores of the server.
	sysbench_run_test_tenant_memory_used	Checks whether the sum of used or held memory is less than 80% of the total memory for the tenant.
	sysbench_test_cpu_quota_concurrency	2 or 4
	sysbench_test_tenant_log_disk_size	Checks whether the log disk is less than 20 GB.
	sysbench_free_test_memory_limit	Checks whether the allocated memory is 80% to 90% of the server.
	sysbench_test_cluster_datafile_size	If logs and data are stored on the same disk, checks whether the percentage of disk space for data files is 60%. If logs and data are stored on different disks, checks whether the percentage of disk space for data files is 90%.
	sysbench_test_log_level	Checks whether the log level is `INFO`, `WARN`, or `ERROR`.
	sysbench_test_tenant_primary_zone	Checks whether the primary zone is set to RANDOM.
	sysbench_free_test_network_speed	Checks whether the NIC provides a bandwidth greater than 1 Gbit/s.
	sysbench_test_cluster_log_disk_size	If logs and data are stored on the same disk, checks whether the percentage of disk space for log files is 30%. If logs and data are stored on different disks, checks whether the percentage of disk space for log files is 90%.
	sysbench_test_sql_net_thread_count	Checks whether the `net_thread_count` parameter is set to 1/8 of the value of the `cpu_count` parameter, and whether the `sql_net_thread_count` parameter is set to 0 or the same value as the `net_thread_count` parameter.
	sysbench_run_test_tenant_cpu_used	Checks whether the value is greater than 90% of the value of the `max_cpu` parameter.
	sysbench_test_cluster_parameters	Checks whether the `enable_sql_audit`, `enable_perf_event`, and `enable_record_trace_log` parameters are set to false.
	sysbench_test_tenant_cpu_parameters	Checks whether the value of the `max_iops` parameter is greater than 10,000 times the value of the `max_cpu` parameter, and the value of the `min_iops` parameter is greater than 10,000 times the value of the `min_cpu` parameter.

Type	Task	Inspection purpose
version	bad_version	Checks whether an unrecommended version of OceanBase Database Proxy (ODP) is used.