July 2010 - binari@psb.ugent.be - maillist.psb.ugent.be

[Binari] mysql indexing
by Michiel Van Bel 06 Sep '10

06 Sep '10

okay, I'm a bit confused: http://dev.mysql.com/doc/refman/4.1/en/multiple-column-indexes.html You see 2 examples at the bottom, where the name index is NOT used. I understand why the index is not used in the first example, but why is it not used for the "last_name" part in the query of the second example? I think I need to revise my knowledge on indexing a bit :-/ -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.vib-ugent.be http://www.psb.vib-ugent.be http://bioinformatics.psb.ugent.be ==================================================================

5 10

[Binari] mmap
by Frederik Delaere 16 Jul '10

16 Jul '10

http://en.wikipedia.org/wiki/Mmap is er een optie om bvb in blast hier gebruik van te maken ? lost direct het probleem op dat de clusternodes te weinig mem hebben ? idem voor die NGS dingen -- ================================================================== Frederik Delaere Tel:+32 (0)9 331 38 14 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM frlae(a)psb.vib-ugent.be http://www.psb.vib-ugent.be ==================================================================

3 5

[Binari] attn raad der ouderen
by Marijn Vandevoorde 16 Jul '10

16 Jul '10

klpoe vroeg of hij ook niet op de binari lijst mag. ik kan dat natuurlijk doen en klaas lijkt me nu wel iemand die het allemaal wel weet te plaatsen precies, dus ik zie er geen graten in. maar ik wou het toch nog even voorleggen aan de raad van bestuur... bij deze, all in favour, say aye of zoiets. -- Marijn Vandevoorde Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM marijn.vandevoorde(a)psb.vib-ugent.be http://www.psb.vib-ugent.be ================================================================== "You Can't touch this" --M.C. Hammer

8 24

Re: [Binari] [Fwd: July 19th: network maintenance and /group/tmp merge]
by Thomas Abeel 16 Jul '10

16 Jul '10

What's you're trying to say is: Don't try to work during the GF at all, we will make sure nothing works anyway. I think this is a great initiative! kudos IT Frederik Delaere schreef: > reminder :) > > and also don't forget there will also be a windows network drive > maintenance > > > -------- Original Message -------- > Subject: July 19th: network maintenance and /group/tmp merge > Date: Tue, 13 Jul 2010 14:09:18 +0200 > From: Frederik Delaere <frlae(a)psb.vib-ugent.be> > To: Biocomp <biocomp(a)psb.ugent.be> > CC: Luc Van Wiemeersch <luwie(a)psb.ugent.be> > > > > Dear all, > > On Monday the 19th of july there will be a network maintenance. A > network link between > the storage and the cluster will go down for a while. All running jobs > on the cluster and > on midas will crash. So make sure your jobs are finished or you wait to > submit after > the maintenance. > > We will also merge the two temp shares to one big share, to make the > process faster > please empty the shares as much as possible (yes I'm talking about a big > cleanup). > Keep in mind that after this merge your paths to the temp shares will > have to be > modified, we'll inform you about the correct path later. > > regards, > Frederik >

1 0

[Binari] welcome to klpoe
by Marijn Vandevoorde 16 Jul '10

16 Jul '10

Welcome to binari, Klaas, where we talk in riddles, most of them without answers. To the others: for all klaas related gossip, I've now created the binariwithoutklaas(a)psb.ugent.be mailinglist With kind regards, I.T. -- Marijn Vandevoorde Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM marijn.vandevoorde(a)psb.vib-ugent.be http://www.psb.vib-ugent.be ================================================================== "You Can't touch this" --M.C. Hammer

3 6

[Binari] The IT Crowd Basement
by Kenny Billiau 15 Jul '10

15 Jul '10

http://www.channel4.com/programmes/the-it-crowd/articles/explore-the-it-bas… Try to find the XKCD poster ;)

5 4

[Binari] google search results
by Michiel Van Bel 14 Jul '10

14 Jul '10

Pretty funny diverse search results, for a rather technical search query: http://www.google.be/#hl=nl&source=hp&q=swing+slow+x+forwarding&aq=f&aqi=&a… -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.vib-ugent.be http://www.psb.vib-ugent.be http://bioinformatics.psb.ugent.be ==================================================================

1 0

[Binari] guglegruppe <<curvature>>
by Kenny Billiau 14 Jul '10

14 Jul '10

This is by far the weirdest cakephp text that I've read: http://cake-php.blogspot.com/ -- ====================================================================== Kenny Billiau Bioinformatics Group / GoFORSYS Scientific Programmer +49 331 567 8626 billiau(a)mpimp-golm.mpg.de Max Planck Institute for Molecular Plant Physiology Am Mühlenberg 1, 14476 Potsdam-Golm, Germany http://bioinformatics.mpimp-golm.mpg.de http://www.goforsys.de ======================================================================

2 1

[Binari] sql performance
by Michiel Van Bel 13 Jul '10

13 Jul '10

okay, I have a table with columns A, B, C There is a separate index on all columns If my query looks like this : "WHERE A=? AND (B=? OR C=?) " Then the runtime for 300 queries is about 70 seconds (which is way too long) If my query looks like this: "WHERE A=? AND B=? OR C=? " Then the runtime for 300 queries is about 1 second (which is a lot more sensible). Now, the question is of course, why is mysql so fucking slow, when I just add some brackets? And is the result of the first query equal to this: "WHERE A=? AND B=? OR A=? AND C=? " Or am i missing something? -- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel(a)psb.vib-ugent.be http://www.psb.vib-ugent.be http://bioinformatics.psb.ugent.be ==================================================================

3 4

[Binari] the universe and everything
by Marijn Vandevoorde 09 Jul '10

09 Jul '10

sweeeeeet: http://www.standaard.be/artikel/detail.aspx?artikelid=AC2SH9U2 -- ================================================================== Marijn Vandevoorde Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM marijn.vandevoorde(a)psb.vib-ugent.be http://www.psb.vib-ugent.be ================================================================== "Fat bottomed girls, you make the rockin' world go round." --F. Mercury

2 1