Workaround:
f=slow.log qts=`grep "Query_time" $f | awk '{ print $3}'` last_time=0.0 scale=6 for t in $qts do real_tq=`echo "scale=$scale;$t-$last_time" | bc -l| sed 's/^\./0./'` echo $real_tq cat $f | sed "s/# Query_time: $t Lock_time:/# Query_time: $real_tq Lock_time:/" > tmp mv tmp $f last_time=$t done
Workaround:
f=slow.log
real_tq= `echo "scale= $scale; $t-$last_ time" | bc -l| sed 's/^\./0./'`
last_time= $t
qts=`grep "Query_time" $f | awk '{ print $3}'`
last_time=0.0
scale=6
for t in $qts
do
echo $real_tq
cat $f | sed "s/# Query_time: $t Lock_time:/# Query_time: $real_tq Lock_time:/" > tmp
mv tmp $f
done