Hi Michael, Our genome-mysql server had some queries that were stuck. We killed them and it should now be functional again. Please let us know if you encounter any other issues.
Best, Mary ------------------ Mary Goldman UCSC Bioinformatics Group On 4/5/11 4:32 AM, Michael Lush wrote: > Have a query which I run to get UCSC2HGNC ID mappings > > SELECT geneSymbol, hgncId, transcript, '-' > FROM knownCanonical,kgXref,proteome.hgncXref > WHERE kgXref.kgID=knownCanonical.transcript > AND kgXref.geneSymbol = proteome.hgncXref.symbol > > I'm running it on > > mysql -h genome-mysql.cse.ucsc.edu -u genome -A > USE hg19 > > and the query just hangs and sits there for hours > > -- > Michael > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Michael John Lush PhD Tel:44-1223 492626 > Bioinformatician HUGO Gene Nomenclature Committee Email: > [email protected] > European Bioinformatics Institute > Hinxton, Cambridge > URL: http://www.genenames.org > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
