This topic describes the inspection metrics of obdiag V1.5.0 in details.
OBServer-related metrics
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. |
ODP-related metrics
Type |
Task |
Inspection purpose |
|---|---|---|
| version | bad_version | Checks whether an unrecommended version of OceanBase Database Proxy (ODP) is used. |
