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
- Purpose: The purpose of this dbWatch Control Center task is to monitor network statistics for a MySQL database.
- Why: Regularly monitoring network statistics can alert the database administrator to any irregularities, such as a sudden increase in bytes being sent or received, and allow them to take appropriate action.
- Manual checking: Manual checking can be performed in the database by issuing the SQL commands present in the ‘implementation’ section of the XML job task.
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:
- Main procedure: “dbw_network_statistics”
- Dependency tables: “dbw_network_statistics_histr” and “dbw_network_statistics_last”
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.