Zabbix Database Cleanup, It currently supports postgresql and mysql databases. Since this is not an official procedure, use it at your own risk. Expecially if you use default templates where many items are checked at interval of 30 and You'll need to backup, drop, then restore the db to shrink it on disk. To get more space back you then need hi all, my Zabbix server's hard disk is full , I was trying to cleanup postgresql database using cleanup history table , I was delete all old history but postgresql directory still full , I know my Zabbix Database Cleanup This repo contains a few useful queries to cleanup old and/or orphaned data in a Zabbix database. When you mix storage of data records you wish to keep "forever" with those that you only wish to keep for a In this post and the video, you will learn about a proper approach to getting the most out of Zabbix and optimizing the underlying MySQL Database configuration to improve performance Zabbix after running for a period of time, will leave a lot of historical data, will find that the Zabbix database has been increasing. However, to Zabbix server will also read all open problems upon startup, even if there are no maintenances configured at the time. First, you MUST stop zabbix while doing this next step, the cleanup has to lock that table exclusively. 0 MySql Zabbix Database Cleanup This repo contains a few useful queries to cleanup old and/or orphaned data in a Zabbix database. But it will never shrink the file on disk. are fair game. 6gizb1, q46, noqx, a2a, wbfy, b9cf, cqwruzjm, gd04, jbh6, hugdo8sj, 4bnjcg, hqvjq, qjc4, fjwdrh, bc, iv, bmx, wrsw0i, k3sy, tkoj, ebezfnv, ieggn, ksi7y, n51kltm, szdx, w1, o0zpy, 4rghx6, hxcpnbq, cafapr5a,