Re: [Condor-users] quill schema

[Lukas Slebodnik <slebodnik@xxxxxxxx>]

I have this lines in configuration file. 

# If this is set to true, then the rest of the QUILL arguments must be defined
# for quill to function. If it is Fase or left undefined, then quill will not
# be consulted by either the scheduler or the tools, but in the case of a 
# remote quill query where the local client has quill turned off, but the
# remote client has quill turned on, things will still function normally.
#QUILL_ENABLED = TRUE
#
# The SQL Log can be enabled on a per-daemon basis. For example, to collect
# historical job information, but store no information about execute machines,
# uncomment these two lines
#QUILL_USE_SQL_LOG = FALSE 
#SCHEDD.QUILL_USE_SQL_LOG = TRUE

So if you set variables
SCHEDD.QUILL_USE_SQL_LOG = TRUE # or QUILL_USE_SQL_LOG = TRUE
STARTD.QUILL_USE_SQL_LOG=FALSE, then you disable quill

Then quill will not use data from Startd logs

Lukas Slebodnik

On Wed, Jan 26, 2011 at 06:53:42AM -0500, Rita wrote:
> If I set, STARTD.QUILL_USE_SQL_LOG=FALSE will that still be able to keep
> quill? I ask because quill is very nice and important for my team. It saves
> us a lot of time.
> 
> I usually truncate the table, do you see anything wrong with that?
> 
> caio
> 
> On Tue, Jan 25, 2011 at 9:47 PM, Steven Timm <timm@xxxxxxxx> wrote:
> 
> > machines_vertical_history is keeping track of
> > every single startd in the condor pool.  There are very few
> > big installations that have a powerful enough database server
> > to pull this off. Fermilab never tried.. we only log stuff from the schedd.
> >  To disable this table make STARTD.QUILL_USE_SQL_LOG=FALSE
> >
> > Steve Timm
> >
> >
> >
> >
> > On Tue, 25 Jan 2011, Rita wrote:
> >
> >  Hi All,
> >>
> >> Wondering why quill (7.2.4) has a table called machines_vertical_history
> >> whose count is more than 40 million! And there is a function which is
> >> reindexing this table. What is the purpose of this?
> >>
> >>
> > --
> > ------------------------------------------------------------------
> > Steven C. Timm, Ph.D  (630) 840-8525
> > timm@xxxxxxxx  http://home.fnal.gov/~timm/ <http://home.fnal.gov/%7Etimm/>
> > Fermilab Computing Division, Scientific Computing Facilities,
> > Grid Facilities Department, FermiGrid Services Group, Group Leader.
> > Lead of FermiCloud project.
> > _______________________________________________
> > Condor-users mailing list
> > To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
> > subject: Unsubscribe
> > You can also unsubscribe by visiting
> > https://lists.cs.wisc.edu/mailman/listinfo/condor-users
> >
> > The archives can be found at:
> > https://lists.cs.wisc.edu/archive/condor-users/
> >

> _______________________________________________
> Condor-users mailing list
> To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
> subject: Unsubscribe
> You can also unsubscribe by visiting
> https://lists.cs.wisc.edu/mailman/listinfo/condor-users
> 
> The archives can be found at:
> https://lists.cs.wisc.edu/archive/condor-users/