Disabling zms logging

Forum for questions and support relating to the 1.26.x releases only.
Locked
gduprey
Posts: 5
Joined: Thu May 18, 2006 3:58 am

Disabling zms logging

Post by gduprey »

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
chippy99
Posts: 66
Joined: Wed Aug 30, 2006 5:38 pm
Location: Barnet, Herts. UK

Re: Disabling zms logging

Post by chippy99 »

Select options from main zm screen, then logging, then set LOG_LEVEL_DATABASE to error and only errors will be recorded.
gduprey
Posts: 5
Joined: Thu May 18, 2006 3:58 am

Re: Disabling zms logging

Post by gduprey »

Thanks! Perfect solution and gave me a chance to look into zoneminder logging better.

Gerry
Locked