Sorts Page
The Sorts page provides details on the rate at which tables are sorted in the database under investigation.
To open the Sorts page
- Select the Spotlight on MySQL connection in the Spotlight Browser.
-
Click Activity | Sorts.
Charts on the Sorts page
| Chart | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
|
Sorts per Second chart |
This chart shows sort rates for the current Spotlight on MySQL connection.
| ||||||||
|
Sort Rows per Second |
This chart shows the rate at which rows were sorted in the displayed period. | ||||||||
|
Sort Merge Operations per Second |
This chart shows the rate at which merge sorts were performed in the displayed period. A sort merge breaks a large table into a series of smaller temporary tables, sorts each temporary table independently, and then merges the sorted results back into the original table. | ||||||||
|
Merges per Sort |
This chart shows the average number of merge passes required to complete a sort merge. |