[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [hobbit] If dbcheck slow mode activated, XYmon becomes purple
- To: hobbit (at) hswn.dk
- Subject: RE: [hobbit] If dbcheck slow mode activated, XYmon becomes purple
- From: L.M.J <linuxmasterjedi (at) free.fr>
- Date: Mon, 16 Mar 2009 09:06:52 +0100
- References: <20090312205523.27b878ef (at) netstation.linuxnetwork.local> <d377b1eb804388cc7493927162ccf33c (at) 192.168.10.1> <200903121803.49809.s_aiello (at) comcast.net> <235219d65289e75db3a399429e1b883b (at) imap> <72E9469F0632D54EBFB43920325B64CB45217ED1 (at) ITROMEX21.Q8INT.COM>
- User-agent: RoundCube Webmail/0.1
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 ?