[00:03:06] yup! although you might also poke Roan? [00:03:13] he's been messing around in core for donkey's years. [00:03:52] ok, cool! thanks! [00:03:56] werdna is the one who did the user_properties table refactoring and stuff [00:04:15] it used to just be a blob in the user table :P [00:04:42] * Ironholds shudders [00:04:44] ah, the blob days [00:04:56] when user_rights rampaged across the landscape, sowing devastation in its wake [03:00:45] Hey Ironholds. Still around? [03:43:14] Ironholds, app page views fit beautifully. [03:43:19] :) [03:58:40] halfak, I'm back [03:58:41] yay! [03:58:48] check mobile web? That's de-searched and de-spidered. [16:03:27] morning halfak :) [16:03:38] o/ everyone [16:06:35] Hey Ironholds [16:06:38] Yo Nettrom [16:06:56] I'm in your lab, sciencing your phenomena. [16:07:00] nice! [16:07:06] any luck sciencing the mobile web data? ;) [16:07:35] Yes. Still a huge peak at 18 min. [16:07:46] But it fits a bit better. I'll demo during our meeting today. [16:07:49] *present [16:08:42] cool! [16:09:00] then I shall launch a query retrieving uri_path so we can see wtf the peak is ;p [16:09:15] did we ever work out if the 18m events are from a particular group of people? [16:09:43] I haven't had time yet. I'm still just catching up on new datasets. [16:10:09] We have AOL, Wikipedia, League of Legends, Stack overflow and Movielens. :) [16:10:17] wooo! [16:11:08] SO? I can write a paper on how long it takes Brian Ripley to reply to R questions with dickishness [16:13:28] Ironholds, you changed timestamp formats on me. :P [16:13:54] "%Y-%m-%d %H:%M:%S" --> "%Y-%m-%dT%H:%M:%S" [16:14:06] In a way, it is helping me keep track of which datasets have been updated. [16:16:18] brb reboot [16:23:00] did I? Dammit, I thought I'd sanitised them.That's the requestlog format. [18:42:40] halfak, your wifi is bad indeed ;p [18:45:32] okay, I have another meeting now. Womp womp :( [18:47:50] Back in call [18:47:54] OK. [18:47:58] Will post summafry afterwards [20:47:07] halfak, you're back! [20:47:15] you want the good news or the really good news? [20:47:15] Yeah. Bad WIFI [20:47:29] the good news: I validated my worries about hashing! [20:47:45] the really good news: you should recheck mobile_web_events.tsv and see if you still find the same oddball spikes. [20:47:49] I may have solved it. [20:48:27] basically, we have 5-6 uniques making the vast majority of requests at precisely 1200 and 1201 seconds. [20:48:32] I think this is the source of the problem. [20:54:21] halfak, ^ [20:54:29] in meeting brb [20:54:33] kk! [22:06:53] this is like, the third meeting today that's been in some weird place. grumblegrumble fifth-floor-buildout already.