Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4427 query timeouts
  3. MDEV-6848

Like LIMIT ROWS EXAMINED, instead of killing the query, return the results

    Details

    • Type: Technical task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: OTHER
    • Labels:
      None

      Description

      like LIMIT ROWS EXAMINED, we could return if we got a hard timeout, for example:

      SELECT ... LIMIT ROWS EXAMINED rows_limit;

      will return if we examined >= rows_limit rows

      we could create a query like:

      SELECT ... LIMIT TIME EXAMINED seconds;

      it will return if we got >= seconds to examine the table, in this case instead of query timeout killing the query and 'dropping' the connection, we could return what we found without searching tables, only executing the temporary table features with current data, for example...

      select sum(a) from (
      select a from other_table
      )
      limit time examined 10

      after 10 seconds we sum everything we got from "(select a from other_table)"

      in others words we block the storage "other_table" reads and the query continue with the SUM() function, we create a WARNING telling that the query was returned with a timed out condition

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rspadim roberto spadim
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: