Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-22071

Use MySQL transaction isolation level per session

    XMLWordPrintable

Details

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      We should switch confluence to using per-session level transaction isolation, rather than relying on customers modifying the global setting.

      Some customers can't (or are unwilling to) change the default settings for isolation globally for their MySQL. We need to provide a better solution for these customers, and to reduce the configuration effort for all customers. Using per session isolation settings (via hibernate.connection.isolation=2, see http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html#configuration-optional and http://download.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Connection.TRANSACTION_READ_COMMITTED) would fit the bill nicely.

      Attachments

        Issue Links

          Activity

            People

              akdominguez Katrina Walser (Inactive)
              richatkins Richard Atkins
              Votes:
              28 Vote for this issue
              Watchers:
              25 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: