#musicbrainz

/

      • nikki
        and I don't have 10.5 either, so I'm not sure how dual booting would work if I wanted to do that
      • 2010-06-24 17535, 2010

      • ruaok
        #include <alcohol.h>
      • 2010-06-24 17545, 2010

      • Leftmost
        nikki, how do you mean?
      • 2010-06-24 17546, 2010

      • ruaok
        was problably the best line of code I ever wrote. :)
      • 2010-06-24 17556, 2010

      • nikki seems to like her OSes old and dinosaury...
      • 2010-06-24 17505, 2010

      • jesus2099
        ruaok: 10 GOTO 10 is better
      • 2010-06-24 17510, 2010

      • nikki
        doesn't 10.5 have something included with osx to make it easy to install multiple OSes?
      • 2010-06-24 17527, 2010

      • Leftmost
        I dunno. I have 10.5. Don't use any built-in stuff.
      • 2010-06-24 17528, 2010

      • jesus2099
        nikki I have opera 10.53
      • 2010-06-24 17546, 2010

      • jesus2099
        nikki, I found you lastfm he he he he
      • 2010-06-24 17547, 2010

      • Leftmost
        rEFIt is a nice bootloader.
      • 2010-06-24 17529, 2010

      • nikki has opera 10.00 ¬_¬
      • 2010-06-24 17548, 2010

      • jesus2099
        do you still have the scrolbar marker thing?
      • 2010-06-24 17507, 2010

      • nikki
        if it was there, I turned it off
      • 2010-06-24 17511, 2010

      • jesus2099
        it is gone now (bug) for me
      • 2010-06-24 17533, 2010

      • jesus2099
        "if it was there, I turned it off": blah >:p
      • 2010-06-24 17519, 2010

      • nikki
        yeah, it's turned off :P
      • 2010-06-24 17547, 2010

      • jesus2099
        As another bug, it's really annoying that lastfm still didn't fix their buggy extended character encoding (???) in downloadable mp3's ID3 tags!
      • 2010-06-24 17559, 2010

      • nikki doesn't use last.fm so wouldn't know
      • 2010-06-24 17511, 2010

      • jesus2099
        I use it to host my mp3, it's quite cool this way except I cannot let my extended character mp3 downloadable just because of that bug http://last.fm/forum/21713/_/423718
      • 2010-06-24 17512, 2010

      • jesus2099
        man, I sounded so pretentious in my message two years ago : "Let me remind everyone that ID3v2.3 (used here) supports unicode."
      • 2010-06-24 17527, 2010

      • jesus2099
        hu hu hu like a "I know everything" kind of guys!
      • 2010-06-24 17540, 2010

      • jesus2099
        hey good night everyone, I want to shut down this warming machine !
      • 2010-06-24 17545, 2010

      • Leftmost
        2.3 only supports UTF-16, though.
      • 2010-06-24 17522, 2010

      • jesus2099
        leftmost: Anyway whatever version UTF-16 and UTF-8 can both support all unicode characters and we shouldn't end up with ??? it's a bug.
      • 2010-06-24 17539, 2010

      • Leftmost
        Yeah. I like UTF-8 better though.
      • 2010-06-24 17543, 2010

      • jesus2099
        I uppload them OK and they are altered NG
      • 2010-06-24 17544, 2010

      • Leftmost isn't a nerd at all.
      • 2010-06-24 17550, 2010

      • nikki
        utf-8 \o/
      • 2010-06-24 17555, 2010

      • jesus2099
        I like UTF-16 because 16 is higher than 8
      • 2010-06-24 17504, 2010

      • jesus2099
        it's better stronger number
      • 2010-06-24 17511, 2010

      • jesus2099
        more powerfuller!
      • 2010-06-24 17531, 2010

      • fatih1
        You might like UTF-32 better.
      • 2010-06-24 17537, 2010

      • nikki
        haha
      • 2010-06-24 17558, 2010

      • jesus2099
        Oh yes!!!! If it was available I would go for that in ID3 it would make them bigger and even better
      • 2010-06-24 17507, 2010

      • jesus2099
        more quality!
      • 2010-06-24 17512, 2010

      • Leftmost pets UTF-8.
      • 2010-06-24 17543, 2010

      • jesus2099
        UTF-16 is more quality than UTF-8 by the way!!! Like don't tell me you listen to 8 bit CDs, come one!
      • 2010-06-24 17545, 2010

      • Leftmost
        Nice compat encoding. Good for large amounts of ASCII text, too.
      • 2010-06-24 17509, 2010

      • jesus2099
        Even Playstaion is 32 bit, I want UTF-32 now!
      • 2010-06-24 17525, 2010

      • jesus2099
        3D mp3
      • 2010-06-24 17558, 2010

      • nikki
        hm. didn't opera have to remove utf-32 support to support html5 or something silly?
      • 2010-06-24 17537, 2010

      • jesus2099 joined the channel
      • 2010-06-24 17544, 2010

      • jesus2099
        HTML5 isn't there yet, is it? I only use HTML, I never liked XXXHTML
      • 2010-06-24 17547, 2010

      • Leftmost
        nikki, that would make no sense.
      • 2010-06-24 17502, 2010

      • Leftmost
        I mean, possible. But no sense.
      • 2010-06-24 17535, 2010

      • nikki
        yeah, but the world is full of people :P
      • 2010-06-24 17555, 2010

      • jesus2099
        nikki: that must be some kind of idiomatic expression
      • 2010-06-24 17529, 2010

      • jesus2099
        The fact that they do HTML again means I am roght
      • 2010-06-24 17533, 2010

      • nikki
        people do silly things that don't make sense
      • 2010-06-24 17546, 2010

      • jesus2099
        ah, that meaning
      • 2010-06-24 17549, 2010

      • nikki
        and the world is full of people, so the world is full of silly people doing things that don't make sense!
      • 2010-06-24 17517, 2010

      • jesus2099
        hey those people really suck!
      • 2010-06-24 17522, 2010

      • jesus2099
        ;)
      • 2010-06-24 17553, 2010

      • jesus2099
        I really have to go now. Do the washing up before sleeping
      • 2010-06-24 17515, 2010

      • jesus2099
        did you see my message when I used the /quit command ?
      • 2010-06-24 17541, 2010

      • nikki
        yes
      • 2010-06-24 17546, 2010

      • jesus2099
        I am not familiar with IRC
      • 2010-06-24 17519, 2010

      • jesus2099
        oh oh that means I can add any kind of cheesy lame remark when I leave he he (^o^)y
      • 2010-06-24 17541, 2010

      • jesus2099
        let's see...
      • 2010-06-24 17506, 2010

      • jesus2099
        bye nikki and fatih1 and ruaok and leftmost and YOU my chum!
      • 2010-06-24 17516, 2010

      • ruaok
        nn
      • 2010-06-24 17523, 2010

      • fatih1
        bye
      • 2010-06-24 17536, 2010

      • Acorn
        should bonus CDs, always have (bonus disc) appended?
      • 2010-06-24 17517, 2010

      • Acorn
        I think case "Beat Journey Bonus" is how it's written on the cd sleeve http://i.imgur.com/29IOt.jpg
      • 2010-06-24 17536, 2010

      • Acorn
        should it still be written as "Beat Journey (bonus disc)"?
      • 2010-06-24 17503, 2010

      • Acorn
      • 2010-06-24 17544, 2010

      • nikki
        yes, although if the bonus disc has its own title, you can do something like "release title (bonus disc: bonus disc title)"
      • 2010-06-24 17516, 2010

      • Acorn
        nikki, yes it should be left as "Beat Journey (bonus disc)"?
      • 2010-06-24 17501, 2010

      • Acorn
        "Beat Journey (bonus disc: Beat Journey Bonus)" Would be a little odd
      • 2010-06-24 17511, 2010

      • Acorn
        or do you think that's the right name for it?
      • 2010-06-24 17519, 2010

      • nikki
        the yes was to the question about whether it should have (bonus disc) (the whole (disc n) and (bonus disc) thing is a workaround because we don't currently support disc numbers and having a standardised format makes it easier to convert the data)
      • 2010-06-24 17533, 2010

      • nikki
        and I would personally just use "Beat Journey (bonus disc)"
      • 2010-06-24 17514, 2010

      • Acorn
        Okay, I'll leave it how it is then :)
      • 2010-06-24 17522, 2010

      • Acorn
        nikki, where can I find an explanation of autoedits?
      • 2010-06-24 17514, 2010

      • Acorn
        and is it possible to tell which of your edits were autoedits?
      • 2010-06-24 17527, 2010

      • nikki
        well there's http://musicbrainz.org/doc/Auto-Edit but I'm not sure how helpful that is
      • 2010-06-24 17552, 2010

      • Acorn
        does it mean someone with auto-editor privilages did something to my edits?
      • 2010-06-24 17517, 2010

      • Acorn
        or does it mean I edited a release I created and therefor it was an auto-edit or something?
      • 2010-06-24 17515, 2010

      • Mineo
        Acorn: autoedits have a little "Autoedit" text next to the edit type
      • 2010-06-24 17537, 2010

      • Acorn
        ah, I see now
      • 2010-06-24 17548, 2010

      • Acorn
        obviously I couldn't see them on the open edits page
      • 2010-06-24 17552, 2010

      • nikki
        if your edit is an auto-edit, it only means that it was automatically accepted, if an auto-editor approves an edit, it'll show up as a yes vote (which isn't very clear :/)
      • 2010-06-24 17520, 2010

      • Acorn
        and they were Disc IDs I added
      • 2010-06-24 17531, 2010

      • Acorn
        Should I set the track lengths from my TOCs? or should I leave them how they are?
      • 2010-06-24 17520, 2010

      • Mineo
        Acorn: if there are no track lengths set ModBot will automatically set them
      • 2010-06-24 17545, 2010

      • Acorn
        there are track lengths, some are about 1 seconds off from my TOC though
      • 2010-06-24 17555, 2010

      • Acorn
        *second
      • 2010-06-24 17557, 2010

      • nikki
        are there any other tocs?
      • 2010-06-24 17502, 2010

      • Acorn
        nope
      • 2010-06-24 17509, 2010

      • nikki
        I would set the times from your toc then
      • 2010-06-24 17516, 2010

      • Acorn
        okay
      • 2010-06-24 17502, 2010

      • nikki
        if there are other tocs, it could just be that the times match one of the others, if there aren't any others, then the times probably weren't taken directly from the cd
      • 2010-06-24 17503, 2010

      • Acorn
        yep, makes sense
      • 2010-06-24 17509, 2010

      • Milosz_ joined the channel
      • 2010-06-24 17534, 2010

      • ruaok joined the channel
      • 2010-06-24 17552, 2010

      • ^Balrog^
        I have postgres installed, but somehow bin/InitDb.pl is nowhere to be found.
      • 2010-06-24 17540, 2010

      • gnu_andrew joined the channel
      • 2010-06-24 17551, 2010

      • bench joined the channel
      • 2010-06-24 17519, 2010

      • bench
        ruaok, I'm confused about your puid query
      • 2010-06-24 17523, 2010

      • bench
        do you have more than one?
      • 2010-06-24 17510, 2010

      • ruaok
        yes.
      • 2010-06-24 17517, 2010

      • ruaok
        there is the search server building indexes.
      • 2010-06-24 17535, 2010

      • ruaok
        and the PUID lookup on the web site is slow as well. which means the Ws lookup for PUIDs suffers the same consequences.
      • 2010-06-24 17551, 2010

      • bench
        but that's a different query, right?
      • 2010-06-24 17515, 2010

      • ruaok
        correct.
      • 2010-06-24 17551, 2010

      • bench
        got an explain plan for that? :)
      • 2010-06-24 17508, 2010

      • ruaok
        I can dig one out, but it will take a few minutes. hold on
      • 2010-06-24 17551, 2010

      • bench
        no worries, I should probably go install a newer version of the mb database to really be helpful with this processess
      • 2010-06-24 17500, 2010

      • bench
        I assume this is all NGS stuff?
      • 2010-06-24 17503, 2010

      • ruaok
        yes
      • 2010-06-24 17526, 2010

      • bench
        yeah, I certainly haven't played with that yet
      • 2010-06-24 17532, 2010

      • ruaok
      • 2010-06-24 17536, 2010

      • ruaok
        that is the other ticket
      • 2010-06-24 17540, 2010

      • ruaok
        bah. the other code path needs to be examined in detail to see which the slow query is.
      • 2010-06-24 17556, 2010

      • bench
        it looks like that problem was fixed 2 hours ago?
      • 2010-06-24 17525, 2010

      • ruaok
        no, that is still way too slow.
      • 2010-06-24 17532, 2010

      • ruaok
        anything more than 50ms is too slow
      • 2010-06-24 17558, 2010

      • bench
        ah, ok
      • 2010-06-24 17532, 2010

      • ruaok
        hmm. maybe this case is quite differenent from the other case.
      • 2010-06-24 17540, 2010

      • ruaok
        like I said, I need to dig into it more.
      • 2010-06-24 17545, 2010

      • bench
        with only 512MB of shared buffers and 4GB of ram, I would think chances that a given puid will need to be fetched from disk are high.
      • 2010-06-24 17516, 2010

      • bench
        50ms isn't a lot of time to do 2 random reads, if much else is going on.
      • 2010-06-24 17549, 2010

      • ruaok
        well, if its slow on an idle system with those specs it will be a disaster in production
      • 2010-06-24 17555, 2010

      • jessew joined the channel
      • 2010-06-24 17527, 2010

      • bench
        oh, right, this box is mostly idle
      • 2010-06-24 17538, 2010

      • ruaok nods
      • 2010-06-24 17543, 2010

      • bench
        you should be able to get 50ms there.
      • 2010-06-24 17551, 2010

      • nikki wonders if bench = ben chobot
      • 2010-06-24 17509, 2010

      • bench
        yep
      • 2010-06-24 17511, 2010

      • ruaok nods at nikki
      • 2010-06-24 17514, 2010

      • nikki
        ah
      • 2010-06-24 17542, 2010

      • bench
        well, get me an explain analyze and I'll see what I can from it
      • 2010-06-24 17500, 2010

      • bench
        in the mean time, I'm gonna go mow some grass
      • 2010-06-24 17507, 2010

      • ruaok
        ah. with that index that lukas pointed out, its down to 46ms
      • 2010-06-24 17511, 2010

      • ^Balrog^
        I have postgres installed, but somehow bin/InitDb.pl is nowhere to be found.
      • 2010-06-24 17527, 2010

      • bench
        that still seems like a long time
      • 2010-06-24 17536, 2010

      • ruaok
        ^Balrog^: InitDb.pl is MB code, not postgres
      • 2010-06-24 17536, 2010

      • bench
        on a mostly idle box, it should be <10ms
      • 2010-06-24 17547, 2010

      • ^Balrog^
        thx
      • 2010-06-24 17500, 2010

      • bench
        even if it has to read from disk
      • 2010-06-24 17556, 2010

      • bench
        I don't remember how much infrastructure MB has these days, but this also looks like something that would be a great candidate for memcached
      • 2010-06-24 17527, 2010

      • bench
        (or more memory in the PG server. :) )
      • 2010-06-24 17536, 2010

      • ruaok
        we have a memcached server and our data model has two levels of caching built in.
      • 2010-06-24 17502, 2010

      • ruaok
        well, for now we should look at the query that we listed. with MBS-271 improved, I'm slightly relieved.
      • 2010-06-24 17525, 2010

      • ruaok
        The 44ms was for the whole WS call, not just one query, so I'm reasonably happy with it.