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

Testing for max_query_time

        Details

        • Type: Technical task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.1.1
        • Fix Version/s: 10.1
        • Component/s: None
        • Labels:
          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

            Gliffy Diagrams

              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.
                • Open

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

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

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      elenst Elena Stepanova
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 7 hours, 40 minutes
                        7h 40m