excessive ammounts of mysql activity caused by zoneminder?
Posted: Mon Sep 21, 2020 8:41 pm
Hey everyone.
So, I created a debian buster virtual machine exclusively for zoneminder, and installed zoneminder 1.34.20-buster1 per the instructions
First I created a demo of 3 IP cameras going into it, running in "modect" mode. Zoneminder works much better then I expected, so thanks for that.
Now the issue: I noticed that the hard drive lights were flashing multiple times per second. I traced the activity to the zoneminder virtual machine. I was expecting it to be related to all the video data, but when i ran "iotop" it showed the culprit for the disk activity was coming from mysql.
I was wondering what zoneminder could be doing with mysql that could be causing multiple writes per second? This happens even in moments when there is no motion, and there is nothing to record.
So, I created a debian buster virtual machine exclusively for zoneminder, and installed zoneminder 1.34.20-buster1 per the instructions
First I created a demo of 3 IP cameras going into it, running in "modect" mode. Zoneminder works much better then I expected, so thanks for that.
Now the issue: I noticed that the hard drive lights were flashing multiple times per second. I traced the activity to the zoneminder virtual machine. I was expecting it to be related to all the video data, but when i ran "iotop" it showed the culprit for the disk activity was coming from mysql.
I was wondering what zoneminder could be doing with mysql that could be causing multiple writes per second? This happens even in moments when there is no motion, and there is nothing to record.