Trend Comparison
On the Trend Comparison screen, you can place two different points in time side by side and compare key metrics and session flows. This helps when comparing the load on an unusual day against a normal one, or comparing before and after a change to see what differed.
Setting Comparison Conditions
At the top of the screen, specify the two points in time and the targets to compare.
| Item | Description |
|---|---|
| Base Date | The date that serves as the basis for comparison |
| Comparison Date | The date to compare against the base |
| Instance | Select the target node (oname) for the base and the comparison respectively |
| Database | Displays the databases handled by the selected instance |
| Preset | Save and load frequently viewed chart configurations (Default provided) |
If you specify different instances for the base and the comparison, you can also compare different nodes on the same date.
KPI Comparison Charts
Overlays the key metrics of the base time and the comparison time on the same axis, displayed in 5-minute intervals.
| Metric | Description |
|---|---|
| Threads Running | Number of running threads |
| Connections | Number of connections |
| Queries | Number of queries processed |
| Successful Queries | Number of successful queries |
| Failed Queries | Number of failed queries |
| CPU | CPU usage |
| Engine Memory | Memory used by the engine |
| Disk Usage | Disk usage |
| Network Bandwidth | Network bandwidth |
Since each chart overlays the curves of the base and comparison times, you can see at a glance how much the load differed during the same time period.
Engine Memory is the same memory metric as the Memory widget on the instance monitoring screen, labeled for the Trend Comparison screen.
Base and Comparison Session Tables
Below the charts, the session lists of the base time and the comparison time are displayed side by side. When you select a specific time on the time bar above, you can view the sessions collected at that point in time on both sides together.
Both tables use the same columns.
| Column | Description |
|---|---|
instance | The node where the session was executed. Click to move to the corresponding Instance Monitoring screen |
id | Session identifier |
user | The user who executed the session |
host | Connecting host |
db | Target database |
command | The type of command the session is executing (Query, etc.) |
runtime | Execution time |
state | Session status (executing, etc.) |
query | SQL being executed |
query_param | Bound parameter values |
type | Session type |
connection_type | Connection type |
Data Interpretation Guide
| Checkpoint | Description |
|---|---|
| Metric spike in the same time period | A period with increased load compared to the comparison time; suspect the impact of a change or event |
| Failed Queries concentrated on one side | Errors concentrated on a specific date; check correlation with deployments or data changes |
| Increase in session count and execution time | Suspect a change in query patterns or increased contention; trace the causal query through the session table |