Note:9: Difference between revisions

From notes
No edit summary
No edit summary
 
Line 4: Line 4:
# ssh to stat1006.eqiad.wmnet
# 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;"
  <nowiki>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;"</nowiki>

Latest revision as of 09:49, 1 March 2018

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;"