[17:45:32] <Reedy>	 Hey jynus, have you looked at db1053?
[17:45:39] <Reedy>	 https://ganglia.wikimedia.org/latest/?r=day&cs=&ce=&m=cpu_report&c=MySQL+eqiad&h=db1053.eqiad.wmnet&tab=m&vn=&hide-hf=false&mc=2&z=medium&metric_group=NOGROUPS
[17:46:21] <Reedy>	 lots of out traffic, lots of cpu wait, but replag seems to be incrasing
[17:47:58] <jynus>	 it the dumps
[17:48:15] <jynus>	 no other production traffic is there
[17:53:21] <jynus>	 https://tendril.wikimedia.org/activity?wikiuser=0&research=0&labsusers=0
[18:33:19] <Reedy>	 Thanks
[18:38:00] <Betacommand>	 jynus: you around?
[18:39:08] <jynus>	 Betacommand, yes
[18:39:55] <Betacommand>	 how you do you specify which db server to run a query on?
[18:40:10] <Betacommand>	 I tried:
[18:40:12] <Betacommand>	 mysql -h labsdb1003.eqiad.wmnet plwikisource_p -e "SELECT count(page_id) FROM page WHERE page_namespace=100 AND page_is_redirect=0"
[18:40:25] <jynus>	 if you are talking about labs, probably that is question for #wikimedia-labs
[18:40:30] <Betacommand>	 but got an access denied message
[18:40:50] <Betacommand>	 jynus: I asked but got silence
[18:41:05] <Reedy>	 Can't you do sql dbname -h...
[18:41:12] <jynus>	 I am not very familiar with labs special setup, an I use the admin access
[18:41:24] <Betacommand>	 let me try
[18:43:08] <Betacommand>	 nope
[18:44:02] <Betacommand>	 ERROR 1045 (28000): Access denied for user 'betacommand-dev'@'10.68.17.228' (using password: YES)
[18:44:11] <Betacommand>	 thats the error Im getting
[18:44:14] <Reedy>	 cause that's not the right username
[18:44:39] <Reedy>	 isn't dbusername u1234?
[18:45:07] <Betacommand>	 Doh, its not using the .cfg
[18:47:31] <Betacommand>	 thanks, fixed by adding  --defaults-file="${HOME}"/replica.my.cnf