Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-930

MaxRows Filter

Details

    • 2016-20, 2016-21

    Description

      The purpose of the filter is to put a hard limit on the maximum number of rows that will be returned to a client.

      Example: With following mask filter, only query result set with 150 or fewer rows will be returned to the client. If the result set is more than 150 rows, 0 rows will be returned to the client.

      [Mask Filter]
      		 
      type=filter
      		 
      module=maskfilter
      		 
      maxrows=150

      Attachments

        Activity

          Massimiliano Pinto Massimiliano Pinto (Inactive) added a comment -

          From user perspective the output will look like this, assiming a 30 rows limitation

          MySQL [(none)]> SELECT * from test.t2 limit 3;
          ------

          id

          ------

          1100
          1100
          1100

          ------
          3 rows in set (0.00 sec)

          MySQL [(none)]> SELECT * from test.t2 limit 32;
          Query OK, 0 rows affected (0.01 sec)

          MySQL [(none)]>

          Massimiliano Pinto Massimiliano Pinto (Inactive) added a comment - From user perspective the output will look like this, assiming a 30 rows limitation MySQL [(none)] > SELECT * from test.t2 limit 3; ------ id ------ 1100 1100 1100 ------ 3 rows in set (0.00 sec) MySQL [(none)] > SELECT * from test.t2 limit 32; Query OK, 0 rows affected (0.01 sec) MySQL [(none)] >

          People

            Massimiliano Pinto Massimiliano Pinto (Inactive)
            johan.wikman Johan Wikman
            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.