Network statistics
Job details
Name: |
Network statistics |
Platform: |
Mariadb |
Category: |
Performance |
Description: |
This job collects the number of bytes received and sent from all clients. |
Long description: |
This job collects the number of bytes received and sent from all clients. |
Version: |
1.1 |
Default schedule: |
1,6,11,16,21,26,31,36,41,46,51,56 * * * |
Requires engine install: |
Yes |
Compatibility tag: |
.[type=‘instance’ & is_mariadb_branch=‘1′]/.[hasengine=‘YES’ & global_status_performance_schema = ‘0′ & global_status_information_schema = ‘1′ ] |
Parameters
Name |
Default value |
Description |
history threshold |
7 |
The maximum number of day to keep statistics for in the history tables. |
threshold (time) |
15 |
A period of time (in minutes) the network statistics are calculated for (default 15 minutes) |
Job Summary
- Purpose: To monitor and collect data on the number of bytes sent and received by clients over the database network, ensuring performance optimization and identifying potential issues in data flow.
- Why: Monitoring network usage is critical for maintaining database performance and operational efficiency. It helps in preventing network congestion, identifying unexpected spikes in data transfer, and aids in capacity planning. Monitoring also assists in detecting possible data breaches, where large amounts of data might be unexpectedly sent or received.
- Manual checking: You can manually check the network statistics in the database by executing the following SQL commands:
SELECT bytes_received, bytes_sent FROM dbw_network_statistics_last;
Job Details
Job Objective
The job’s core function is to track the volume of network traffic (bytes sent and received) to gauge the instance’s performance. It helps in understanding the bandwidth usage patterns and ensures that the database does not suffer from under-provisioning or overloading due to network traffic.
How It Functions
- The job functions by creating and updating a history table for network statistics.
- It collects data for the amount of data sent and received over the network.
- Accumulated data is recorded for designated intervals and used to calculate average and total transfer rates over these intervals and a cumulative 24-hour period.
- The job is scheduled to run every 5 minutes as per the default scheduling setting embedded in the job configuration.
Tables and Procedures Created:
Table/Procedure Name |
Purpose |
dbw_network_statistics_histr |
Stores historical data of bytes sent and received over time including differential calculation. |
dbw_network_statistics_last |
Temporarily holds the last recorded bytes sent and received. |
dbw_network_statistics |
Main procedure used to process and compile statistics for reporting and performance checks. |
Key Metrics Tracked
- Total bytes received and sent during the specified monitoring period.
- Average bytes sent and received per minute over the last 24 hours.
Rationale for Using This Monitoring Job
This job is significant because it enables:
- Proactive monitoring which is crucial for timely detection and resolution of performance issues.
- Maintenance of efficient network traffic management, helping to prevent bottlenecks.
- Historical data analysis that provides insights for future capacity planning.
Cleaning Up
- The job includes cleanup mechanisms in case of installation failure, where it drops the created tables and related procedures to keep the environment clean.
Reporting Features
Report Overview
- Title: Network Statistics
- Description: Provides a graph and data table showing average network traffic per minute (received and sent) over the last 24 hours.
- The report is updated hourly based on new data collected.
Presentation In Report
Statistic |
Description |
Average Network Traffic Per Minute |
Displays a graphical representation of MB per minute for both received and sent data over the last 24 hours. |
Detailed Timestamped Data |
Lists out exact figures of data sent and received along with the respective timestamps. |
This formatted and structured reporting helps in visualizing trends and understanding peak usage times, which is crucial for resource management and planning.