Database Log not purging
Posted: Wed Jun 19, 2019 4:29 pm
Zoneminder on Bionic with Mariadb. Had an issue last week with the quad core CPU running over 80% while it normally runs 15-40% Investigating I discovered the zm database over 10GB! Increasing the innodb_buffer_pool_size calmed the processor but furthur research showed the zm/log table over 7GB. The log settings were to purge the log at "2 day" (the default is "7 day"). I was able to empty (truncate) the log table with phpmyadmin which reduced the zm database to below 3GB which is not too bad for over 70K events stored.
Am watching the zm log and seeing the number of records increasing but not being purged at the "2 day" setting. I suspect a corrupt database but thought I would throw this out for comment in aces I've missed the obvious or...
bb
Am watching the zm log and seeing the number of records increasing but not being purged at the "2 day" setting. I suspect a corrupt database but thought I would throw this out for comment in aces I've missed the obvious or...
bb