mozilla / identity-ops

Tools and Chef cookbooks used by Mozilla Services Operations to provision and manage Persona
Other
24 stars 12 forks source link

Count unique RPs for rest of the week #122

Closed kparlante closed 11 years ago

kparlante commented 11 years ago

@gene1wood Thanks for getting the RP numbers -- that was totally helpful. It would be great if we could do this again for 5-7 days (separate files for each day).

Same process as https://github.com/mozilla/identity-ops/issues/119

gene1wood commented 11 years ago

Running this in each region

region=us-west-2
for day in 2 3 4 5 6; do 
  (for host in `get_hosts prod webhead`; do 
    ssh $host "zcat /var/log/nginx/access.log-2013082${day}.gz | 
      grep 'GET /sign_in' | 
      awk '{print \$11}' | 
      sed -e 's#.*//\([^/]*\).*#\1#'"; 
    done) > 2013082${day}.txt.$region; 
done

and then

scp root@admin.identity.us-west-2.prod.mozaws.net:2013082* ./
scp root@admin.identity.us-east-1.prod.mozaws.net:2013082* ./
for day in 2 3 4 5 6; do cat 2013082${day}.txt.* | sort | uniq -c | sort -rn > 2013082${day}.summary.txt; done

And I'll email you the results

gene1wood commented 11 years ago

Sent