d78441779ba20c7b455b086247fd4c35e5e24a7a max Wed May 26 03:26:41 2021 -0700 adding docs for tableList, refs #27390 diff --git src/product/ex.hg.conf src/product/ex.hg.conf index 2b150a6..223988f 100644 --- src/product/ex.hg.conf +++ src/product/ex.hg.conf @@ -19,35 +19,44 @@ # if your MySQL system is configured for a different socket connection, # use the following variables to override the MySQL defaults: # db.socket=/var/lib/mysql/mysql.sock # db.port=3306 # *!# NOTE: the port override will only work when host is *not* localhost # when localhost is used, MySQL may connect via shared memory # connections and not via TCP/IP socket ports # slow-db is the name of a MySQL host to fallback to if a query failed # on db.host. This means that tables can be dropped from db.host as long as # they are present on slow-db. #slow-db.host=genome-mysql.soe.ucsc.edu #slow-db.user=genomep #slow-db.password=password -# If the slow-db host is too far away, a table on db.host with schema information -# of the slow-db databases will speed up most tracks. The table is created with -# the command "makeTableList" and its name is specified here +# If the slow-db host is far away (more than a few msecs), a table on db.host +# with schema information of the slow-db databases will speed up most tracks. +# The table is created with the command "makeTableList" and its name is +# specified here. If you activate the command below, AND you also have a genome +# assembly database on your local mirror that is not present on +# genome-mysql.soe.ucsc.edu, then you will need to run the tool 'makeTableList +# ' to make your genome usable. The table list is a pretty essential +# tool to increase remote data access performance to genomes loaded from UCSC, +# via slow-db and gbdbLoc1/2 (see below) and so it is assumed to be present. +# The code does not know if a genome is local-only or local-and-UCSC, so the tableList +# must be created for local databases if you use the showTableCache speedup. # showTableCache=tableList + # If your mysql server is configured to reject the option LOCAL in the command # LOAD DATA INFILE (e.g. in OpenSuse) then you can force the browser to never # use the LOCAL option. Note that for this to work, you have to keep all you # mysql servers on the same machine as the CGIs and these servers must have # file permissions and any security infrastructure like SELinux or AppArmor # setup in a way that allows them to read temporary files that the CGIs # (hgCustom, the custom track loaders) create # db.neverLocal=1 # if you want a different default species selection on the Gateway # page, change this default Human to one of the genomes from the # defaultDb table in hgcentral: # hgsql -e "select genome from defaultDb;" hgcentral # If you need a different version of that specific genome, change # the defaultDb table entry, for example, a different mouse genome