Querying pingback statistics

From notes
Revision as of 08:41, 1 March 2018 by Ccicalese (talk | contribs) (Created page with "{{Note |title=Querying pingback statistics }} # ssh to stat1006.eqiad.wmnet # mysql --defaults-extra-file="/etc/mysql/conf.d/research-client.cnf" -h analytics-slave.eqiad.w...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Author
Created 1 March 2018 13:41:51
Last Modified 1 March 2018 13:49:24
Tags
  1. ssh to stat1006.eqiad.wmnet
mysql --defaults-extra-file="/etc/mysql/conf.d/research-client.cnf" -h analytics-slave.eqiad.wmnet -e "select left(event_MediaWiki,6),count(*) from log.MediaWikiPingback_15781718 group by left(event_MediaWiki,6) order by event_MediaWiki;"
Retrieved from "https://wikifarm.wmflabs.org/notes/index.php?title=Note:9&oldid=154"