There is zabbix 4.4.7 and the MariaDB 10.4 database. From the information available on the Internet, it turns out that if database partitioning is used, then in this case the zabbix built-in data cleaning is disabled through housekeeper, and data is deleted through the procedure, deleting the entire partitions. Can I partition a database and leave housekeeper turned on? Will housekeeper delete data in a partitioned database?
-
-
No mysql application sould be aware of partition structure, so it would still work, but you wouldn't get most of the benefits of partitioning. I think "empty" partitions would remain on disk even after all rows are gone, so no disk space would be recovered. You would also need to remove some parts of the commonly used stored procedures that involve deletion.
Comment