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

Docs: KB page suggests wrong syntax for per-query MAX_STATEMENT_TIME

    XMLWordPrintable

Details

    Description

      https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/query-optimizations/aborting-statements-that-exceed-than-a-certain-time-to-execute/

      It says:

      Individual queries can also be limited by adding a MAX_STATEMENT_TIME clause to the query. For example:

      SELECT MAX_STATEMENT_TIME=2 * FROM t1;

      It's not the right syntax, apparently it's supposed to be
      SET STATEMENT MAX_STATEMENT_TIME=2 FOR SELECT * FROM t1

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            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.