Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11418

AliSQL: [Feature] Issue#1 KILL IDLE TRANSACTIONS

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: 10.3.0
    • Component/s: OTHER
    • Labels:
      None

      Description

      Description:
      ------------
      Terminate idle transactions safely in server layer by setting up socket timeout parameter. Percona provides another
      patch to resolve similar problem, but it calls server layer's callback in InnoDB plugin to close THD, which crashes in some
      testcases. See https://bugs.launchpad.net/percona-server/+bug/901060 for more detailed information.
        1. export parameter trx_idle_timeout to handle all kinds of transactions, the priority is highest
        2. export parameter trx_readonly_idle_timeout to handle read-only transactions
        3. export parameter trx_changes_idle_timeout to handle read-write transactions
      

      https://github.com/alibaba/AliSQL/commit/68d6a67a7f93e25c9b4e0bc42445878b1433b2a5

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              svoj Sergey Vojtovich
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: