Search found 20 matches

by kibbling
Thu Feb 23, 2023 11:23 am
Forum: ZoneMinder 1.36.x
Topic: Please help with Purge filter
Replies: 8
Views: 979

Re: Please help with Purge filter

Idea/Qustion:
Do I need to build a "Update DiskSpace" Filter also for each drive in order to work properly? Currently the "Update DiskSpace" is wihtout disk name. Is it then updating all or only default?
by kibbling
Thu Feb 23, 2023 10:57 am
Forum: ZoneMinder 1.36.x
Topic: Please help with Purge filter
Replies: 8
Views: 979

Re: Please help with Purge filter

Thank you for reading my issue. >What size does zm show in the options page for USB disk? 2 ExternalUSB /var/usbplatte1/zoneminder local Medium 1.73TB of 3.58TB 9825 using 0.92TB >What happens if you set the filter to 90? I can try it, but it will take a few month to see the result. >What does your...
by kibbling
Thu Feb 23, 2023 9:55 am
Forum: ZoneMinder 1.36.x
Topic: Please help with Purge filter
Replies: 8
Views: 979

Re: Please help with Purge filter

Found this snippet in Filter.php case 'DiskPercent': // Need to specify a storage area, so need to look through other terms looking for a storage area, else we default to ZM_EVENTS_PATH if ( ! $StorageArea ) { for ( $j = 0; $j < count($terms); $j++ ) { if ( isset($terms[$j]['attr']) and $terms[$j]['...
by kibbling
Thu Feb 23, 2023 9:36 am
Forum: ZoneMinder 1.36.x
Topic: Please help with Purge filter
Replies: 8
Views: 979

Re: Please help with Purge filter

"List Matches" gives always an empty List regardless the setting of the "disk Percentage" "Export Matches" Gives always 100 Results, regardless the setting of the "disk Percentage" "Debug" and execute the Query in PHPMyAdmin always has 100 Results, b...
by kibbling
Thu Feb 23, 2023 9:02 am
Forum: ZoneMinder 1.36.x
Topic: Please help with Purge filter
Replies: 8
Views: 979

Please help with Purge filter

Hello, please see screenshot. I have a 4 TB second drive "ExternalUSB" and want to fill it up to 80% with events. Currently its about 9766 Events for the 48% used, each Event is about 60 MB in size. But ZM keeps deleting everything down to 48%. What is wrong with my filter? Thank you for y...
by kibbling
Thu Feb 23, 2023 8:05 am
Forum: ZoneMinder 1.34.x
Topic: audio not saving with record
Replies: 3
Views: 5201

Re: audio not saving with record

Same error. No Audio recording with Reolink RLC-510WA Works in VLC. ZM Give Errormessage: zmc_m8 2159593 ERR Error writing packet: Operation not permitted zm_videostore.cpp 1425 Anyone got a hint what to do then and how to record audio? RTMP Audio is working, but the Load on ZM is significantly high...
by kibbling
Thu Nov 03, 2022 1:51 pm
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Re: Very high disc write from MySQL destroying SSD.

I found only how to log all Querys or Slow Querys. But not now to log "unindexed" or how to mark them in the logfiles. I think it is neccessarry to run explain on all potential querys to so see which ones are affected. I can tell this only from the innodb performance counters reporting thi...
by kibbling
Wed Nov 02, 2022 7:39 am
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Re: Very high disc write from MySQL destroying SSD.

Great news. That might be the case here, because I make heavy use of the API. With lots of DB Tuning and RAM extension I brought the Writing down by a lot. Seems there are many querys not using an index, resulting in temp tables for sorting. So you need to increase the max RAM for temp tables and al...
by kibbling
Thu Oct 27, 2022 3:12 pm
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Re: Very high disc write from MySQL destroying SSD.

Any chance to get this fixed for ZM/MySQL current installations?

I have no idea how many Installations of ZM are out there.
But if you have 10.000 Installations and each can save a few years of SSD lifetime, this saves tons of waste and literally million(s) of dollars for broken SSDs.
by kibbling
Thu Oct 27, 2022 12:13 pm
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Re: Very high disc write from MySQL destroying SSD.

Samsung Pro SSD's on RAID5 for two years and have seen no issues. I Also use a Samsung Pro SSD with a livetime of 600 TBW. Zoneminder is using 60 TB/Year for the MySQL only when having 4 Cameras. So expected Livetime by only MySQL usage is 10 Years to consume all 600 TBW without video writing to th...
by kibbling
Thu Oct 27, 2022 11:21 am
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Re: Very high disc write from MySQL destroying SSD.

I found the root cause. With 4 Cammeras, ZoneMinder is executing 150 Querys per second in avarage. Instead of 1 insert into the Frame Table, they fire a complete bunch of Querys: 2022-10-27T08:50:34.007875Z 2673 Query INSERT INTO `Frames` (`EventId`, `FrameId`, `Type`, `TimeStamp`, `Delta`, `Score`)...
by kibbling
Thu Oct 20, 2022 5:54 am
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Re: Very high disc write from MySQL destroying SSD.

I dont write jpgs, only the videos. the Video hdd is fine - the writes there are as expected and "normal". But the writes on the system disk are not expected and are more as all the full-HD video streams on the video hdd. Your Math is correct - but this is not good, its very bad. It needs ...
by kibbling
Mon Oct 17, 2022 9:43 am
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Re: Very high disc write from MySQL destroying SSD.

I already reduced Logging to Error.
Increasing the Event Frame Intervall from 100 to 1000 does not change the write amount - like suggested in some threads.
by kibbling
Mon Oct 17, 2022 6:49 am
Forum: ZoneMinder 1.36.x
Topic: Very high disc write from MySQL destroying SSD.
Replies: 20
Views: 7462

Very high disc write from MySQL destroying SSD.

Hello, I have two discs. SDA is the virtual system disc from Proxmox - a Samsung 1 TB 600 TBW nvme SSD SDB is a spinning HDD for the videos. I write all Videos with "Record" to the sdb HDD. This take about 700 KB/s (seen in iostat). But also the system disk has 500KB/s - for no obvious rea...
by kibbling
Mon Oct 10, 2022 9:03 am
Forum: ZoneMinder 1.36.x
Topic: Storage location does not work with "Record"?
Replies: 3
Views: 364

Re: Storage location does not work with "Record"?

Yes, it was permissions. Sorry for the dump question.