Understanding MaxScale's Max Rows Filter

MaxScale's Max Rows Filter (maxrows) limits the number of rows that SELECT statements, prepared statements, and stored procedures can return.

When to Use the Max Rows Filter?

The Max Rows Filter (maxrows) allows you to:

  • Configure the maximum result size

  • Replace larger result-sets are replaced with an empty result-set

Next steps: