[02:09:45] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Operations, 10Performance-Team, and 6 others: Cache invalidations coming from the JobQueue are causing lag on several wikis - https://phabricator.wikimedia.org/T164173#3463486 (10aaron) I commented on the patch, it's a __METHOD__ mismatch problem, so the comm... [15:59:19] wotcha, hopefully a quick question - is there a dump/a way to dump the labs replica centralauth_p db to run local queries on? [16:49:31] Why do you need to dump it to do that? [22:01:24] TheresNoTime: you can use mysql_dump (or whatever the command is) but I think it's going to be pretty large [22:05:48] Thanks legoktm, not sure if I'm going to need to anyway, was only going to try to run some queries to track down sock accounts (username similarity) and didn't want to put load on the replica with my awful SQL :D [22:06:48] https://tools.wmflabs.org/meta/gusersearch/ might be helpful [22:07:37] the purpose of replicas is for people to use them and put load on them. if you think it might be too much we can help you review and optimize your queries, but in general I don't think doing basic user searches can kill it