ZoneMinder Forums

Thank you bbunge for what you are doing documenting this stuff.

I apologize for complaining as I understand you are doing this voluntarily.

I used to post my concerns on the Isaac's build pages and I understand that he is busy and he did refer me to here relating to posting my concerns.

The above noted I think I contributed to Isaac's efforts way a long time ago and will contribute again shortly.

Is there a means / way to contribute to your efforts here?

Hi, i upgraded to 1.28.107 and now my mysql is using 100% from one of my cpu :

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1029 mysql 20 0 2401336 180956 4180 S 99.9 4.5 16411:37 mysqld

now my load went from ~1.25 to ~3.50,

also i have some vivotek pz6122 wich worked well on previous version and now i get a blue screen and this :

11/03/15 09:48:37.250763 zmc_m13[14941].ERR-zm_remote_camera_http.cpp/1040 [Unable to read content]
11/03/15 09:48:37.250843 zmc_m13[14941].ERR-zm_remote_camera_http.cpp/1141 [Unable to get response, disconnecting]

any ideea what could have hapend? and how can i solve at least the mysql cpu usage?

i am on :
#lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04.3 LTS
Release: 14.04
Codename: trusty

thanks

Known issue. Easy fix.

run as sql query

CREATE INDEX `EventId_idx` ON `Frames` (`EventId`)

There are other forum topics that cover this in detail