Database management issue

[pt_tomcat]

I am using zabbix 1.8.5 with Mysql to monitor over 150 servers.

Currently I am facing two problems.

First problem is housekeeping : I setup housekeeping on web interface.
I set action not keep older than 30 days and event more than 180 days.
But still...

[samonrichard]

Your Zabbix database keeps growing because MySQL doesn’t release space after deletes—run OPTIMIZE TABLE on large history tables or use partitioning for better housekeeping. For backups, use mysqldump --single-transaction --quick or switch to Percona XtraBackup. Regular optimization with proper database...

[ottow]

Hi,

We've been running Zabbix (7.0.4) for some months now, and are currently monitoring about 1900 hosts which are a mix of Linux, Windows, Network devices and Selenium Synthetics.
We are getting quite concerned about the database growth (Postgres), the DB size (on disk) keeps increasing...

[irisseven]

We have dozens of web servers & databases running close to 1000 customer websites ranging from simple html sites to very complex web applications with multiple service and database dependencies.
This is hosted in a mixed virtualized ( VMWare ) / bare metal ( hardware ) environment across...

[WebGreg]

Hi.

What is your experience with database growth? I'm a newbie who was surprised that the database was growing over 1GB per day. Currently, 44 hosts (including 27 switches).
Administration > Housekeeping > Data storage period > 365d... The same "Trigger data storage...

[tonitsh]

Hello. I am running zabbix with postgres 14 + timescaledb 2.13.1
I have an issue. I noticed my db size growing significantly and when i check timescaledb_information.jobs i see the jobs, but next_start and initial_start values are empty. The rest of the data seems to be present.
in UI i...

[Beetle]

We have a Zabbix 6 instance from that we have upgraded to Zabbix 7 one month ago. During the time we have found the DB size of v.7 is grown almost double the size as v.6. So Is there any known issues faced by anyone post upgrade to Zabbix 7.

Zabbix 6:
Database Type - Postgresql -...

[Jeff54]

Hi everyone,

I clone the VM of one of a good proxy and use it to replace the one where I face this problem but I have the same issue.
So the parameters like housekeeping for example seems to be good

The mnt/database has a directory 16385 (don't understand why this name)...

[Judge_Dredd]

Hi all,
We are currently monitoring several hundred servers, 100+ switches etc. The Zabbix server has repeatedly run out of space in recent weeks. The ibdata1 file is closing on on 700GB. I am on the understanding that the growth of this file is a "feature" of MySQL. I am certainly not...

[MickeyPM]

Hi @cyber
I was just expanding and giving more detail on the issue my collegue StefanK posted.

The database recently grew to 1.2TB, and we dumped the database excluding the history and trends.
The new database was 175GB and now a months later we are again on 500+GB and still...

[Brambo]

Hi

I have a growing DB / used storage even when for a longer time no new hosts/items are added.
Strange thing I notice is that the used storage increases after a run of the housekeeper.
See graph:
The blue increase is about 100MB, the Yellow 110MB.
I made a change...

[bberryFLRC]

We have Zabbix installed using a MariaDB database and have been having an issue where ibdata was growing from undo logs starting about a month ago with no changes we could see to cause it. Zabbix was migrated to a new server with MariaDB 10.11 installed and the issue has followed. MariaDB is currently...

[karanpreetsingh1990]

Hello,

I'm quite new to zabbix and still getting the hang of things and I've been facing an issue with the proxy database size.

We do have a large number of hosts/items reporting in to the proxy but the size seems to grow very large within a couple of weeks. The current size...

[sbdcunha]

Dear All,
I have the below Zabbix Server and its working fine but I feel the database is growing recently

zabbix_server (Zabbix) 6.4.2

my house keeping all entries were earlier 180 days but I just reduced it to 10 days 2 days before just to see if the database growing...

[gofree]

if you search the forum/blog/web.youtube you'll find all the answers - this topic has been discussed countless times - in short mysql doesnt clean space in default settings - thats why people use partitioning ( custom mysql ) or out of the box ( timescaledb )

https://www.zabbix.com/for...