Page Menu
Home
GitPull.it
Search
Configure Global Search
Log In
Files
F15172073
zabbix_template_mariadb_sleep_connections-v4.xml
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Authored By
Unknown
Size
12 KB
Referenced Files
None
Subscribers
None
zabbix_template_mariadb_sleep_connections-v4.xml
View Options
<?xml version="1.0" encoding="UTF-8"?>
<zabbix_export>
<version>
4.0
</version>
<date>
2025-12-17T16:26:23Z
</date>
<groups>
<group>
<name>
ER
</name>
</group>
</groups>
<templates>
<template>
<template>
Template
ER
MariaDB
</template>
<name>
Template
ER
MariaDB
</name>
<description/>
<groups>
<group>
<name>
ER
</name>
</group>
</groups>
<applications/>
<items>
<item>
<name>
MariaDB
connections
</name>
<type>
2
</type>
<snmp_community/>
<snmp_oid/>
<key>
er.mariadb.connections
</key>
<delay>
0
</delay>
<history>
90d
</history>
<trends>
365d
</trends>
<status>
0
</status>
<value_type>
3
</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>
0
</snmpv3_securitylevel>
<snmpv3_authprotocol>
0
</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>
0
</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params/>
<ipmi_sensor/>
<authtype>
0
</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>
Amount
of
MariaDB
threads
currently
running.
That
is,
the
amount
of
concurrent
MariaDB
connections.
</description>
<inventory_link>
0
</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>
3s
</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>
200
</status_codes>
<follow_redirects>
1
</follow_redirects>
<post_type>
0
</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>
0
</retrieve_mode>
<request_method>
0
</request_method>
<output_format>
0
</output_format>
<allow_traps>
0
</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>
0
</verify_peer>
<verify_host>
0
</verify_host>
<master_item/>
</item>
</items>
<discovery_rules>
<discovery_rule>
<name>
ER
Database
discovery
</name>
<type>
2
</type>
<snmp_community/>
<snmp_oid/>
<key>
er.mariadb.database.discovery
</key>
<delay>
0
</delay>
<status>
0
</status>
<allowed_hosts/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>
0
</snmpv3_securitylevel>
<snmpv3_authprotocol>
0
</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>
0
</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params/>
<ipmi_sensor/>
<authtype>
0
</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<filter>
<evaltype>
0
</evaltype>
<formula/>
<conditions>
<condition>
<macro>
{#DB}
</macro>
<value>
^(information_schema|mysql|performance_schema|sys|zabbix|zabbix_proxy)
$
</value>
<operator>
9
</operator>
<formulaid>
A
</formulaid>
</condition>
</conditions>
</filter>
<lifetime>
30d
</lifetime>
<description/>
<item_prototypes>
<item_prototype>
<name>
MariaDB
database
{#DB}:
sleep
connections
</name>
<type>
2
</type>
<snmp_community/>
<snmp_oid/>
<key>
er.mariadb.database[{#DB},sleeps]
</key>
<delay>
0
</delay>
<history>
90d
</history>
<trends>
0
</trends>
<status>
0
</status>
<value_type>
3
</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>
0
</snmpv3_securitylevel>
<snmpv3_authprotocol>
0
</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>
0
</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params/>
<ipmi_sensor/>
<authtype>
0
</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>
0
</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>
3s
</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>
200
</status_codes>
<follow_redirects>
1
</follow_redirects>
<post_type>
0
</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>
0
</retrieve_mode>
<request_method>
0
</request_method>
<output_format>
0
</output_format>
<allow_traps>
0
</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>
0
</verify_peer>
<verify_host>
0
</verify_host>
<application_prototypes/>
<master_item/>
</item_prototype>
</item_prototypes>
<trigger_prototypes>
<trigger_prototype>
<expression>
{Template
ER
MariaDB:er.mariadb.database[{#DB},sleeps].min(6d)}
>
{
$
ER_MARIADB_TOO_MANY_SLEEP_CONNECTIONS}
</expression>
<recovery_mode>
0
</recovery_mode>
<recovery_expression/>
<name>
MariaDB
database
{#DB}:
too
many
sleep
connections
-
consider
reducing
the
connection
pool
</name>
<correlation_mode>
0
</correlation_mode>
<correlation_tag/>
<url/>
<status>
0
</status>
<priority>
0
</priority>
<description>
https://sviluppo.erinformatica.it/T2394
</description>
<type>
0
</type>
<manual_close>
0
</manual_close>
<dependencies/>
<tags/>
</trigger_prototype>
</trigger_prototypes>
<graph_prototypes>
<graph_prototype>
<name>
MariaDB
database
{#DB}:
minimum
sleep
connections
</name>
<width>
1200
</width>
<height>
300
</height>
<yaxismin>
0.0000
</yaxismin>
<yaxismax>
100.0000
</yaxismax>
<show_work_period>
1
</show_work_period>
<show_triggers>
1
</show_triggers>
<type>
0
</type>
<show_legend>
1
</show_legend>
<show_3d>
0
</show_3d>
<percent_left>
0.0000
</percent_left>
<percent_right>
0.0000
</percent_right>
<ymin_type_1>
1
</ymin_type_1>
<ymax_type_1>
0
</ymax_type_1>
<ymin_item_1>
0
</ymin_item_1>
<ymax_item_1>
0
</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>
0
</sortorder>
<drawtype>
4
</drawtype>
<color>
199C0D
</color>
<yaxisside>
0
</yaxisside>
<calc_fnc>
7
</calc_fnc>
<type>
0
</type>
<item>
<host>
Template
ER
MariaDB
</host>
<key>
er.mariadb.database[{#DB},sleeps]
</key>
</item>
</graph_item>
</graph_items>
</graph_prototype>
</graph_prototypes>
<host_prototypes/>
<jmx_endpoint/>
<timeout>
3s
</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>
200
</status_codes>
<follow_redirects>
1
</follow_redirects>
<post_type>
0
</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>
0
</retrieve_mode>
<request_method>
0
</request_method>
<allow_traps>
0
</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>
0
</verify_peer>
<verify_host>
0
</verify_host>
</discovery_rule>
</discovery_rules>
<httptests/>
<macros>
<macro>
<macro>
{
$
ER_MARIADB_TOO_MANY_SLEEP_CONNECTIONS}
</macro>
<value>
40
</value>
</macro>
</macros>
<templates/>
<screens/>
</template>
</templates>
<graphs>
<graph>
<name>
MariaDB
concurrent
connections
</name>
<width>
1200
</width>
<height>
300
</height>
<yaxismin>
0.0000
</yaxismin>
<yaxismax>
100.0000
</yaxismax>
<show_work_period>
1
</show_work_period>
<show_triggers>
1
</show_triggers>
<type>
0
</type>
<show_legend>
1
</show_legend>
<show_3d>
0
</show_3d>
<percent_left>
0.0000
</percent_left>
<percent_right>
0.0000
</percent_right>
<ymin_type_1>
1
</ymin_type_1>
<ymax_type_1>
0
</ymax_type_1>
<ymin_item_1>
0
</ymin_item_1>
<ymax_item_1>
0
</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>
0
</sortorder>
<drawtype>
4
</drawtype>
<color>
199C0D
</color>
<yaxisside>
0
</yaxisside>
<calc_fnc>
7
</calc_fnc>
<type>
0
</type>
<item>
<host>
Template
ER
MariaDB
</host>
<key>
er.mariadb.connections
</key>
</item>
</graph_item>
</graph_items>
</graph>
</graphs>
</zabbix_export>
File Metadata
Details
Attached
Mime Type
text/xml
Expires
Thu, Nov 19, 00:59 (11 h, 4 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2263610
Default Alt Text
zabbix_template_mariadb_sleep_connections-v4.xml (12 KB)
Attached To
Mode
R69 Zabbix Template MariaDB sleep connections
Attached
Detach File
Event Timeline