Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6958 10.1 testing
  3. MDEV-6963

Testing for max_query_time

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Done
    • 10.1.1
    • N/A
    • Tests
    • None

    Description

      Development task: MDEV-4427
      Git commit: https://github.com/MariaDB/server/commit/cc8aed3

      KB: https://kb.askmonty.org/en/how-to-limittimeout-queries/#max_query_time-variable

      Server option: max-statement-time
      System variable: max_statement_time (global, session)
      Status variable: max_statement_time_exceeded

      Field in mysql.user: max_statement_time

      GRANT syntax:

      GRANT USAGE ON *.* TO user1@localhost WITH MAX_STATEMENT_TIME 1.005;

      Related bugs:
      http://bugs.mysql.com/bug.php?id=64556 (supposed to be fixed in maria-5.5-monty revno 3612 (of Jan 04))
      http://bugs.mysql.com/bug.php?id=60682

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4007 max_query_timeout is not shown upon SELECT from mysql.user

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4008 Wrong explanation of max_query_time in mysqld help

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Task - A task that needs to be done. MDEV-4427 query timeouts

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.