GRAILS-11536 set the default flush mode outside of transactions as "manual"
- inside transactions the flush mode is always "auto" (non-configurable)
- read-only transacions have the "manual" flush mode