Hi,
On Fri, 13 Mar 2009 19:40:45 +0100, Francesco Duranti <fduranti at q8.it> wrote:
Hi, the fast/medium/slow check are related to what check you will do (and not the time you do them).
This is my configuration on checks on the dbcheck.ini bbconncolumn = ChkConn::fast bbauditcolumn = Audit::fast bbtablespacecolumn = TblSpace::fast bbextentcolumn = Extent::slow bbhitcachecolumn = HitCache::fast bbmemreqcolumn = MemReq::fast bbrollbackcolumn = RollBack::slow bbinvobjcolumn = InvObj::fast bblockscolumn = Locks::fast bbsessioncolumn = Session::fast
For example I use them to differentiate the checks on the same databases In hobbitlaunch I have: [dbfast] ENVFILE /home/bb/server/etc/hobbitserver.cfg NEEDS hobbitd CMD $BBHOME/ext/dbcheck.pl fast LOGFILE $BBSERVERLOGS/bb-dbfast.log INTERVAL 5m [dbslow] ENVFILE /home/bb/server/etc/hobbitserver.cfg NEEDS hobbitd CMD $BBHOME/ext/dbcheck.pl slow LOGFILE $BBSERVERLOGS/bb-dbslow.log INTERVAL 120m
So [dbfast] will run only checks defined as "fast" in the dbcheck.ini files every 5 minutes while [dbslow] will run every 2 hours to check Extent and Rollback (those kind of checks are more impegnative on the Database and take a long times on some of the database I check).
On the bb-hosts file I've: group-compress Dev DB 0.0.0.0 db1 # noconn dbcheck 0.0.0.0 db2 # noconn dbcheck 0.0.0.0 db3 # noconn dbcheck 0.0.0.0 db4 # noconn dbcheck
Did you mean something like this : group-compress Dev DB 0.0.0.0 db1 # noconn dbfast 0.0.0.0 db2 # noconn dbslow 0.0.0.0 db3 # noconn dbfast 0.0.0.0 db4 # noconn dbslow
Put dbslow or dbfast instead of dbcheck ?