Manual:$wgAPIMaxDBRows

API: $wgAPIMaxDBRows
Maximum number of rows to scan in API database queries.
Introduced in version:1.13.0 (r32466)
Removed in version:still in use
Allowed values:(integer)
Default value:5000

Details edit

Maximum number of rows to scan in API database queries.

The default value is generally fine.