Cluster traffic analysis provides a breakdown of each database associated with the selected cluster within the time frame selected.
The top half of the Analytics screen displays a graph showing the total number of queries passing through ScaleArc at any given date, time (day, week, month, three months), and in any given cluster.
Note that you can click on the Download Report button at any time to obtain the data in a CSV file.
View total cluster traffic by following these steps:
- Click on the ANALYTICS tab on the ScaleArc dashboard. The graph shows the traffic for all the clusters in ScaleArc.
- Click on one or more clusters below the graph to display the query traffic for a selected cluster(s). Note that if you have several clusters, you can use the toggle button to deselect those clusters you don't want to be displayed on the screen. ScaleArc assigns distinct color codes to differentiate one cluster from another.
Click on a date from the date calendar to see the query traffic for the selected cluster(s) on that date. Or, select the time range to see the traffic for your selected cluster(s) by the day, week, month, or over three months. Alternatively, click and drag a section to set the time range.Tip: To review total traffic in larger segments of time, select a date (D1) from the calendar and Week as the range of time. ScaleArc displays the analytics data from D1 plus 7 days. Similarly, choose Month or the 3 Months option to display D1 + 30 days (one month) or 90 days (three months), respectively.
View total traffic per cluster
The grid on the lower half of the screen provides tabular data on the total cluster traffic, broken down by total traffic per cluster. Cache Hit (%) displays the percentage of the total queries returned from ScaleArc cache. The server time is the total time taken for the server to complete the transactions that were not returned from ScaleArc cache. Timed Saved is the amount of time saved by returning the query response from ScaleArc cache instead of sending it to the database server for processing.
- Use the grid to read the volume of total query traffic for each cluster over a 24-hour cycle (if you selected a day in the calendar). Collapse or expand each cluster details as necessary.
- This section also breaks down the total queries by the total number of cache, server, time saved, and the ratio of Read to Write transactions for each cluster within the selected timeframe.
- Next, see Cluster analysis to break down the traffic, per cluster.