can zm check their databases and see if they are ok ?
since sometimes they broke events mostly wen the machine is power off
and do a optimize tables sometimes.
mysql automatic optimize & repair.
mysql automatic optimize & repair.
Fernando
-
victor_diago
- Posts: 245
- Joined: Wed Jan 21, 2004 2:44 pm
- Location: Brazil, sao paulo
- Contact:
I use a script called CheckTables.sh
the script just do a "myisamchk -rf /var/lib/mysql/zm/*.MYI" every time the system boots (put it in rc.local)
Sure the system will take something like 2 or 3 minutes (in many cases less than this) to boot up, but this way you ensure your system will be nice to work.
in a full 80 GB system, with 16 cameras, 256 MB Duron 1.4, it only takes 1 minute. i think uts a good way to do that
victor diago
the script just do a "myisamchk -rf /var/lib/mysql/zm/*.MYI" every time the system boots (put it in rc.local)
Sure the system will take something like 2 or 3 minutes (in many cases less than this) to boot up, but this way you ensure your system will be nice to work.
in a full 80 GB system, with 16 cameras, 256 MB Duron 1.4, it only takes 1 minute. i think uts a good way to do that
victor diago