How do I test auxiliary database disk performance?
Purpose
The disk performance of an NFM-P component affects overall system performance, and must meet or exceed the minimum specifications in the response to the NFM-P Platform Sizing Request for your system.
Also, before you add capacity to a disk or partition on an NFM-P component, for example, using LVM, you must ensure that the disk throughput and latency values remain within tolerance, which is defined as being within 10% of the current values.
Note: The disk performance of the stations in an auxiliary database cluster must be closely matched. You must test and compare the disk performance of each station in a cluster to ensure optimal performance.
Perform this procedure to check the disk performance of an NSP auxiliary database station.
CAUTION Service Disruption |
Checking the disk performance requires a shutdown of the auxiliary database cluster and is service-affecting.
Perform the procedure only during a scheduled maintenance period.
Steps
1 |
Perform How do I stop an auxiliary database cluster?. |
2 |
When the auxiliary database cluster is stopped, enter the following as the root user on the auxiliary database station to begin the test: # /opt/vertica/bin/vioperf /opt/nsp/nfmp/auxdb/data ↵ |
3 |
Record the utility output. |
4 |
As a routine performance check, perform the following steps.
|
5 |
If you are adding capacity to a disk or partition, perform the following steps.
|
6 |
Close the console windows. End of steps |