View the original community article here
Last tested: Jan 22, 2019
If All Results is unavailable for a query, users can still select the Custom Limits option with a limit of up to 100,000 rows. If you know that your instance has been provisioned to be able to export more than 100,000 rows of unstreamed results, you can further increase that limit with the
--max-unstreamed-limit startup option.
The recommended max max unstreamed limit depends on the amount of RAM on the machine. Very roughly speaking, assume you need 16GB for a million rows. (Also roughly assume it's linear, thus 8GB for 500K, 32GB for 2 million rows)