Howdy,
I came back from vacation and found my database had grown to 17GB while gone. Nearly all of that is in the Logs table and nearly all of that is because the zms/zms-nph calls that log an event everytime something views a camera. I have embedded zm access into another app and as a result, there are many frequent calls to fetch images (the MJPEG stream isn't possible in this config).
Since MySql doesn't 'free up' deleted space (though it can re-use it), unless I stay on top of this, I face a dump and reload to reclaim the space (I know there are ways to make that better with separate table space, but the underlying problem persists).
Is there any way to get the zms stuff to not log every access? I'm perfectly OK with this and would ideally still like logs if there are errors and such, but it's really clogging up resources right now.
Thanks,
Gerry
Disabling zms logging
Re: Disabling zms logging
Select options from main zm screen, then logging, then set LOG_LEVEL_DATABASE to error and only errors will be recorded.
Re: Disabling zms logging
Thanks! Perfect solution and gave me a chance to look into zoneminder logging better.
Gerry
Gerry