In the past, some of my zoneminder systems have been less than maintenance-free because they would occasionally lose power resulting in DB corruption. My research suggests that InnoDB tables are more fault tolerant than MyISAM tables.
Why hasn't zoneminder switched from MyISAM to InnoDB?
InnoDB
Re: InnoDB
Hello and thanks for your input. User selectable database system would be a nice upgrade for Zoneminder. I hope to hear from you soon in a form of a patch.
-
knight-of-ni
- Posts: 2406
- Joined: Thu Oct 18, 2007 1:55 pm
- Location: Shiloh, IL
Re: InnoDB
Yeah, I just manually change each table to innodb via script or the mysql gui tools.
There was one table that wouldn't convert however. Don't remember which one it was.
There was one table that wouldn't convert however. Don't remember which one it was.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
All of these can be found at https://zoneminder.blogspot.com/