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

AliSQL: [Feature] Issue#1 KILL IDLE TRANSACTIONS

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.0
    • OTHER
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13233 Idle transaction timeouts kills connections rather than transactions

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.