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_performance_schema = ‘1′ ]

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

Purpose: The purpose of this monitoring job, named “Session load”, is to track the number of both active and inactive sessions over time in a MySQL environment. It is part of the “Performance” category of jobs under dbWatch Control Center.
Why: This job is crucial for maintaining a pulse on the load of a database by monitoring the session activity. Quantifying the number of active and inactive sessions could provide insight into potential bottlenecks or idle resources in the database. This could ideally lead to performance optimizations and better resource management.
Manual checking: You can manually perform this job in the database by executing the SQL commands written in the code blocks under the <implementation> tag.

Version: The version of this job is 2.22.
Scheduling: This task is scheduled to run at every 10th minute of every hour (0,10,20,30,40,50).
Dependencies: This job relies on the proper functioning of “dbw_session_load”, “dbw_session_load_histr”, and “dbw_session_load_aggr_histr” procedures/tables.

Title: The report resulting from this job is titled “Session load”.
Description: The report description indicates that it outlines “Session statistics.”

The implementation details include:
- Creating tables such as “dbw_session_load_histr” and “dbw_session_load_aggr_histr”.
- Implementing SQL procedures to track and manage active and inactive sessions.
- Removing historical data that exceeds a set limit (default is seven days).
- Updating job values, inserting session load history, and so on.

The report generated by this job has two main presentations:

Session Statistics: Displays the number of total and active session over time.
Average Session Statistics: Shows the average session load per day. Gives a good indication of how the general session load of the server is changing.