ZoneMinder Forums

ZoneMinder Forums
https://forums.zoneminder.com/

High DB usage

https://forums.zoneminder.com/viewtopic.php?t=31208

Page 1 of 1

High DB usage

Posted: Sat Oct 16, 2021 9:01 pm
by dougmccrary
42A35A86-4991-4E48-A18E-5B242B324648.png
42A35A86-4991-4E48-A18E-5B242B324648.png (88.25 KiB) Viewed 10463 times

Re: High DB usage

Posted: Sat Oct 16, 2021 9:34 pm
by dougmccrary
just got 1.37.1~20211016164753-focal.
Usage stayed high, do did a reboot. Mariadb took 10 minutes to stop.
So far, so good.
Thanks, Isaac!

Re: High DB usage

Posted: Sun Oct 17, 2021 3:31 pm
by iconnor
I wish someone with bootstrap or css skills would take some time and fixup our layout... I can do it, there is just too much to do though.

Anyways... you can bump up your db limits.... what is underlying your db, spinning rust or ssd? I've been finding that a lagging db due to spinning rust can really bog down ZM. I'm going to have to further optimise db accesses. Only so much I can do though.

Re: High DB usage

Posted: Mon Oct 18, 2021 9:17 am
by dougmccrary
It's on the same (type) 120mb ssd that was using maybe 30 or so two revisions back, and a TB disk. This seems to settle down around 60-70, or more if there's a lot of motion going on.
Up until a crash a week or so ago, I was on mySQL, but I went with MariaDB per you saying it was faster,
Maybe I should go back to mysql to see if it matters?

Re: High DB usage

Posted: Mon Oct 18, 2021 3:15 pm
by iconnor
For the db connection count to be that high, there has to be that many zm processes accessing it. In 1.34, there was a zmc and a zma for each monitor. Now we just have zmc, so the number should be half of what it was in 1.34.

ps ax | grep zm

how many processes? I wonder if you have the zmu hanging around issue?

Re: High DB usage

Posted: Mon Oct 18, 2021 9:36 pm
by dougmccrary
There were about 67 connects, according to the web interface, when I got:

Code: Select all

doug@doug-System-ZMX:~$ ps ax | grep zm
   1093 ?        S      0:50 /usr/bin/perl -wT /usr/bin/zmdc.pl startup
   1404 ?        S      1:20 /usr/bin/perl -wT /usr/bin/zmwatch.pl
   1430 ?        S      0:00 /usr/bin/perl -wT /usr/bin/zmupdate.pl -c
   1447 ?        S      0:02 /usr/bin/perl -wT /usr/bin/zmstats.pl
  22683 ?        SLl  453:51 /usr/bin/zmc -m 9
  23807 ?        SLl  111:05 /usr/bin/zmc -m 3
  24033 ?        SLl   88:31 /usr/bin/zmc -m 13
  24048 ?        SLl  446:08 /usr/bin/zmc -m 11
  24054 ?        SLl  421:46 /usr/bin/zmc -m 10
  24055 ?        SLl  113:13 /usr/bin/zmc -m 1
  24161 ?        SLl  108:16 /usr/bin/zmc -m 8
  24175 ?        SLl  107:24 /usr/bin/zmc -m 2
  24198 ?        SLl   76:27 /usr/bin/zmc -m 4
  24210 ?        SLl  122:03 /usr/bin/zmc -m 14
  24226 ?        SLl  119:47 /usr/bin/zmc -m 15
  36792 ?        SLl  103:05 /usr/bin/zmc -m 5
  36917 ?        SLl  292:20 /usr/bin/zmc -m 7
  58748 ?        S      0:00 /usr/bin/perl -wT /usr/bin/zmtelemetry.pl
  58751 ?        S      0:03 /usr/bin/perl -wT /usr/bin/zmfilter.pl --filter_id=1 --daemon
  58752 ?        S      8:52 /usr/bin/perl -wT /usr/bin/zmfilter.pl --filter_id=3 --daemon
  58757 ?        S      0:04 /usr/bin/perl -wT /usr/bin/zmfilter.pl --filter_id=2 --daemon
  58831 ?        SLl   21:29 /usr/lib/zoneminder/cgi-bin/nph-zms
  59362 ?        SLl   14:35 /usr/lib/zoneminder/cgi-bin/nph-zms
  59386 ?        SLl   21:48 /usr/lib/zoneminder/cgi-bin/nph-zms
  59395 ?        SLl   11:16 /usr/lib/zoneminder/cgi-bin/nph-zms
  59397 ?        SLl   10:56 /usr/lib/zoneminder/cgi-bin/nph-zms
  60960 ?        SLl    2:08 /usr/lib/zoneminder/cgi-bin/nph-zms
  61827 ?        SLl   20:14 /usr/lib/zoneminder/cgi-bin/nph-zms
  65449 ?        SLl    5:46 /usr/lib/zoneminder/cgi-bin/nph-zms
  69407 ?        SLl    4:20 /usr/lib/zoneminder/cgi-bin/nph-zms
  69786 ?        SLl    1:37 /usr/lib/zoneminder/cgi-bin/nph-zms
  70281 ?        SLl    2:28 /usr/bin/zmc -m 6
  70315 ?        SLl    0:54 /usr/lib/zoneminder/cgi-bin/nph-zms
  71204 ?        SLl    0:12 /usr/lib/zoneminder/cgi-bin/nph-zms
  71206 ?        SLl    0:05 /usr/lib/zoneminder/cgi-bin/nph-zms
  71207 ?        SLl    0:06 /usr/lib/zoneminder/cgi-bin/nph-zms
  71209 ?        SLl    0:02 /usr/lib/zoneminder/cgi-bin/nph-zms
  71211 ?        SLl    0:05 /usr/lib/zoneminder/cgi-bin/nph-zms
  71212 ?        SLl    0:04 /usr/lib/zoneminder/cgi-bin/nph-zms
  71213 ?        SLl    0:10 /usr/lib/zoneminder/cgi-bin/nph-zms
  71214 ?        SLl    0:25 /usr/lib/zoneminder/cgi-bin/nph-zms
  71215 ?        SLl    0:04 /usr/lib/zoneminder/cgi-bin/nph-zms
  71216 ?        SLl    0:11 /usr/lib/zoneminder/cgi-bin/nph-zms
  71217 ?        SLl    0:05 /usr/lib/zoneminder/cgi-bin/nph-zms
  71218 ?        SLl    0:05 /usr/lib/zoneminder/cgi-bin/nph-zms
  71219 ?        RLl    0:11 /usr/lib/zoneminder/cgi-bin/nph-zms
  72221 ?        SLl    0:00 /usr/lib/zoneminder/cgi-bin/nph-zms
  72227 pts/0    S+     0:00 grep --color=auto zm
doug@doug-System-ZMX:~$

Re: High DB usage

Posted: Tue Oct 19, 2021 1:55 pm
by Magic919
Do you have a lot of watching clients/monitors? My nph-zms processes go up as I fire up ZMNinja or other clients. They drop back down again quickly on 1.36.8.

If not, they must be hanging around when not needed.

Re: High DB usage

Posted: Tue Oct 19, 2021 9:51 pm
by dougmccrary
I have 14 assorted rtsp cams in mocord. 3 decode for timestamp, the rest passthrough, with jpegs either disabled or analysis only.
The same setup uses 20-30 DB on 1.36.8

Update:
For reasons I do not understand, 1.36.9 and 1.37.1 latest are now running almost neck and neck at 45-50 DB although the latter tends to run around 5 or so higher than 1.36. Both systems use the same settings and cameras, AFAIK.
Memory and swap nee /dev/shm is a nice change, BTW.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited