Page 1 of 1
How to avoid zm Frames table crashes
Posted: Wed Feb 04, 2009 10:59 am
by foreverg
I have some ZM installation with almost 6 camers each, and several time I noticed that table Frames had a crash and recording was blocked.
This is not a good thing, more if you have attention on this after some weeks.. Is there any workaround for this iusse?
Posted: Thu Feb 05, 2009 6:07 pm
by Lee Sharp
Don't reboot during database writes...
Posted: Fri Feb 06, 2009 7:44 am
by foreverg
sure that's a good thing.. what if is there any unwanted restart?
Posted: Fri Feb 06, 2009 8:26 am
by cordel
Then you have to repair the database. I suggest getting a good ups.
Posted: Fri Feb 06, 2009 9:19 am
by pcb1962
cordel wrote:Then you have to repair the database.
And if you need to repair the database, what is the correct procedure?
I used this command which I found somewhere, is this the best way?
Code: Select all
myisamchk --force --fast --update-state -O key_buffer=64M -O read_buffer=1M -O write_buffer=1M /var/lib/mysql/zm/*.MYI
Posted: Fri Feb 06, 2009 9:28 am
by foreverg
cordel wrote:Then you have to repair the database. I suggest getting a good ups.
the strange thing is that all the servers are under UPS
