Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19210

set mysql transaction isolation level to READ_COMMITTED by default

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Medium Medium
    • None
    • 2012.2, 4.7.0-dev
    • Database related
    • None

    Description

      1. it will alleviate bugs such as 17777

      2. it is the default isolation level in oracle anyway. This way we expect the same behaviour from all databases

      3. innodb uses less row locks in such mode (see eg http://insatiabledemand.ideeli.com/post/18850015294/diagnosing-mysql-auto-inc-and-gap-locks)

      Attachments

        Activity

          People

            unknown unknown
            72f8acac-185f-4a54-9470-a7473f50daab@accounts.ibexa.co Gaetano Giunta
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: