Page 1 of 1
mysql automatic optimize & repair.
Posted: Mon Sep 27, 2004 12:23 pm
by fernando
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.
Posted: Sat Oct 23, 2004 11:23 am
by victor_diago
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
Posted: Tue Oct 26, 2004 8:37 pm
by fernando
thanks victor..
i allready use mysqlcheck in cron every 10 min. repair and optimization.
works GREAT