The command word analysis feature analyzes the number and latency of database access commands statistically. Latency analysis makes it simple to identify the command that is used the most frequently, and command word analysis helps you further identify when it is most frequently executed as well as its execution latency, which facilitates troubleshooting and performance optimization.
2. On the left sidebar, select Performance Optimization.
3. At the top of the Performance Optimization page of DBbrain, select the target instance in the Instance ID drop-down list.
4. Select the Latency Analysis > Command Word Analysis tab and set the collection granularity to 5s, 15s, or 30s as needed in the drop-down list next to Auto-Refresh in the top-right corner.
5. (Optional) Quickly filter target command words in the drop-down list in the top-left corner.
6. Analyze the trend data of the command words.
Real-time statistics
Real-time statistics are displayed by default, including the change trends of command requests, P99 execution latency, average execution latency, and max execution latency. For more information on metrics, see Performance Trends.
Historical data
Click Historical to view the statistics in the last 30 minutes, 6 hours, or 24 hours. You can also click
in the time selection box to view the statistics in the last 2 days.
