Temporary table check


Job details

Name: Temporary table check
Platform: Mariadb
Category: Performance
Description: Shows percentage of temporary tables written to disk
Long description: Task shows the percentage of temporary tables which have been written to disk
Version: 2.32
Default schedule: 3,13,23,33,43,53 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & is_mariadb_branch=‘1′]/.[hasengine=‘YES’ & global_status_information_schema = ‘1′ ]

Parameters

Name Default value Description
ratio warning threshold 50 If this threshold is reached over a period of time (controlled by parameters “warning threshold (time)”), a warning is returned. At the same time, the average value of CREATED_TMP_TABLES per second must be higher than the “min CREATED_TMP_TABLES“ parameter value for the entire time period.
ratio alarm threshold 80 If this threshold is reached over a period of time (controlled by parameters “alarm threshold (time)”), an alarm is returned. At the same time, the average value of CREATED_TMP_TABLES per second must be higher than the “min CREATED_TMP_TABLES“ parameter value for the entire time period.
keep data for 7 The number of days to keep the data for.
alarm threshold (time) 30 A period of time (in minutes) which must be passed (combined with average values of CREATED_TMP_TABLES) before an alarm is returned by the procedure.
warning threshold (time) 30 A period of time (in minutes) which must be passed (combined with average values of CREATED_TMP_TABLES) before a warning is returned by the procedure.
min CREATED_TMP_TABLES 100 The minimum average value of CREATED_TMP_TABLES per seconds (over a period of time defined by the [time threshold] parameter) before a warning or an alarm is triggered.
enable warnings and alarms NO If set to “NO” (default), the alert will only collect statistics without returning status warning or alarm. Value “YES“ will activate the alert.

Job Summary

SELECT variable_name, variable_value FROM dbw_tmp_table_check_status;

Job Description

Implementation Details

Dependency and Cleanup

Dependency Object Object Type Description Cleanup on Failure
dbw_tmp_table_check Procedure Dependency procedure true
dbw_tmp_table_check_histr Table Stores historical data of checks true
dbw_tmp_table_check_last Table Stores the last recorded values true
dbw_tmp_table_check_status Table Stores current status and variables true

Reporting

This structured reporting aids in proactive database management, helping to adjust system settings to optimize performance and avoid potential slowdowns due to excessive disk-based temporary table usage.