MariaDB ibdata1 growing

[Hamardaban]

Is the zabbix database located on the same disk? is this a growing base?

Perhaps some process writes a lot of information to logs - check the directory with logs (usually /var/log).
use the du utility to determine the space occupied by directories (or better, install the ncdu utility...

[bernd.dausch]

Hi all,

we use Zabbix since some years, since the last Updates we see the ibdata1 file growing aroung 10 GB / 3 Days. We use one DB File per Table and the Database Size is the same as the Stoarage Usage in the Table Folder

+--------------------+---------------+
| DB Name...

[lars ds]

Our housekeeping frequency is set to "1" (run each hour) and should clean up 5000 items. These 5K Items in my opinion won't do it. We gather 2.5K items every minute meaning our database will keep growing. Sadly the housekeeper can't finish this task it seems like. Waiting nearly 90 minutes...

[knightwolf8877]

zabbix 6.2 postgresql 14 timescaledb 2.7.2

I am not a postgresql db so trying to do my best here.

there are history table issues in the database it seems due to timescaledb. it's possible I didn't update some sql script into the database with some timescale db update iin the...

[Markku]

Oh, I haven't ever done anything like that (CREATE TABLE LIKE, ALTER TABLE RENAME) except when specifically following some instructions, so you need to verify the commands yourself. If you don't want to copy your big database for testing, just install a new Zabbix server with the same version, run it...

[harribal]

All,

I do have a problem with database growing rapidly. I think it is due to auto vacuum not being able to purge table history_uint.
Background: This is zabbix 6.0.12 and Postgres 13. Housekeeping is set to clear history after 30 days.

Autovacuum works on at least some...

[hakanozanlagan]

hi,

i am using postgressql+timescaledb as zabbix Database. when housekeepr running it's getting this error and Database size growing very fast. I am looking for solution for a while but didn't find anything.

2022-06-16 12:33:19.255 +03 [1938148] STATEMENT: delete from history...

[nahueld]

Hi, i'm having some trouble backing up the database of my zabbix server, I'm trying to make an upgrade and before doing it i wanted to have everything backed up in case something goes wrong.

I'm currently running zabbix 5.0 and MySQL8.0, on a RockyLinux, the size of the database is almost...

[greavette]

Thank you bartosz.mickiewicz for your suggestions...I really appreciate your input!

Your links allowed me to do some digging and I found out that there is a template "MySQL by Zabbix agent 2" - https://git.zabbix.com/projects/ZBX/...b/mysql_agent2. This template allowed me to get...

[majed17]

Peace,
history_old.ibd is over 5 GB
history_uint_old.ibd is almost 4 GB
other history tables that are under 1 GB
are they needed? if not how to remove them on zabbix 6.2?
the database was stable before the upgrade but now it is growing quickly....

[Markku]

This is how the official MySQL template calculates the database size (in this example I only use history_uint table but the principle is valid, lines split for clarity):

# echo '
select sum(data_length+index_length)/1024/1024/1024 as "Size in GB"
from information_schema.tables

...

[fdavidcn]

Hi guys,

I am a newbie with zabbix and i was recently partitioned my PostgreSQL database following this manual in zabbix wiki: https://www.zabbix.org/wiki/Docs/how...topartitioning

I disabled "Enable internal maintenaince" under "Housekeeper"...

[KarlPokorny]

Dear Zabbix Community,

I am about to migrate a medium Zabbix environment (~ 1500 Hosts and as many NVPS tendency growing) from a VM Deployment to a containerized setup for various reasons.

Currently I am still in the PoC phase and so far setup Server + DB as well as WebFE...

[abbyers73]

We are monitoring about 180 devices and trying to retain 90 days of history for these devices. the MYSQL database keeps growing at nearly 10GB a day which seems excessive for that number of devices. This is Mysql-CE 8 and the history_uint table is the largest consumer of space. does 270GB for 90days...

[gofree]

Sometimes I really wonder if people use search function

https://www.zabbix.com/forum/zabbix-...e-growing-fast...