This topic describes how to view database inspection items, expected results, and handling suggestions on the OMU portal.
Log in to the OMU portal and click the Preventive Maintenance tab. On the page that is displayed, click the arrows next to Basic Information of DB and Running Status of DB. The page shown in Figure 1 is displayed when the inspection is complete. Table 1 lists the inspection items, expected results, and handling suggestions for the basic information about the database. Table 2 lists the inspection items, expected results, and handling suggestions for the running status of the database.
Inspection Item | Expected Result | Handling Suggestion |
|---|---|---|
Check the database version | The version is V100R003. | Collect database installation information and contact Huawei engineers. |
Check the database character set | The database character set is UTF8. | |
Check the environment variables of the current database user | Environment variables of the current database user are correctly configured. |
Inspection Item | Expected Result | Handling Suggestion |
|---|---|---|
Check whether the database has started | The database has started. | If the item does not pass the check, collect database logs and /var/log/messages logs and attempt to restart the database. If the fault persists, contact Huawei technical support engineers. To collect database logs, perform the following operations:
To restart the database, perform the following operations:
|
Check the postmaster.pid file | The /DB_DATA/data/postmaster.pid file exists. | If the check fails, contact Huawei engineers. |
Check whether the system table structure can be modified | The value of allow_system_table_mods is off. | |
Check the integrity of data written to disks | The value of fsync is on. | |
Check the size of the shared memory buffer | The value of shared_buffers is 2MB. | |
Check whether the query optimization function is enabled | The value of geqo is on. | |
Check the number of connected clients | The number of connected clients is less than 90% of the maximum. | If the check fails, disable unnecessary connections. |
Check the maximum number of connections | The maximum number of connected clients is greater than or equal to 1000. | If the check fails, contact Huawei engineers. |
Check the SQL that occupies CPU resources | The CPU usage of all SQL statements is within 40%. NOTE: If the CPU usage exceeds 40%, complex SQL statements may have been invoked, or deadlock files may have been generated.
| If the item does not pass the check, collect top command information and contact Huawei technical support engineers. To collect top command information, perform the following operations:
|
