Querying pingback statistics

From notes
Revision as of 08:49, 1 March 2018 by Ccicalese (talk | contribs)
(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 where event_MediaWiki != '' group by left(event_MediaWiki,6) order by event_MediaWiki;"
Retrieved from "https://wikifarm.wmflabs.org/notes/index.php?title=Note:9&oldid=156"