Main INDEX
Monthly INDEX
PREV
NEXT
User name sarty
Log entry time 16:19:06 on April13,2000
Entry number 39077
This entry is a followup to: 39069
keyword=NEW how to use the MYSQL database to get trigger total
NOTE! Small change in procedure - you don't have to edit the file
"updatedatabase.sh" anymore!
Instructions here are complete:
***********************************
Here is the present "how to" manual for using the MYSQL run-database to get the
running total of T5 triggers (for example)....this will eventually get simplified.
o on adaql1, go to directory ~adaq/E93-049database
o to update the database (to include the latest runs):
- type "findlastrun.sh" to see what the highest run number presently known by
the database is (the password is "e93049").
- type "updatedatabase.sh" (the password is "e93049").
o edit the file "sum.batch"
- on each of the two lines starting with "select", edit the two run-number
limits to reflect the range of runs you would like to use for summing
T5 triggers.
- this will allow you to sum T5 triggers (in units of Millions) for runs
between your limits that had the 4He target in place.
o type "gettotal.sh" (the password is "e93049")
- you now have your desired numbers!