How to avoid zm Frames table crashes

foreverg · Post by **foreverg** » Wed Feb 04, 2009 10:59 am

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?

Lee Sharp · Post by **Lee Sharp** » Thu Feb 05, 2009 6:07 pm

Don't reboot during database writes...

foreverg · Post by **foreverg** » Fri Feb 06, 2009 7:44 am

sure that's a good thing.. what if is there any unwanted restart?

Post by **cordel** » Fri Feb 06, 2009 8:26 am

Then you have to repair the database. I suggest getting a good ups.

pcb1962 · Post by **pcb1962** » Fri Feb 06, 2009 9:19 am

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

foreverg · Post by **foreverg** » Fri Feb 06, 2009 9:28 am

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