Page 1 of 1
zoneminder killing my system every 1 year!
Posted: Tue Nov 19, 2024 5:08 pm
by 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?
Re: zoneminder killing my system every 1 year!
Posted: Tue Nov 19, 2024 6:51 pm
by zmaximz
okay, made BULK_FRAME_INTERVAL 10000, hope it will help
Re: zoneminder killing my system every 1 year!
Posted: Tue Nov 19, 2024 7:41 pm
by 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.
Re: zoneminder killing my system every 1 year!
Posted: Tue Nov 19, 2024 8:42 pm
by SkippyDo
What about stats logging? I had problems with this hammering my system:
viewtopic.php?t=33194
Re: zoneminder killing my system every 1 year!
Posted: Fri Nov 22, 2024 10:41 am
by zmaximz
Andyrh wrote: ↑Tue Nov 19, 2024 7:41 pm
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 674 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
Re: zoneminder killing my system every 1 year!
Posted: Fri Nov 22, 2024 1:39 pm
by Andyrh
For your cameras under Storage, do you have Save JPEGs disabled?
Re: zoneminder killing my system every 1 year!
Posted: Fri Nov 22, 2024 3:45 pm
by zmaximz
Andyrh wrote: ↑Fri Nov 22, 2024 1:39 pm
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