Session load


Job details

Name: Session load
Platform: Mariadb
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_mariadb_branch=‘1′]/.[hasengine=‘YES’ & global_status_performance_schema = ‘1′ ]

Parameters

Name Default value Description
keep data for 7 The number of days to keep the data for.

Job Summary

SELECT * FROM dbw_session_load_histr;
SELECT * FROM dbw_session_load_aggr_histr;

Job Dependencies

If the job fails, the cleanup process will drop these tables and the procedure:

DROP TABLE dbw_session_load_aggr_histr;
DROP TABLE dbw_session_load_histr;
DROP PROCEDURE dbw_session_load;

Implementation Details

The implementation involves several SQL queries and operations:

Reporting

The job includes a report template which provides detailed visualization and data on session statistics:

Tables and Presentations

Column Name Data Type Purpose
number Integer Represents the count of sessions (total or active)
Aggregation type String Indicates if the data is about total sessions or active sessions
History date Date The date on which the sessions were recorded

Upgrade Path

The job is critical in a database monitoring setup, especially for performance tuning and proactive management of database environments.