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_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

Job Description

This “Network Statistics” job is part of the com.dbwatch.job group in the dbWatch Control Center. It collects the number of bytes that are sent and received by all clients.

Procedures and Tables

The task uses the following main procedure and dependency tables:

The tables are created if they do not exist, and they are updated with data about the bytes received and sent. If the job fails, these tables are dropped as part of the cleanup process.

Statistics Calculation and Report Generation

The procedure calculates the total and average number of bytes received and sent over specific periods of time. The resulting network traffic data is presented as a graph in the task’s report, showing the average network traffic per minute over the last 24 hours.

Implementation Code

The main procedure and code to create/update tables and calculate statistics are included on the XML job task under the ‘implementation’ section.

Upgrade

A code for upgrading the procedure from version 1.1 is included. This procedure drops the existing “dbw_network_statistics” procedure if it exists and defines it anew.

Metadata

The job falls under the “Performance” category in the metadata.

Report Template

A dbWatch report template is included, with a graph showing the average network traffic per minute (both sent and received) over the last 24 hours. The report’s title, text, and schedule are also specified.

Dependencies and Cleanup

Any dependent objects are described within the XML, with instructions on what should be cleaned up in case of a failure.

Installation

The task is set for express installation and will replace existing files on installation.