Good Morning Michael: There are too many databases and tables in the UCSC MySQL system for generic database browser tools such as you are using to work with. Try this command on a command line to see all databases:
$ mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -e "show databases;" hg18 Try this command to see all tables in database 'hg18': $ mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -e "show tables;" hg18 There are 4,593 tables in this database. Your browser tools are attempting to query each of those tables for all of their columns. That would take a long time. Our database schema definition is kept in this file: http://hgwdev.cse.ucsc.edu/~kent/src/unzipped/hg/makeDb/schema/all.joiner You can use our "tables browser" to examine the database table relationships: http://genome.ucsc.edu/cgi-bin/hgTables?db=hg18 http://genome.ucsc.edu/goldenPath/help/hgTablesHelp.html --Hiram Michael Zouberakis wrote: > Hello, > > I'm experiencing enormous delays when attempting to query any of the > databases @ genome-mysql.cse.ucsc.edu. > > I'm using version 1.2.17 of MySQL's Query Browser and connect to > genome-mysql.cse.ucsc.edu using the information provided here > http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29 > <http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29> > I can successfully connect to the server and can see a listing of all > databases in the Query Browser window. When attempting to view the tables of > a database via Query Browser's GUI the application either hangs completely > or takes approximately (more than) 10 minutes just to display the tables > under a schema. I'm experiencing similar side effects when trying to > retrieve table information from a schema using a simple Java class (MySQL > JDBC version 5.1.2). > > Any suggestions/hints on how to overcome this issue are welcome. Thanks in > advance. > > Kind Regards, > Michael _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
