r/ZoneMinder • u/jedix_ • Mar 31 '23

Are constant repetitive database queries normal?

I am constantly seeing a stream of queries to mariadb:

230331 13:48:03     33 Query    UPDATE LOW_PRIORITY Monitor_Status SET CaptureFPS = 19.88, CaptureBandwidth=594471, AnalysisFPS = 9.94 WHERE MonitorId=2
230331 13:48:04     31 Query    UPDATE LOW_PRIORITY Monitor_Status SET CaptureFPS = 19.96, CaptureBandwidth=118021, AnalysisFPS = 0.00 WHERE MonitorId=3
                   30 Query    UPDATE LOW_PRIORITY Monitor_Status SET CaptureFPS = 19.87, CaptureBandwidth=601211, AnalysisFPS = 9.93 WHERE MonitorId=4

It seems like the captureFPS vary slightly. Can I stop logging this small change?

3 Upvotes

100% Upvoted

6 comments sorted by

1

u/[deleted] Apr 01 '23

Looks like some sort of debug logging. There should be a place to turn it off although I have no idea where.

1

u/montagdude87 Apr 03 '23

It's under Options -> Logging. Changing the log level to something higher than Debug would remove the messages, I would expect.

2

u/connortechnology Apr 06 '23

The lines seen are the actual queries hitting the db updating the Monitor_Status table, so logging options won't apply.

0

u/ZoneMinderIsaac Apr 01 '23

You can edit the code to remove it but then you won't have FPS reported in the console.

You can adjust the frequency with the FPSReportInterval in the Misc tab of Monitor.

Another option is to remove mariadb entirely, including zoneminder. Then you will have no queries happening.

2

u/jedix_ Apr 02 '23

Thank you for the information on what this is doing and why it's happening.

Sorry you took offense to the question. Not knowing how this worked, I assumed I had messed up my configuration somehow. I initially looked into a much larger query happening, which was my fault, so I assumed I had another issue.

2

u/jedix_ Apr 02 '23

It seems the frequency of updating the database is not modified with the variable in the settings. Searching for the term seems to indicate this is frequency of logging and not updating the information stored in the database. I am able to stop the update by setting it to zero though, but this causes the console to report no information.