Comment 1 for bug 719386

Revision history for this message
Aleksandr Kuzminsky (akuzminsky) wrote :

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