Home » Blogs » jwebb's blog

Stupid mysql tricks

Updated on Sat, 2009-02-21 18:44. Originally created by jwebb on 2009-02-21 18:29.
 

$ mysql -h onldb.starp.bnl.gov --port 3501 RunLog -s -E -e "SELECT * from runDescriptor"

 
[example output]

*************************** 1842. row ***************************
dataID: 22750
entryTime: 2009-02-21 22:26:28
nodeID: 1
elementID: 0
beginTime: 2009-02-21 22:23:22
endTime: 2037-01-01 00:00:00
flavor: ofl
schemaID: 1
deactive: 0
runNumber: 10052026
startRunTime: 1235255002
endRunTime: 1235255160
glbSetupName: pedestal_localclock
daqSetupName: pedestal
trgSetupName: pedestal_localclock
scSetupName: tcd

 

$ mysql -h onldb.starp.bnl.gov --port 3501 Conditions_rts -s -E -e "select * from run"

 
[example output]
*************************** 1864. row ***************************
dataID: 26842
entryTime: 2009-02-21 22:28:14
nodeID: 28
elementID: 0
beginTime: 2009-02-21 22:28:12
endTime: 2037-01-01 00:00:00
flavor: ofl
schemaID: 2
deactive: 0
idx_rn: 10052027
cfg_time: 1235255292
GLB_SETUP_name: pedestal_localclock
run_number: 10052027
bField: -0.50099999
base_trg_rate: 1000.00000000
destination: 2
DICT_name: ped_090217.dict
TRG_SETUP_name: pedestal_localclock
TRG_RUN_name: pedestal_rhicclock
TCD_SETUP_name: tcd
DAQ_SETUP_name: pedestal
DAQ_RUN_name: daq
L3_RUN_name:
Expansion_name:
TIER1_name: ped_090217.bin
configOpt: 0
maxTknInSystem: 0
minTknInSystem: 0
tokenMod: 0
nTokensIn: 0
nTokenReturn: 0
tokenTimer: 0
clockSource: 3
numClockTicks: 0
l2DataWrite: 1
dataWriteTimer: 0
everyNEvents: 0
enableHalt: 0
enableContProt: 0
ContLength: 0
run_type: 1
evp_suppression: 0
event_suppression: 0
gl3_formats: 0
gl3_formats_local: 0
write_daq: 0
write_local: 0
l3_rate: 0
twhash: 66
dictHash: 3428845076
dataStreamNamesHash: 1185825730
tcdSetupHash: 1552735002
 

 

»