Set [no]maxrow Option
The set maxrow statement restricts the estimated number of rows that can be returned by one query. Value must not exceed query_row_limit. If you issue a set nomaxrow statement, the allowed number of rows is set to query_row_limit.