zoneminder killing my system every 1 year!

[zmaximz]

Hello. This is really annoying because i tired of restoring system every time.
I'm using external triggers and passthrough, so there are no decoding and any frames, but zoneminder writes to database info of EVERY SINGLE NON EXISTING FRAME, until database become bigger and bigger (frames.idb) 30gb... 70gb... and there are no space for system, and it's totally crushes, after that i should spent days and to do reinstall.
Why does zonemider writes this trash to database and how to disable it?

[zmaximz]

okay, made BULK_FRAME_INTERVAL 10000, hope it will help

[Andyrh]

What other settings do you change from the default? I have been running for years without the DB bloating. I typically have ~300k events.

[SkippyDo]

What about stats logging? I had problems with this hammering my system: viewtopic.php?t=33194

[zmaximz]

What other settings do you change from the default? I have been running for years without the DB bloating. I typically have ~300k events.

Hello, almost everything is default, but i disabled zmaudit that time (now i enabled it with period of 1 week)

well... i have about 10к events in 2 days, so in a year i have a lot more. All of them are triggered by external triggers through telnet and there are no any decoding or analysis, to decrease cpu load. I thought that 128gb ssd for system and 4tb for archive would be enough, and it worked fine for about 1 year

And... after 2 days after clean reinstall... i have 10k events and 6.5 millions records for frames db, not sure BULK_FRAME_INTERVAL 10000 helped any way

Screenshot 2024-11-22 123418.png (739.9 KiB) Viewed 667 times

I don't understand why I even need this info... for me would be enough just records of short videos, but looks like there are no such option, and I should look for bigger ssd. Also i'm concerned about ssd lifespan with such intense db usage

[Andyrh]

For your cameras under Storage, do you have Save JPEGs disabled?

[zmaximz]

For your cameras under Storage, do you have Save JPEGs disabled?

Of course, and i don't have any of frames saved to hdd, only short videos.

I think database "frames" pointing to time in video by "delta" field and extract frames from video.
But well, it's not the problem, i guess i don't need frames info in database at all?
I have about 4000 events per day, every one is about 3-4minutes, so there are no wrong info about frames, it's just a lot of records in db