#!/bin/bash
# MySQL monitorization plugin for Pandora FMS agent
# Author: Manuel A. Gulín Bejarano
# Version: 1.0
# Date: 15/03/2013
#
# This program is free software: you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation, either version 3 of the License, or
#  (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.

function help {
	echo -e "MySQL monitorization agent plugin for Pandora FMS agent. http://pandorafms.com" 
	echo -e "Syntax:"
	echo -e "\t\t$0 '<dbuser>' 'dbpass'"
	exit
}

if [ $# -ne 2 ]
then
	help
	exit -1
fi


MY_USER="$1"
MY_PASS="$2"

# Info about static variables - all retrieved with one query, later it's going to be appropiately parsed
MY_VAR=`mysql -u $MY_USER -p"$MY_PASS" -Bse 'SHOW /*!50000 GLOBAL */ VARIABLES'`

# Info about dynamic variables - all retrieved with one query, later it going to be appropiately parsed
MY_STAT=`mysql -u $MY_USER -p"$MY_PASS" -Bse 'SHOW /*!50000 GLOBAL */ STATUS'`

# Info about use of Innodb, if enabled - all retrieved with one query, later it going to be appropiately parsed
MY_INNODB_ACTIVE=`echo $MY_ENG | grep -o "InnoDB [yesno-YESNO]*" | awk '{print $2}'`
if [ "$MY_INNODB_ACTIVE" == "YES" ]; then
	MY_INNO_STAT=`mysql -u $MY_USER -p"$MY_PASS" -Bse 'SHOW INNODB STATUS'`
fi

# Info about total number of databases and tables
MY_DBS_COUNT=`mysql -u $MY_USER -p"$MY_PASS" -Bse "SELECT COUNT(SCHEMA_NAME) FROM information_schema.SCHEMATA"`
MY_TABLES_COUNT=`mysql -u $MY_USER -p"$MY_PASS" -Bse "SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES"`

# Info about the total size of data and indexes in MB
MY_DATA_SIZE=`mysql -u $MY_USER -p"$MY_PASS" -Bse "SELECT SUM(data_length)/(1024*1024) FROM information_schema.TABLES"`
MY_INDEX_SIZE=`mysql -u $MY_USER -p"$MY_PASS" -Bse "SELECT SUM(index_length)/(1024*1024) FROM information_schema.TABLES"`

# General info about this MySQL system
MY_HOST=`echo $MY_VAR | grep -o ' hostname .*' | awk '{print $2}'`
MY_VERSION=`echo $MY_VAR | grep -o ' version .*' | awk '{print $2}'`
MY_ARCH=`echo $MY_VAR | grep -o ' version_compile_machine .*' | awk '{print $2}'`
MY_ENG=`echo $MY_VAR | grep -o "storage_engine [a-zA-Z]*" | awk '{print $2}'`
MY_ISO=`echo $MY_VAR | grep -o " tx_isolation .*" | awk '{print $2}'`
MY_UPTIME=`echo $MY_STAT | grep -o ' Uptime .*' | awk '{print $2}'`
MY_FLUSHUPTIME=`echo $MY_STAT | grep -o ' Uptime_since_flush_status .*' | awk '{print $2}'`
MY_UWOPASS=`mysql -u $MY_USER -p"$MY_PASS" -Bse "SELECT COUNT(CONCAT(user, '\@', host)) FROM mysql.user WHERE password = '' OR password IS NULL"`

# Info about general logging
MY_GENLOG=`echo $MY_VAR | grep -o " general_log [onfONF]*" | awk '{if (tolower($2) == "off") {print 0} else {print 1}}'`
MY_WARNLOG=`echo $MY_VAR | grep -o " log_warnings [01]" | awk '{print $2}'`

# Info about slow queries logging
MY_SLOWLOG=`echo $MY_VAR | grep -o " slow_query_log [onfONF]*" | awk '{if (tolower($2) == "off") {print 0} else {print 1}}'`
MY_SLOWLOGTIME=`echo $MY_VAR | grep -o " long_query_time [0-9.,]*" | awk '{print $2}'`

# Info about binary logging
MY_BINLOG=`echo $MY_VAR | grep -o " log_bin [onfONF]*" | awk '{if (tolower($2) == "off") {print 0} else {print 1}}'`
MY_BINLOGF=`echo $MY_VAR | grep -o " binlog_format .*" | awk '{print $2}'`
MY_SBINLOG=`echo $MY_VAR | grep -o " sync_binlog [0|1]" | awk '{print $2}'`
MY_BINCSIZE=`echo $MY_VAR | grep -o " binlog_cache_size [0-9]*" | awk '{print $2}'`
MY_BINMSIZE=`echo $MY_VAR | grep -o " max_binlog_size [0-9]*" | awk '{print $2}'`

# Info about files
MY_OPEN_FILES_LIMIT=`echo $MY_VAR | grep -o " open_files_limit [0-9]*" | awk '{print $2}'`
MY_OPEN_FILES=`echo $MY_STAT | grep -o "Open_files [0-9]*" | awk '{print $2}'`
MY_OPEN_FILES100=`echo $MY_OPEN_FILES $MY_OPEN_FILES_LIMIT | awk '{ if ($2>0) { print int($1*10000/$2)/100 } else { print 0 } }'`

# Info about connections
MY_CONN=`echo $MY_STAT | grep -o "Connections [0-9]*" | awk '{print $2}'`
MY_ABORT_CONN=`echo $MY_STAT | grep -o "Aborted_connects [0-9]*" | awk '{print $2}'`
MY_ABORT_CONN100=`echo $MY_ABORT_CONN $MY_CONN | awk '{ if ($2>0) { print int($1*10000/$2)/100 } else { print 0 } }'`
MY_MAXUSED_CONN=`echo $MY_STAT | grep -o "Max_used_connections [0-9]*" | awk '{print $2}'`
MY_MAX_CONN=`echo $MY_VAR | grep -o "max_connections [0-9]*" | awk '{print $2}'`
MY_MAX_CONN100=`echo $MY_MAXUSED_CONN $MY_MAX_CONN | awk '{ if ($2>0) { print int($1*10000/$2)/100 } else { print 0 } }'`

# Info about temporal tables
MY_TMP_TABLES=`echo $MY_STAT | grep -o "Created_tmp_tables [0-9]*" | awk '{print $2}'`
MY_DISKTMP_TABLES=`echo $MY_STAT | grep -o "Created_tmp_disk_tables [0-9]*" | awk '{print $2}'`
MY_DISKTMP_TABLES100=`echo $MY_DISKTMP_TABLES $MY_TMP_TABLES | awk '{ if (($1+$2)>0) { print int($1*10000/($1+$2))/100 } else { print 0 } }'`

# General info about queries
MY_SELECT=`echo $MY_STAT | grep -o "Com_select [0-9]*" | awk '{print $2}'`
MY_INSERT=`echo $MY_STAT | grep -o "Com_insert [0-9]*" | awk '{print $2}'`
MY_UPDATE=`echo $MY_STAT | grep -o "Com_update [0-9]*" | awk '{print $2}'`
MY_REPLACE=`echo $MY_STAT | grep -o "Com_replace [0-9]*" | awk '{print $2}'`
MY_DELETE=`echo $MY_STAT | grep -o "Com_delete [0-9]*" | awk '{print $2}'`
let MY_WRITES=$MY_INSERT+$MY_UPDATE+$MY_REPLACE+$MY_DELETE
MY_WRITES100=`echo $MY_SELECT $MY_WRITES | awk '{ if (($1+$2)>0) { print int($2*10000/($1+$2))/100 } else { print 0 } }'`
MY_SLOW_QUERIES=`echo $MY_STAT | grep -o "Slow_queries [0-9]*" | awk '{print $2}'`
MY_QUESTIONS=`echo $MY_STAT | grep -o "Questions [0-9]*" | awk '{print $2}'`
MY_SLOW_QUERIES100=`echo $MY_SLOW_QUERIES $MY_QUESTIONS | awk '{ if ($2>0) { print int($1*10000/$2)/100 } else { print 0 } }'`

# Info about buffers
MY_RD_BF_SIZE=`echo $MY_VAR | grep -o " read_buffer_size [0-9]*" | awk '{print $2}'`
MY_RD_RND_BF_SIZE=`echo $MY_VAR | grep -o " read_rnd_buffer_size [0-9]*" | awk '{print $2}'`
MY_SORT_BF_SIZE=`echo $MY_VAR | grep -o " sort_buffer_size [0-9]*" | awk '{print $2}'`
MY_JOIN_BF_SIZE=`echo $MY_VAR | grep -o " join_buffer_size [0-9]*" | awk '{print $2}'`

# Info about threads
MY_THREAD_STACK=`echo $MY_VAR | grep -o " thread_stack [0-9]*" | awk '{print $2}'`
let MY_PER_THREAD_BF=$MY_RD_BF_SIZE+$MY_RD_RND_BF_SIZE+$MY_SORT_BF_SIZE+$MY_JOIN_BF_SIZE+$MY_THREAD_STACK
let MY_ALL_THREAD_BF=$MY_PER_THREAD_BF*$MY_MAX_CONN
let MY_USED_THREAD_BF=$MY_PER_THREAD_BF*$MY_MAXUSED_CONN
MY_KEY_BF_SIZE=`echo $MY_VAR | grep -o " key_buffer_size [0-9]*" | awk '{print $2}'`
MY_MAX_HEAP_TABLE_SIZE=`echo $MY_VAR | grep -o " max_heap_table_size [0-9]*" | awk '{print $2}'`
if [ "$MY_INNODB_ACTIVE" == "YES" ]; then
	MY_INNODB_BUFFER_POOL_SIZE=`echo $MY_VAR | grep -o " innodb_buffer_pool_size [0-9]*" | awk '{print $2}'`
	MY_INNODB_ADDITIONAL_MEM_POOL_SIZE=`echo $MY_VAR | grep -o " innodb_addtional_mem_pool_size [0-9]*" | awk '{print $2}'`
	MY_INNODB_LOG_BUFFER_SIZE=`echo $MY_VAR | grep -o " innodb_log_buffer_size [0-9]*" | awk '{print $2}'`
	MY_INNODB_QUERY_CACHE_SIZE=`echo $MY_VAR | grep -o " innodb_query_cache_size [0-9]*" | awk '{print $2}'`
else
	MY_INNODB_BUFFER_POOL_SIZE=0
	MY_INNODB_ADDITIONAL_MEM_POOL_SIZE=0
	MY_INNODB_LOG_BUFFER_SIZE=0
	MY_INNODB_QUERY_CACHE_SIZE=0
fi
let MY_SERVER_BUFFERS=$MY_MAX_HEAP_TABLE_SIZE+$MY_KEY_BF_SIZE+$MY_INNODB_BUFFER_POOL_SIZE+$MY_INNODB_ADDITIONAL_MEM_POOL_SIZE+$MY_INNODB_LOG_BUFFER_SIZE+$MY_INNODB_QUERY_CACHE_SIZE

# Info about memory usage
let MY_USED_TOTAL_MEM=$MY_SERVER_BUFFERS+$MY_USED_THREAD_BF
MY_SYS_MEM=`free -b | grep "Mem:[ ]*[0-9]*" | awk '{print $2}'`
MY_MAX_TOTAL_MEM_VS_SYS=`echo $MY_MAX_TOTAL_MEM $MY_SYS_MEM |awk '{if ($2>0) {print int(10000*$1/$2)/100} else {print 0}}'`

# Info about key usage and its cache
MY_KEY_BLOCKS_UNUSED=`echo $MY_STAT | grep -o "Key_blocks_unused [0-9]*" | awk '{print $2}'`
MY_KEY_CACHE_BLOCK_SIZE=`echo $MY_VAR | grep -o " key_cache_block_size [0-9]*" | awk '{print $2}'`
MY_KEY_BLOCKS_USED100=`echo $MY_KEY_BLOCKS_UNUSED $MY_KEY_CACHE_BLOCK_SIZE $MY_KEY_BF_SIZE | awk '{if ($3>0) {print 100-int(10000*$1*$2/$3)/100} else {print 0}}'`
MY_KEY_READS=`echo $MY_STAT | grep -o "Key_reads [0-9]*" | awk '{print $2}'`
MY_KEY_READ_REQUESTS=`echo $MY_STAT | grep -o "Key_read_requests [0-9]*" | awk '{print $2}'`
MY_KEYS_FROM_MEM100=`echo $MY_KEY_READS $MY_KEY_READ_REQUESTS | awk '{if ($2>0) {print 100-int(10000*$1/$2)} else {print 0}}'`

# Info about query cache
MY_QCACHE_HITS=`echo $MY_STAT | grep -o " Qcache_hits [0-9]*" | awk '{print $2}'`
MY_QCACHE_INEFFICIENCY100=`echo $MY_QCACHE_HITS $MY_SELECT | awk '{if (($1+$2)>0) { print int(10000*$1/($1+$2))/100} else {print 100}}'`
MY_QCACHE_SIZE=`echo $MY_VAR | grep -o "query_cache_size [0-9]*" | awk '{print $2}'`
MY_QCACHE_FREE_MEM=`echo $MY_STAT | grep -o "Qcache_free_memory [0-9]*" | awk '{print $2}'`
MY_QCACHE_USED_MEM100=`echo $MY_QCACHE_FREE_MEM $MY_QCACHE_SIZE | awk '{print 100-int(100*$1/$2)/100}'`
MY_QCACHE_PRUNES=`echo $MY_STAT | grep -o "Qcache_lowmem_prunes [0-9]*" | awk '{print $2}'`
MY_QCACHE_PRUNES_DAY=`echo $MY_QCACHE_PRUNES $MY_UPTIME | awk '{if ($2>0) {print int(100*$1*86400/$2)/100} else {print 0}}'`

# Info about sorts
MY_SORT_SCAN=`echo $MY_STAT | grep -o "Sort_scan [0-9]*" | awk '{print $2}'`
MY_SORT_RANGE=`echo $MY_STAT | grep -o "Sort_range [0-9]*" | awk '{print $2}'`
let MY_SORT_TOTAL=$MY_SORT_SCAN+$MY_SORT_RANGE
MY_SORT_MERGE_PASSES=`echo $MY_STAT | grep -o "Sort_merge_passes [0-9]*" | awk '{print $2}'`
MY_SORTS_TEMP_TABLES100=`echo $MY_SORT_MERGE_PASSES $MY_SORT_TOTAL | awk '{if ($2>0) {print int(10000*$1/$2)/100} else {print 0}}'`

# Info about joins
MY_SEL_RANGE_CHECK=`echo $MY_STAT | grep -o "Select_range_check [0-9]*" | awk '{print $2}'`
MY_SEL_FULL_JOIN=`echo $MY_STAT | grep -o "Select_full_join [0-9]*" | awk '{print $2}'`
let MY_JOINS_WO_INDEXES=$MY_SEL_RANGE_CHECK+$MY_SEL_FULL_JOIN
MY_JOINS_WO_INDEXES100=`echo $MY_JOINS_WO_INDEXES $MY_UPTIME | awk '{if ($2>0) {print int(100*$1*86400/$2)/100} else {print 0}}'`

# Info about open tables
MY_OPEN_TABLES=`echo $MY_STAT | grep -o "Open_tables [0-9]*" | awk '{print $2}'`
MY_OPENED_TABLES=`echo $MY_STAT | grep -o "Opened_tables [0-9]*" | awk '{print $2}'`

# Info about caches
MY_TABLE_CACHE_HIT_RATE=`echo $MY_OPEN_TABLES $MY_OPENED_TABLES | awk '{if ($2>0) {print int(10000*$MY_OPEN_TABLES/$MY_OPENED_TABLES)/100} else {print 100}}'`
MY_TABLE_LOCKS_IMMEDIATE=`echo $MY_STAT | grep -o "Table_locks_immediate [0-9]*" | awk '{print $2}'`
MY_TABLE_LOCKS_WAITED=`echo $MY_STAT | grep -o "Table_locks_waited [0-9]*" | awk '{print $2}'`
MY_TABLE_LOCKS_IMMEDIATE100=`echo $MY_TABLE_LOCKS_IMMEDIATE $MY_TABLE_LOCKS_WAITED | awk '{ if ($1+$2>0) { print int(10000*$1/($1+$2))/100} else {print 100}}'`
MY_THREADS_CREATED=`echo $MY_STAT | grep -o "Threads_created [0-9]*" | awk '{print $2}'`
MY_THREAD_CACHE_HITRATE100=`echo $MY_THREADS_CREATED $MY_CONN | awk '{ if ($2>0) {print 100-int(10000*$1/$2)/100} else {print 100}}'`


#########################################################################################################
# GENERAL INFO MODULES
#########################################################################################################
# Module to get MySQL hostname
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Hostname]]></name>"
echo -e "\t<description><![CDATA[Hostname of MySQL]]></description>"
echo -e "\t<type>async_string</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_HOST]]></data>"
#echo -e "\t<crontab>0 * * * *</crontab>""
echo -e "\t</module>"

# Module to get MySQL version
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Version]]></name>"
echo -e "\t<description><![CDATA[Version of MySQL]]></description>"
echo -e "\t<type>async_string</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_VERSION $MY_ARCH]]></data>"
#echo -e "\t<crontab>0 * * * *</crontab>""
echo -e "\t</module>"

# Module to get the number of databases
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Databases (#)]]></name>"
echo -e "\t<description><![CDATA[Number of databses]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_DBS_COUNT]]></data>"
echo -e "\t</module>"

# Module to get the number of tables
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Tables (#)]]></name>"
echo -e "\t<description><![CDATA[Number of tables]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_TABLES_COUNT]]></data>"
echo -e "\t</module>"

# Module to get the size of stored data
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Size of data (MB)]]></name>"
echo -e "\t<description><![CDATA[Size of stored data in megabytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>MB</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_DATA_SIZE]]></data>"
echo -e "\t</module>"

# Module to get the size of stored indexes
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Size of indexes (MB)]]></name>"
echo -e "\t<description><![CDATA[Size of stored indexes in megabytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>MB</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_INDEX_SIZE]]></data>"
echo -e "\t</module>"

# Module to get the default engine
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Default engine]]></name>"
echo -e "\t<description><![CDATA[Default engine]]></description>"
echo -e "\t<type>async_string</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_ENG]]></data>"
#echo -e "\t<crontab>0 * * * *</crontab>""
echo -e "\t</module>"

# Module to get MySQL isolation level
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Isolation level]]></name>"
echo -e "\t<description><![CDATA[Transaction isolation level]]></description>"
echo -e "\t<type>async_string</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_ISO]]></data>"
#echo -e "\t<crontab>0 * * * *</crontab>""
echo -e "\t</module>"

# Module to get MySQL uptime
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Uptime (s)]]></name>"
echo -e "\t<description><![CDATA[Uptime in seconds]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>s</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_UPTIME]]></data>"
echo -e "\t</module>"

# Module to get MySQL uptime since last flush
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Uptime since flush (s)]]></name>"
echo -e "\t<description><![CDATA[Uptime since last flush in seconds]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>s</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_FLUSHUPTIME]]></data>"
echo -e "\t</module>"

# Module to get the number of users without password
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Users wo password (#)]]></name>"
echo -e "\t<description><![CDATA[Number of users without password]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<min_critical>1</min_critical>"
echo -e "\t<data><![CDATA[$MY_UWOPASS]]></data>"
echo -e "\t</module>"

#########################################################################################################
# GENERAL LOG INFO MODULES
#########################################################################################################
# Module to know if log is enabled
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Log enabled]]></name>"
echo -e "\t<description><![CDATA[General log enabled/disabled]]></description>"
echo -e "\t<type>async_proc</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_GENLOG]]></data>"
echo -e "\t</module>"

# Module to know if log is enabled
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Log warning enabled]]></name>"
echo -e "\t<description><![CDATA[Log warning enabled/disabled]]></description>"
echo -e "\t<type>async_proc</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_WARNLOG]]></data>"
echo -e "\t</module>"

#########################################################################################################
# SLOW LOG INFO MODULES
#########################################################################################################
# Module to know if log slow queries is enabled
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Slow queries - Log enabled]]></name>"
echo -e "\t<description><![CDATA[Slow queries log enabled/disabled]]></description>"
echo -e "\t<type>async_proc</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_SLOWLOG]]></data>"
echo -e "\t</module>"

# Module to know the time to a query as slow
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Slow queries - Slow log time (s)]]></name>"
echo -e "\t<description><![CDATA[Time in seconds to clasify a query as slow]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>s</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_SLOWLOGTIME]]></data>"
echo -e "\t</module>"

#########################################################################################################
# BINARY LOG INFO MODULES
#########################################################################################################
# Module to know if binlog is enabled
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Binlog - Log enabled]]></name>"
echo -e "\t<description><![CDATA[Binlog enabled/disabled]]></description>"
echo -e "\t<type>async_proc</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_BINLOG]]></data>"
echo -e "\t</module>"

# Module to know binlog format
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Binlog - Format]]></name>"
echo -e "\t<description><![CDATA[Binlog format]]></description>"
echo -e "\t<type>async_string</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_BINLOGF]]></data>"
#echo -e "\t<crontab>0 * * * *</crontab>""
echo -e "\t</module>"

# Module to know if binlog syncing is enabled
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Binlog - Sync enabled]]></name>"
echo -e "\t<description><![CDATA[Binlog syncing enabled/disabled]]></description>"
echo -e "\t<type>async_proc</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<data><![CDATA[$MY_SBINLOG]]></data>"
echo -e "\t</module>"

# Module to know the cache size of the binlog
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Binlog - Cache size (b)]]></name>"
echo -e "\t<description><![CDATA[Binlog cache size in bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_BINCSIZE]]></data>"
echo -e "\t</module>"

# Module to know the cache size of the binlog
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Binlog - Max size (b)]]></name>"
echo -e "\t<description><![CDATA[Binlog max size in bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_BINMSIZE]]></data>"
echo -e "\t</module>"

#########################################################################################################
# OPEN FILES INFO MODULES
#########################################################################################################
# Module to know the number of open files
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Open files (#)]]></name>"
echo -e "\t<description><![CDATA[Number of open files]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>$MY_OPEN_FILES_LIMIT</max>"
echo -e "\t<data><![CDATA[$MY_OPEN_FILES]]></data>"
echo -e "\t</module>"

# Module to know the % of open files
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Open files (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of open files]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_warning>85</min_warning>"
echo -e "\t<max_warning>94.99</max_warning>"
echo -e "\t<min_critical>95</min_critical>"
echo -e "\t<max_critical>100</max_critical>"
echo -e "\t<data><![CDATA[$MY_OPEN_FILES100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# CONNECTION INFO MODULES
#########################################################################################################
# Module to know the number of connection attempts
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Connections - Attempts (#)]]></name>"
echo -e "\t<description><![CDATA[Total number of connections attempts]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>conn</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_CONN]]></data>"
echo -e "\t</module>"

# Module to know the number of aborted connections
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Connections - Aborted (#)]]></name>"
echo -e "\t<description><![CDATA[Number of aborted connection]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>conn</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_ABORT_CONN]]></data>"
echo -e "\t</module>"

# Module to know the % of aborted connections
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Aborted connections (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of aborted connections]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_warning>5</min_warning>"
echo -e "\t<max_warning>9.99</max_warning>"
echo -e "\t<min_critical>10</min_critical>"
echo -e "\t<max_critical>100</max_critical>"
echo -e "\t<data><![CDATA[$MY_ABORT_CONN100]]></data>"
echo -e "\t</module>"

# Module to know the maximum number of used connections
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Connections - Max used (#)]]></name>"
echo -e "\t<description><![CDATA[Maximum number of simultaneous connections]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>conn</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_MAXUSED_CONN]]></data>"
echo -e "\t</module>"

# Module to know the maximum number of connections
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Connections - Max (#)]]></name>"
echo -e "\t<description><![CDATA[Maximum number of connections]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>conn</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_MAX_CONN]]></data>"
echo -e "\t</module>"

# Module to know the maximum % of simultaneous connections
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Max simultaneous connections (%)]]></name>"
echo -e "\t<description><![CDATA[Maximum percentage of simultaneous connections]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_warning>85</min_warning>"
echo -e "\t<max_warning>94.99</max_warning>"
echo -e "\t<min_critical>95</min_critical>"
echo -e "\t<max_critical>100</max_critical>"
echo -e "\t<data><![CDATA[$MY_MAX_CONN100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# TEMPORAL TABLES INFO MODULES
#########################################################################################################
# Module to know the number of temporal tables created in memroy
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Temporal tables - In memory (#)]]></name>"
echo -e "\t<description><![CDATA[Number of temporal tables created in memory]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>tables</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_TMP_TABLES]]></data>"
echo -e "\t</module>"

# Module to know the number of temporal tables created in disk
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Temporal tables - In disk (#)]]></name>"
echo -e "\t<description><![CDATA[Number of temporal tables created in disk]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>tables</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_DISKTMP_TABLES]]></data>"
echo -e "\t</module>"

# Module to know the % of temporal disk tables
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Temporal tables in disk (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of temporal disk tables]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_warning>25</min_warning>"
echo -e "\t<max_warning>34.99</max_warning>"
echo -e "\t<min_critical>35</min_critical>"
echo -e "\t<max_critical>100</max_critical>"
echo -e "\t<data><![CDATA[$MY_DISKTMP_TABLES100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# GENERAL QUERIES INFO MODULES
#########################################################################################################
# Module to know the number of read queries
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Questions - Reads (#)]]></name>"
echo -e "\t<description><![CDATA[Number of read questions]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>qu</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_SELECT]]></data>"
echo -e "\t</module>"

# Module to know the number of write queries
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Questions - Writes (#)]]></name>"
echo -e "\t<description><![CDATA[Number of write questions]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>qu</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_WRITES]]></data>"
echo -e "\t</module>"

# Module to know the % of writes
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Write operations (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of write operations]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<data><![CDATA[$MY_WRITES100]]></data>"
echo -e "\t</module>"

# Module to know the number of slow queries
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Questions - Slow queries (#)]]></name>"
echo -e "\t<description><![CDATA[Number of slow queries]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>qu</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_SLOW_QUERIES]]></data>"
echo -e "\t</module>"

# Module to know the number of questions sent to the server
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Questions - Total (#)]]></name>"
echo -e "\t<description><![CDATA[Total number of questions]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>qu</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_QUESTIONS]]></data>"
echo -e "\t</module>"

# Module to know the % of slow queries
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Slow queries (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of slow queries]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_warning>5</min_warning>"
echo -e "\t<max_warning>14.99</max_warning>"
echo -e "\t<min_critical>15</min_critical>"
echo -e "\t<max_critical>100</max_critical>"
echo -e "\t<data><![CDATA[$MY_SLOW_QUERIES100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# BUFFER AND MEMORY INFO MODULES
#########################################################################################################
# Module to get the size of the buffer of each possible thread
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Memory - Buffer size of 1 thread (b)]]></name>"
echo -e "\t<description><![CDATA[Buffer size of each possible thread in bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_PER_THREAD_BF]]></data>"
echo -e "\t</module>"

# Module to get the max. size of the buffer of all threads
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Memory - Buffer size of all $MY_MAX_CONN threads (b)]]></name>"
echo -e "\t<description><![CDATA[Max buffer size of all threads in bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_ALL_THREAD_BF]]></data>"
echo -e "\t</module>"

# Module to get the max. used size of the buffer of simultaneous threads
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Buffer size of $MY_MAXUSED_CONN simultaneous threads (b)]]></name>"
echo -e "\t<description><![CDATA[Max buffer size of simultaneous used threads in bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>$MY_ALL_THREAD_BF</max>"
echo -e "\t<data><![CDATA[$MY_USED_THREAD_BF]]></data>"
echo -e "\t</module>"

# Module to get the size of the buffer of the server
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Memory - Buffer size (b)]]></name>"
echo -e "\t<description><![CDATA[Global buffer size of the server in bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_SERVER_BUFFERS]]></data>"
echo -e "\t</module>"

# Module to get the max. possible consumed memory
let MY_MAX_TOTAL_MEM=$MY_SERVER_BUFFERS+$MY_ALL_THREAD_BF
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Memory - Max possible (b)]]></name>"
echo -e "\t<description><![CDATA[Max possible memory consumedin bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_MAX_TOTAL_MEM]]></data>"
echo -e "\t</module>"

# Module to get the max. used memory
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Memory - Max used (b)]]></name>"
echo -e "\t<description><![CDATA[Max memory consumed in bytes]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_USED_TOTAL_MEM]]></data>"
echo -e "\t</module>"

# Module to get the % of max possible consumed memory vs memory on the system
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Memory - Max possible VS Sys (%)]]></name>"
echo -e "\t<description><![CDATA[Max possible percentage of memory consumed vs system memory]]></description>"
echo -e "\t<type>async_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_warning>90</min_warning>"
echo -e "\t<max_warning>99.99</max_warning>"
echo -e "\t<min_critical>100</min_critical>"
echo -e "\t<data><![CDATA[$MY_MAX_TOTAL_MEM_VS_SYS]]></data>"
echo -e "\t</module>"

# Module to know the % of used key buffer
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Used key buffer (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of used key buffer]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<data><![CDATA[$MY_KEY_BLOCKS_USED100]]></data>"
echo -e "\t</module>"

# Module to know the % of keys retrieved from memory
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Key requests from memory (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of key requests retrieved from memory]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_critical>0</min_critical>"
echo -e "\t<max_critical>80</max_critical>"
echo -e "\t<min_warning>80.01</min_warning>"
echo -e "\t<max_warning>95</max_warning>"
echo -e "\t<data><![CDATA[$MY_KEYS_FROM_MEM100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# QUERY CACHE INFO MODULES
#########################################################################################################
# Module to know the number of query cache hits
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Query cache - Hits (#)]]></name>"
echo -e "\t<description><![CDATA[Number of query cache hits]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_QCACHE_HITS]]></data>"
echo -e "\t</module>"

# Module to know the query cache efficiency
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Query cache efficiency (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of selects retrieved from cache]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_critical>0</min_critical>"
echo -e "\t<max_critical>5</max_critical>"
echo -e "\t<min_warning>5.01</min_warning>"
echo -e "\t<max_warning>20</max_warning>"
echo -e "\t<data><![CDATA[$MY_QCACHE_INEFFICIENCY100]]></data>"
echo -e "\t</module>"

# Module to know the free memory of query cache
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Query cache - Free memory (b)]]></name>"
echo -e "\t<description><![CDATA[Query cache free memory in bytes]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>b</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>$MY_QCACHE_SIZE</max>"
echo -e "\t<data><![CDATA[$MY_QCACHE_FREE_MEM]]></data>"
echo -e "\t</module>"

# Module to know the free memory of query cache
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Query cache used memory (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of query cache memory used]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<data><![CDATA[$MY_QCACHE_USED_MEM100]]></data>"
echo -e "\t</module>"

# Module to know the number of query cache prunes
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Query cache - Prunes (#)]]></name>"
echo -e "\t<description><![CDATA[Number of query cache prunes]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_QCACHE_PRUNES]]></data>"
echo -e "\t</module>"

# Module to estimate the number of query cache prunes per day
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Query cache prunes (#/day)]]></name>"
echo -e "\t<description><![CDATA[Number of query cache prunes per day]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#/day</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<min_warning>100</min_warning>"
echo -e "\t<data><![CDATA[$MY_QCACHE_PRUNES_DAY]]></data>"
echo -e "\t</module>"

# Module to know the % of cache hit rate
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Table cache hit rate (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of table cache hits]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_critical>0</min_critical>"
echo -e "\t<max_critical>19.99</max_critical>"
echo -e "\t<min_warning>20</min_warning>"
echo -e "\t<max_warning>30</max_warning>"
echo -e "\t<data><![CDATA[$MY_TABLE_CACHE_HIT_RATE]]></data>"
echo -e "\t</module>"

#########################################################################################################
# SORTS INFO MODULES
#########################################################################################################
# Module to know the number of sorts
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Sorts - Total (#)]]></name>"
echo -e "\t<description><![CDATA[Total number of sorts]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_SORT_TOTAL]]></data>"
echo -e "\t</module>"

# Module to know the % of sorts requiring temporal tables
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Sorts using temp tables (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of selects retrieved from cache]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_warning>10</min_warning>"
echo -e "\t<max_warning>19.99</max_warning>"
echo -e "\t<min_critical>20</min_critical>"
echo -e "\t<max_critical>100</max_critical>"
echo -e "\t<data><![CDATA[$MY_SORTS_TEMP_TABLES100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# JOINS INFO MODULES
#########################################################################################################
# Module to know the number of joins without indexes
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Joins - Wo indexes (#)]]></name>"
echo -e "\t<description><![CDATA[Total number of joins without indexes]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<data><![CDATA[$MY_JOINS_WO_INDEXES]]></data>"
echo -e "\t</module>"

# Module to estimate the number of joins without indexes per day
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Wo indexes (#/day)]]></name>"
echo -e "\t<description><![CDATA[Joins without indexes per day]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>#/day</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<min_warning>250</min_warning>"
echo -e "\t<data><![CDATA[$MY_JOINS_WO_INDEXES100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# TABLE LOCKS INFO MODULES
#########################################################################################################
# Module to know the table locks aquired immediatly
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Table locks immediate (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of table locks aquired immediatly]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_critical>0</min_critical>"
echo -e "\t<max_critical>89.99</max_critical>"
echo -e "\t<min_warning>90</min_warning>"
echo -e "\t<max_warning>95</max_warning>"
echo -e "\t<data><![CDATA[$MY_TABLE_LOCKS_IMMEDIATE100]]></data>"
echo -e "\t</module>"

#########################################################################################################
# THREAD CACHE INFO MODULES
#########################################################################################################
# Module to know the % of connections that do NOT need to create a thread
echo -e "\t<module>"
echo -e "\t<name><![CDATA[MySQL: Performance - Thread cache hit rate (%)]]></name>"
echo -e "\t<description><![CDATA[Percentage of connections that do not need to create a thread]]></description>"
echo -e "\t<type>generic_data</type>"
echo -e "\t<disabled>0</disabled>"
echo -e "\t<unit>%</unit>"
echo -e "\t<min>0</min>"
echo -e "\t<max>100</max>"
echo -e "\t<min_critical>0</min_critical>"
echo -e "\t<max_critical>89.99</max_critical>"
echo -e "\t<min_warning>90</min_warning>"
echo -e "\t<max_warning>95</max_warning>"
echo -e "\t<data><![CDATA[$MY_THREAD_CACHE_HITRATE100]]></data>"
echo -e "\t</module>"