Note:9: Difference between revisions
(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...") |
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 group by left(event_MediaWiki,6) order by event_MediaWiki;" | 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;" | ||
Revision as of 08:48, 1 March 2018
| Author | |
|---|---|
| Created | 1 March 2018 13:41:51 |
| Last Modified | 1 March 2018 13:49:24 |
| Tags |
- 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;"