Cluster analysis gives a breakdown of the query traffic associated with the selected cluster by the hour and minute, within the timeframe selected. You can download a report at any time from the page using the Download Report button for this time period.
ScaleArc represents the query traffic breakdown with the help of two chart types:
|Total queries pie chart
Provides the percentage of total query use for each database within the cluster.
|Server time pie chart.
Provides the percentage of total server time each of the databases requires for its respective queries.
Each database shows a breakdown of Total Queries, Cache Hit, Server Time, Cache Time, Time Saved, and Read to Write ratio. Highlighting a database exposes additional details for query breakdown by server within the ScaleArc cluster and types of queries.
Break down cluster traffic
Follow these procedures to reveal the traffic details, which include the total amount of cache, server time, time saved, and Read-Write calls for the cluster in a selected time period (a day).
- Click on the ANALYTICS tab on the ScaleArc dashboard.
- Select the time period.
Scroll down to the grid on the lower half of the screen.
- Click on the + (plus) sign next to the cluster to see the hourly breakdown of traffic for a twenty-four period (if you selected a day for your time period).
- Select one of the hours and click on the + (plus) sign next to it to see its breakdown by the minute, over a 60-minute period.
- Next, see Database server analysis.