Re: [Condor-users] quill schema

[Rita <rmorgan466@xxxxxxxxx>]

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/
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/