Re: [Condor-users] quill schema

[Steven Timm <timm@xxxxxxxx>]

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/
Fermilab Computing Division, Scientific Computing Facilities,
Grid Facilities Department, FermiGrid Services Group, Group Leader.
Lead of FermiCloud project.