Session load


Job details

Name: Session load
Platform: Mysql
Category: Performance
Description: Records the number of active and inactive sessions over time.
Long description: Records the number of active and inactive sessions over time.
Version: 2.22
Default schedule: 0,10,20,30,40,50 * * *
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
keep data for 7 The number of days to keep the data for.

Job Summary

SELECT number_of_processes_total, number_of_processes_active, histr_date  FROM dbw_session_load_histr ORDER BY histr_date 

Metadata

This job falls under the category “Performance”.

Dependencies

The job has three dependencies:

These are necessary for the successful execution of the job.

Job Implementation

The job is implemented by creating two tables (“dbw_session_load_histr” and “dbw_session_load_aggr_histr”) and one procedure (“dbw_session_load”). “dbw_session_load” procedure collects details of total and active sessions and stores that data in the mentioned tables.

Cleaning Up On Failure

In case the job fails, the system is set to follow a cleanup process that includes dropping the two data tables and the main procedure used in the job.

Report Template

The job also generates a report template named “Session load”, under which it presents a series of tables, graphs, and details for total and active sessions over time. These visual aids assist in tracking the boosted session load and making analytics-driven database decisions.

Job Upgrade

At the end of the file, there’s an upgrade section that contains necessary SQL commands for changing the version of the job from 2.21 to 2.22.