How to Emulate --quick and --unbuffered options from MySQL Client

[kolinkorr839]

The MySQL client has the options: --quick and --unbuffered that are extremely useful when pulling large amounts of data. This essentially avoids putting all the results into memory which could cause OOM for the client since it writes the output immediately. Is there an equivalent options for mycli for this?

[rolandwalker]

Hi! Something similar to --quick will be the default after #1450.

Unbuffered queries are supported by the pymysql library we use to connect:

• https://pymysql.readthedocs.io/en/latest/modules/cursors.html#pymysql.cursors.SSCursor

though it's not clear how easy it would be to support this on an optional basis.

[rolandwalker]

--unbuffered was added in https://github.com/dbcli/mycli/releases/tag/v1.46.0 !