Network statistics
Job details
| Name: | Network statistics |
| Platform: | Mysql |
| 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.2 |
| Default schedule: | 1,6,11,16,21,26,31,36,41,46,51,56 * * * |
| Requires engine install: | Yes |
| Compatibility tag: | .[type=‘instance’ & is_mysql_branch=‘1′]/.[hasengine=‘YES’ & use_global_variables_performance_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: The purpose of this job is to keep track of the number of bytes sent and received from all clients on a MySql database. The networking statistics are gathered and updated every five minutes, as per the default scheduling.
- Why: Continuous monitoring of network traffic is crucial for any database management system. This job is important because it collects data on network usage that can help identify potential issues related to traffic overcrowding, unnecessary data transmission, or possible breaches. If the database receives or sends significantly more data than usual during a specific time period, it may indicate a problem that needs immediate attention.
- Manual checking: You can check this manually in the database by issuing these SQL commands:
SELECT bytes_received, bytes_sent FROM dbw_network_statistics_lastReport Summary
The output generated from this database monitoring job will typically be represented in a report that includes graphical representations of the network traffic per minute, received and sent data over the last 24 hours.
The graph will display the average network traffic per minute, broken down into the amount of data received and sent. This information can help provide a visual comparison of the amount of data being received and sent over time, which can be useful for identifying any unexpected spikes or drops in network activity.
Cleanup Process
In case of failure, the job has a cleanup process defined which includes dropping the network statistics tables and procedures:
DROP TABLE dbw_network_statistics_histr
DROP TABLE dbw_network_statistics_last
DROP PROCEDURE dbw_network_statisticsOther Features
- The job has a version of 1.2 and is developed by the company dbwatch.com
- It belongs to the group com.dbwatch.job and it’s specifically made for MySQL databases.
- This job also includes a default schedule which indicates how often the job runs.
- The implementation section contains the SQL commands used to create tables and procedures, as well as the main procedure which collects and calculates the network statistics.
- The job uses historical thresholding techniques to maintain and analyze data over time and it contains a force-install feature, which means it will install regardless of the existing setup.
- The metadata adds the information of the job category being Performance.