2011-07-27T00:06:25 *** ltriant has quit IRC (Ping timeout: 252 seconds) 2011-07-27T00:11:26 *** mcstar has quit IRC (Quit: WeeChat 0.3.5) 2011-07-27T00:23:37 *** ltriant has joined #aichallenge 2011-07-27T00:26:23 *** vdp|afk is now known as vdp 2011-07-27T00:28:22 evening 2011-07-27T00:39:51 *** vdp is now known as vdp|afk 2011-07-27T00:39:56 *** ibdknox has joined #aichallenge 2011-07-27T01:16:14 http://maps.google.com/maps?q=queen+street+sandy+bay&hl=en&ll=-42.894524,147.331166&spn=0.006823,0.016512&sll=-42.894493,147.331038&sspn=0.006862,0.016512&t=h&z=17&layer=c&cbll=-42.89449,147.331038&panoid=Le3vxJnKmuERrXBBDVMkDg&cbp=12,301.58,,0,18.66 2011-07-27T01:16:28 yeah, i made it onto google maps, except they didn't use hte data from when it actually drove past me :( 2011-07-27T01:16:43 (that's me walking across the road) 2011-07-27T01:21:53 antimatroid: fascinating, I remember a google car driving past me, too - does that mean ... lol wait a moment 2011-07-27T01:22:06 :) 2011-07-27T01:22:20 that was from like januaryish 2010 2011-07-27T01:22:41 that's also my red car that disappears when you move forward 2011-07-27T01:25:35 no I'm not on photo :). Did you notice the 3d-spheres in google-earth recently? 2011-07-27T01:26:45 You get street view and other 3d panomara websites connected with google-earth, so you can zoom in to highways around nature resorts or old french villages 2011-07-27T01:28:02 I bet in a year or so you can 'drive' along the street view streets while keeping a 360° view 2011-07-27T01:28:15 that's pretty cool 2011-07-27T01:28:21 i like bings aerial view from an angle 2011-07-27T01:28:40 i don't use bing, someone had to tell me to check that out, google all the way otherwise :P 2011-07-27T01:33:02 *** ohcrivens has joined #aichallenge 2011-07-27T02:16:15 *** amstan has quit IRC (Ping timeout: 255 seconds) 2011-07-27T02:23:17 *** nux67 has quit IRC (Quit: Page closed) 2011-07-27T02:46:51 *** berak has joined #aichallenge 2011-07-27T03:32:52 *** Palmik has joined #aichallenge 2011-07-27T03:52:28 *** ltriant has quit IRC (Quit: Computer has gone to sleep) 2011-07-27T04:18:28 *** Naktibalda has joined #aichallenge 2011-07-27T04:33:00 *** ibdknox has quit IRC (Remote host closed the connection) 2011-07-27T05:18:25 *** ohcrivens has quit IRC (Quit: Page closed) 2011-07-27T05:35:30 *** _flag <_flag!~flag@69.165.173.172> has joined #aichallenge 2011-07-27T05:56:00 *** sigh has joined #aichallenge 2011-07-27T06:31:07 *** onensora has joined #aichallenge 2011-07-27T06:52:47 *** mcstar has joined #aichallenge 2011-07-27T07:17:21 *** FireFly has joined #aichallenge 2011-07-27T07:27:45 *** jmreardon has joined #aichallenge 2011-07-27T07:58:52 *** mathis has joined #aichallenge 2011-07-27T08:23:29 *** mcstar has quit IRC (Quit: WeeChat 0.3.5) 2011-07-27T08:36:44 *** jmreardon has quit IRC (Quit: jmreardon) 2011-07-27T09:20:55 *** TTE has joined #aichallenge 2011-07-27T09:35:44 *** nullkuhl has quit IRC (Ping timeout: 250 seconds) 2011-07-27T09:38:28 morning 2011-07-27T09:49:23 evening :p 2011-07-27T10:07:19 *** jmreardon has joined #aichallenge 2011-07-27T10:23:46 morning 2011-07-27T10:31:17 *** sigh has quit IRC (Remote host closed the connection) 2011-07-27T10:34:37 does anyone know any category theory? jmcarthur !? 2011-07-27T10:35:08 do people refuse to use the element of relation for elements of ob(C) and hom(C) because they don't want to confuse the "collections" as "sets"? 2011-07-27T11:08:15 *** mathis has quit IRC (Disconnected by services) 2011-07-27T12:07:48 *** nux67 has joined #aichallenge 2011-07-27T12:16:02 *** nullkuhl has joined #aichallenge 2011-07-27T12:16:02 *** nullkuhl has joined #aichallenge 2011-07-27T12:23:00 *** nux67 has quit IRC (Ping timeout: 252 seconds) 2011-07-27T12:41:35 *** bhasker has quit IRC (Quit: bhasker) 2011-07-27T12:54:36 *** Naktibalda has quit IRC (Quit: ChatZilla 0.9.87 [Firefox 5.0/20110615151330]) 2011-07-27T13:16:46 *** Accoun has quit IRC (Read error: Connection reset by peer) 2011-07-27T13:17:40 *** Accoun has joined #aichallenge 2011-07-27T13:29:12 *** bhasker has joined #aichallenge 2011-07-27T13:48:23 *** agweber has joined #aichallenge 2011-07-27T14:24:02 *** aerique has joined #aichallenge 2011-07-27T14:26:18 *** aerique has quit IRC (Client Quit) 2011-07-27T14:28:09 Quiet isn't it 2011-07-27T14:54:26 *** agweber has quit IRC (Ping timeout: 252 seconds) 2011-07-27T15:00:21 *** mathis has joined #aichallenge 2011-07-27T15:15:39 *** ohCrivens has joined #aichallenge 2011-07-27T15:15:53 *** amstan has joined #aichallenge 2011-07-27T15:15:53 *** ChanServ sets mode: +o amstan 2011-07-27T15:17:08 so what is the plan of taking this out of beta? 2011-07-27T15:23:04 *** Accoun has quit IRC () 2011-07-27T15:23:52 bhasker: we need to fix the bugs first 2011-07-27T15:23:56 like the trueskill one 2011-07-27T15:24:23 oh k, btw i have some experience tuning mysql setups 2011-07-27T15:24:30 so i can help with speeding up the ranking page display 2011-07-27T15:24:37 for 200 bots it takes forever to load 2011-07-27T15:24:40 bhasker: go right ahead 2011-07-27T15:24:49 anyway i can have a look at the mysql query being used for that 2011-07-27T15:24:57 and the indexes and the table schema 2011-07-27T15:25:51 bhasker: see website/sql for the queries 2011-07-27T15:26:01 k cool 2011-07-27T15:26:44 aichallenge: Marco Leise epsilon * r3e09f63 / (ants/util/scheduler_test.d worker/compiler.py): added -noboundscheck to compile options for D - https://github.com/aichallenge/aichallenge/commit/3e09f63ca926d1d243b06e1fe4ec00b33e1da566 2011-07-27T15:30:06 hmm i am looking at the code, it seems to pull the ranking page from a memcache 2011-07-27T15:30:13 and there is a function to actually fetch from mysql 2011-07-27T15:30:17 but i don't see it being called at all 2011-07-27T15:30:32 and if the data is coming from memcache why is it soooo slow? 2011-07-27T15:30:47 bhasker: i think there's so errors with memcache, mcleopold was talking about that 2011-07-27T15:30:50 he might have disabled it 2011-07-27T15:31:04 hmm so the code in git is not what is running on the server? 2011-07-27T15:31:12 the code in git for rankings.php pulls from memcache 2011-07-27T15:31:22 rather ranking.php* 2011-07-27T15:31:32 yes, but is there anything that fills the memcache? 2011-07-27T15:33:49 there is a function 2011-07-27T15:33:52 but i don't see it being called 2011-07-27T15:34:17 bhasker: grep for it 2011-07-27T15:34:30 anyways the rankings query seems rather complicated hmm would need to explain the query to see what its really doing 2011-07-27T15:34:39 anyway i can get access to the mysql server itself 2011-07-27T15:34:40 yeah.. 2011-07-27T15:36:03 *** Accoun has joined #aichallenge 2011-07-27T15:36:09 can you pm me how i can do that, just looking at the query doesn't ring any bells and its doing like 5 inner joins and 3 left outer joins 2011-07-27T15:36:11 thats a looo 2011-07-27T15:36:13 thats a lot 2011-07-27T15:36:15 of joins 2011-07-27T15:36:28 with one nested table too 2011-07-27T15:36:34 not sure about the structure 2011-07-27T15:36:39 mcleopold knows this 2011-07-27T15:36:41 though i believe that best way to solve this 2011-07-27T15:36:49 is to do this query once every minute 2011-07-27T15:36:54 and just store it in a table 2011-07-27T15:37:03 or memcache would fix this 2011-07-27T15:37:13 we have a query that adjusts stuff every few minutes 2011-07-27T15:37:14 but i am sure the query itself can be optimized too 2011-07-27T15:37:20 see manager/manager.py 2011-07-27T15:37:59 off my cuff i am reasonably sure that its probably the count(*) which are slowing the query down 2011-07-27T15:38:19 are the tables myisam or innodb? 2011-07-27T15:38:52 the sql template is in setup/ 2011-07-27T15:40:26 hmm k 2011-07-27T15:40:46 i would need real data to play with just creating the empty schema is not useful 2011-07-27T15:41:01 is there a db dump that i can download 2011-07-27T15:41:10 then i can load into a db of mine and play with it 2011-07-27T15:41:36 bhasker: i can get you one in like 30 min 2011-07-27T15:41:54 that would be good 2011-07-27T15:42:25 30 minutes is not the time he works on that, but the time MySQL will need :p 2011-07-27T15:42:39 mleise: i didn't count that 2011-07-27T15:43:00 a dump should be rather fast 2011-07-27T15:43:13 this is probably a small database of the order of 10's of mb 2011-07-27T15:43:25 just get me a full dump with schema 2011-07-27T15:43:31 then i can just load it one shot 2011-07-27T15:43:39 instead of loading individual tables 2011-07-27T15:43:44 bhasker: i have to take out emails and hashes first 2011-07-27T15:44:00 ah forgot about that hmm 2011-07-27T15:44:09 privacy issues 2011-07-27T15:44:26 yea please go ahead and scrub the data anyway you like 2011-07-27T15:44:40 i just need the game data and the rankings tables etc don't really care about the player data 2011-07-27T15:45:19 bhasker: you can help me if you want.. 2011-07-27T15:45:52 bhasker: like.. how do i copy a table, and how do i export everything 2011-07-27T15:46:08 the other stuff i know offhand 2011-07-27T15:46:20 hmm let me pull up the mysqldump command help 2011-07-27T15:46:27 i have done this before just need to refresh my memory 2011-07-27T15:46:30 give me a couple of mintues 2011-07-27T15:46:30 yeah.. nvm, mysqldump should be enough 2011-07-27T15:46:36 i need to copy a table though 2011-07-27T15:47:13 i don't think i really need the player table at all? 2011-07-27T15:47:17 the rankings query doesn't use it 2011-07-27T15:47:51 you might need it.. 2011-07-27T15:47:53 might as well 2011-07-27T15:51:40 stopping apache too 2011-07-27T15:51:49 might go faster then 2011-07-27T15:52:47 bhasker: so.. how do i copy a table? 2011-07-27T15:53:11 bhasker: yeah, this thing is 300M+ 2011-07-27T15:53:13 do you still want it? 2011-07-27T15:53:20 hold on 2011-07-27T15:53:24 to copy its pretty trivial 2011-07-27T15:53:38 just CREATE TABLE tbl name