indexes in Zabbix MySQL database schema ** Redundant indexes were removed in several Zabbix MySQL database tables. This should improve performance and slightly reduce the database size for MySQL users in these on child-table columns having foreign key constraints Such indexes were created automatically on MySQL, now they are created also on PostgreSQL, Oracle, DB2 to improve performance of Zabbix server and be set to 0.0001 seconds. 18.3 Miscellaneous improvements Fixed issues with mysql user parameter configuration script mysql.size parameter. It con- tained a complex bash expression and was failing if

will be set to 0.0001 seconds. 3 Miscellaneous improvements Fixed issues with mysql user parameter configuration script mysql.size parameter. It contained a complex bash expression and was failing if the line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m

line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m requires a separate database. Attention: Note that databases supported with Zabbix proxy are SQLite, MySQL and PostgreSQL. Using Oracle or IBM DB2 is at your own risk and may contain some limitations as,

line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m requires a separate database. Attention: Note that databases supported with Zabbix proxy are SQLite, MySQL and PostgreSQL. Using Oracle or IBM DB2 is at your own risk and may contain some limitations as,

Parameter structure for Zabbix agent 2 plugins has been updated: • For Ceph, Docker, Memcached, MySQL, Oracle, and Redis plugins, a Uri can now only be specified as a named session parameter. • For SharePont Microsoft SharePoint by HTTP - see setup instructions for HTTP templates. MongoDB • MongoDB cluster by Zabbix agent 2 • MongoDB node by Zabbix agent 2 See setup instructions for Zabbix agent 2 templates monitoring of TiDB server of TiDB cluster via HTTP; • TiDB PD by HTTP - monitoring of PD server of TiDB cluster via HTTP; • TiDB TiKV by HTTP - monitor TiKV server of TiDB cluster via HTTP. See setup instructions

item, referencing the current host sum(last_foreach(/*/vfs.fs.size[/,total]?[group=”MySQL Servers”])) grpsum[”MySQL Servers”,”vfs.fs.size[/,total]”,last] Aggregate calculation (formerly, aggregate performance. Starting from Zabbix 5.4, the following database versions are officially supported: • MySQL/Percona 5.7.28-8.0.X • MariaDB 10.0.37-10.5.X • PostgreSQL 10.9-13.X • Oracle 12.1.0.2 - 19c • setupfor more information. Items VMware cluster performance counters A new vmware.cl.perfcounter[,,,] item allows to retrieve VMware cluster performance counter metrics. JMX items

line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m requires a separate database. Attention: Note that databases supported with Zabbix proxy are SQLite, MySQL and PostgreSQL. Using Oracle or IBM DB2 is at your own risk and may contain some limitations as,

• remove host • enable host • remove from host group • unlink from template MySQL 8.0 supported Support for MySQL 8.0 has been added. Date-based indices setup for Elasticsearch In order to properly about the oc- curred problem. Database down message from now on consists of the following content: [MySQL|PostgreSQL|Oracle|IBM DB2] database [on :] is not available: MySQL. Internal events can be disabled Internal events will not be created, if all internal actions for

Secure connections to Zabbix database It is now possible to configure secure TLS connections to MySQL and PostgreSQL databases from: • Zabbix frontend • Zabbix server or proxy Restricting agent checks Memcached instances (see description). MySQL monitoring plugin A MySQL plugin for Zabbix agent 2 is now available as part of the out-of-the-box monitoring of MySQL instances (see description). Agent 2 Minimum required versions updated The minimum required versions for supported databases now are: • MySQL 5.5.62 • MariaDB 10.0.37 • PostgreSQL 9.2.24 • Oracle 11.2 TimescaleDB native compression support

RabbitMQ cluster by Zabbix agent and Template App RabbitMQ node by Zabbix agent - collect metrics by polling RabbitMQ management plugin with Zabbix agent locally; • Template App RabbitMQ cluster by HTTP - collect metrics by polling RabbitMQ management plugin with HTTP agent remotely. MySQL/MariaDB • Template DB MySQL by Zabbix agent - see requirements for operating this template. PostgreSQL • Template has been added. Previously only libssh2 was supported for SSH checks. New template Template DB MySQL by ODBC has been added. See requirements for operating this template. DB character set and collation