A large query request is a Remote Procedure Call (RPC) request that scans more than 100 data blocks, caused by improperly specified query conditions. These requests consume significant CPU and I/O resources and can degrade system throughput.
Use the Big Call Request Detection tool in the cluster management system to identify large query requests at the instance or node level, so you can investigate and resolve performance issues promptly.
Prerequisites
Before you begin, ensure that you have:
Logged on to the cluster management system of your Lindorm instance. For more information, see Log on to the cluster management system
Detect large query requests
In the left-side navigation pane, choose Diagnose Tools > Big Call Request Detection.
Set the query conditions, including idc, Group, and Server.
Click Query.
Interpret the results
The query results include the following parameters.
| Parameter | Description |
|---|---|
| Request detail | Detailed information about the large query request, including the time it was initiated and the request content. |
| Sampling time | The time when the large query request was initiated. |
If no results are returned, no large query requests exist on the selected node.