src/utils/qa/realTime.csh 1.13
1.13 2009/07/13 22:59:37 kuhn
changed to hgw8 for now, as hgw1 is out for upgrade
Index: src/utils/qa/realTime.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/realTime.csh,v
retrieving revision 1.12
retrieving revision 1.13
diff -b -B -U 1000000 -r1.12 -r1.13
--- src/utils/qa/realTime.csh 10 Jul 2009 19:00:35 -0000 1.12
+++ src/utils/qa/realTime.csh 13 Jul 2009 22:59:37 -0000 1.13
@@ -1,79 +1,79 @@
#!/bin/tcsh
source `which qaConfig.csh`
################################
#
# 10-10-06
# Robert Kuhn
#
# gets update times from all machines in realTime
#
################################
set tablelist=""
set tables=""
set db=""
set ver=""
set subver=""
set update=""
if ( $#argv != 2 ) then
echo
echo " gets update times from all machines in real time for tables in list."
echo
echo " usage: database tablelist (will accept single table)"
echo
exit
else
set db=$argv[1]
set tablelist=$argv[2]
endif
# cat $tablelist
if ( "$HOST" != "hgwdev" ) then
echo "\n error: you must run this script on dev!\n"
exit 1
endif
# check if it is a file or a tablename
file $tablelist | egrep "ASCII text" > /dev/null
if (! $status) then
set tables=`cat $tablelist`
else
set tables=$tablelist
endif
foreach table ($tables)
echo
echo $table
echo "============="
- foreach machine ( hgwdev hgwbeta hgw1 )
- if ( "hgw1" == $machine ) then
+ foreach machine ( hgwdev hgwbeta hgw8 )
+ if ( "hgw8" == $machine ) then
echo # space out results
endif
# find out version of mysql running
# (v 5 has different signature for TABLE STATUS output)
# (so does ver 4.1.*)
set ver=`getVersion.csh $machine 1` >& /dev/null
set subver=`getVersion.csh $machine 2`
if ( 4 == $ver && 1 == $subver || 5 == $ver ) then
# newer mysql versions use different fields
set update=`getTableStatus.csh $db $machine | sed '1,2d' \
| grep -w ^$table | awk '{print $14, $15}'`
if ( $status ) then
echo "."
continue
endif
else
set update=`getTableStatus.csh $db $machine | sed '1,2d' \
| grep -w ^$table | awk '{print $13, $14}'`
if ( $status ) then
echo "."
continue
endif
endif
echo "."$update
end
end
echo