Network statistics

Job details

Parameters

Job Summary

• Purpose: The purpose of this job is to collect and analyze the network statistics specifically bytes received and sent from all clients connected to a MariaDB server instance, ensuring comprehensive monitoring of data flow which aids in performance assessments and troubleshooting network-related issues.
• Why: This job is important because effective network monitoring can identify potential data bottlenecks, ensure seamless data exchange and optimize server performance. By automatically tracking these metrics, administrators can preemptively address issues before they escalate, thereby reducing downtime and improving service availability.
• Manual checking: You can check this manually in the database by issuing these SQL commands:

SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE variable_name IN ('BYTES_RECEIVED', 'BYTES_SENT');
  

Job Details

• “Network statistics” is implemented to specifically target MariaDB instances.
• Scheduled to run at a 6-hour interval, ensuring regular updates without overloading the system resources.
• Database Dependency includes creating and maintaining history and current statistics tables and a procedure for calculating necessary metrics.

Dependency and Cleanup Strategy

• Dependencies include:
  • dbw_network_statistics (procedure)
  • dbw_network_statistics_histr (history table)
  • dbw_network_statistics_last (current statistics table)

• Cleanup involves:
  • Dropping the tables and procedure in case of a job failure to ensure no incomplete or corrupt data persists.

Implementation

• Creation of tables to store historical and current network statistics.
• The main procedure (dbw_network_statistics) calculates various statistics such as total and average bytes received and sent over customizable intervals (default and custom periods).
• Data sanitization to handle scenarios where the current byte count might be less than the last recorded count.
• Complexity in handling large volumes of data efficiently by using aggregated and average computations.

Reporting Strategy

• Version: 2
• Scheduled on an hourly basis, separate from the main job to ensure that the latest data are reflected in reports without waiting for the next major job cycle.
• Reports include graphical representations showing average network traffic per minute for the last 24 hours, aiding in visual assessment and trend analysis.
• Report generation utilizes SQL queries to fetch and compute required metrics from the historical data captured by the implementation part of the job.

Conclusion

The “Network statistics” job by dbWatch Control Center ensures comprehensive and efficient monitoring of network performance for MariaDB instances, with detailed and automated reporting facilitating easy interpretation and timely decision-making regarding database management and optimization.