{"repo":"OpensourceICTSolutions/zabbix-mysql-partitioning-perl","free":true,"listed":false,"github":"https://github.com/OpensourceICTSolutions/zabbix-mysql-partitioning-perl","clone":"git clone https://github.com/OpensourceICTSolutions/zabbix-mysql-partitioning-perl.git","description":"This script is a script written in Perl to partition the Zabbix database tables in time based chunks. We can use this script to replace the Zabbix housekeeper process which tends to get too slow once you hit a certain database size.","language":"Perl","stars":47,"topics":["zabbix","mysql","partitioning","perl","database","mariadb","zabbix-server"],"license":"AGPL-3.0","category":"databases-storage","readme_excerpt":"Important notes/bugs: 1 The script is FIXED for MySQL 8. It works for both MySQL and MariaDB latest versions and should still work with older versions as well. 2 The weekly partitioning is FIXED. Thanks @beinvisible 3 Zabbix 6 removed the auditlog details table. The script is compatible with this version now, make sure to uncomment the fix for older Zabbix versions. 4 For RHEL9 based systems use the CRB repository (Rocky Linux 9 specific) to get Perl-DataTime. dnf config-manager --set-enabled crb 5 For ZBX7.0 a new table was added (history bin). As such, for older version we can comment the line that partitions this table. 6 Important note, big changes made in version 7.1.0. Entire logic for MySQL/MariaDB has been altered to allow for perl-DBD- compatibility. Logic regarding backwards compatibility has changed as well. Make sure to uncomment the correct lines (see blog post), the default is setup for MariaDB and Zabbix 7.0 Also, see common issues at the bottom of the blog post. Zabbix MySQL partitioning Perl script Welcome to the Opensource ICT Solutions GitHub, where you'll find all kinds of useful Zabbix resources. This script is a script written in Perl to partition the Zabbix database tables in time based chunks. We can use this script to replace the Zabbix housekeeper process which tends to get too slow once you hit a certain database size. With the use of MySQL partitioing using fixed History and Trend storage periods for all items we can mitigate this issue and grow ou","default_branch":null,"files":null,"tree":[],"storefront":"/r/OpensourceICTSolutions","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/OpensourceICTSolutions/zabbix-mysql-partitioning-perl/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}