This document mainly introduces how we use the Processor monitoring function provided by the software.
After the mouse moves to the
Monitor menu, a drop-down box will automatically pop up. Select the
Processor sub-menu in the drop-down box and click it, and it will jump to the corresponding management page. His snapshot is similar to the following screenshot:
By default, the selection item after
Serveron the top left is blank, you need to manually select a data source
On the right side of the top menu, there will be a
Threshold (unit/ms) value input window, which is used for our update time interval. When we turn on the
Auto function on the right, the software will input the value according to
Threshold Automatically refresh the data.
The chart in the middle part is used to mark the total number of processes of the current query of the currently selected server. The chart has a maximum of 20 points by default, and each time point will automatically cover the previous expired data points.
The bottom data table is used to render the detailed process of the server's specific query at our current time. It provides the following indicators:
Time: The time the current process is running
Rows: The number of rows to be queried in the current process query (
Elapsed: Process query time (unit/ms)
Bytes: The bytes consumed by the current process query (
memoryUsage: Memory consumed by the query
bytesRead: Query the number of bytes read
bytesWritten: Query the number of bytes written
hash: The hash of this query
host: The host name of the service being queried
The above data are from the
We also provide two operations in the detailed list:
KILL: Stop the current query (Note: This operation cannot be rolled back)
DDL: Query the specific SQL statement of the current query
When our query takes a long time, we can click the button, and it will A window like the following pops up:
The window gives us two important tips, which need to be read carefully. If you are sure to perform the operation, enter the unique data marked under the
Necessary prompt in the input box, and then click the
It will send a KILL command to the server, the specific command executed is as follows
KILL QUERY WHERE query_id = 'f57ae2a8-8aeb-4f71-b395-43d7065ac564'
When we need to view the specific SQL of this query, we can click the button, and it will A window like the following pops up:
The editor is the specific SQL statement we query this time.