Branch: refs/heads/dev Home: https://github.com/galaxyproject/galaxy Commit: b84da7a07a7b53f7770d6dc015ff0829305e3075 https://github.com/galaxyproject/galaxy/commit/b84da7a07a7b53f7770d6dc015ff0... Author: John Chilton <jmchilton@gmail.com> Date: 2018-02-18 (Sun, 18 Feb 2018) Changed paths: M config/galaxy.yml.sample M doc/source/admin/galaxy_options.rst M lib/galaxy/config.py M lib/galaxy/model/mapping.py M lib/galaxy/model/orm/engine_factory.py A lib/galaxy/web/framework/middleware/sqldebug.py M lib/galaxy/webapps/galaxy/buildapp.py M lib/galaxy/webapps/galaxy/config_schema.yml Log Message: ----------- Allow per-request SQL debugging via URL parameter. This has been super helpful in debugging the SQL generated by Galaxy for recent PRs. To use this simply enable the middleware, use your browser's network logger to find the URL of interest, copy the URL into the browser address bar and add ``?debug_sql=1`` to it. You will then see the sql in the logs only for that request and for every statement in that request. Simply turning all logging on results in a deluge of logging I've never been able to grok and that is very hard to ping to particular request. Slow request logging is great but it doesn't make this kind of per-query full profile of the SQL generated as easy as this approach and isn't great at debugging performance problems when the result from a large number of small requests (you'd have to set a very low threshold to make sure you are logging every query and then it is no different from the full log). Commit: 0c7dcc37c96617a6a98d1f061c051bee678e8c67 https://github.com/galaxyproject/galaxy/commit/0c7dcc37c96617a6a98d1f061c051... Author: Martin Cech <marten@bx.psu.edu> Date: 2018-02-19 (Mon, 19 Feb 2018) Changed paths: M config/galaxy.yml.sample M doc/source/admin/galaxy_options.rst M lib/galaxy/config.py M lib/galaxy/model/mapping.py M lib/galaxy/model/orm/engine_factory.py A lib/galaxy/web/framework/middleware/sqldebug.py M lib/galaxy/webapps/galaxy/buildapp.py M lib/galaxy/webapps/galaxy/config_schema.yml Log Message: ----------- Merge pull request #5539 from jmchilton/per_request_sql_debugging Add middleware and instrumentation to allow per-request SQL debugging. Compare: https://github.com/galaxyproject/galaxy/compare/ca7cbaf2bffb...0c7dcc37c966