Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2583

Make optimistic_trx=true work for SELECTs after set autocommit=0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3
    • Fix Version/s: 2.5.0
    • Component/s: readwritesplit
    • Labels:
      None

      Description

      It seems optimistic_trx works only for transactions explicitly started with BEGIN ... or START TRANSACTION.

      It would be great to add read scaling support for sets of SELECTs executed after set autocommit=0;

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: