--quick (-q)

DETAILS

The --quick command-line option can be used to reduce memory usage for queries that return large result-sets.

By default, when mariadb client retrieves a result-set, it retrieves the entire result-set and buffers it in memory before displaying it. When the --quick command-line option is specified, it retrieves results from the server a row at a time instead, which can reduce memory usage.

EXAMPLES

$ mariadb --host FULLY_QUALIFIED_DOMAIN_NAME --port TCP_PORT \
      --user DATABASE_USER --password \
      --ssl-verify-server-cert \
      --ssl-ca ~/PATH_TO_PEM_FILE \
      --default-character-set=utf8 \
      --batch \
      --skip-column-names \
      --quick \
      --execute='SELECT * FROM accounts.contacts;' \
      > contacts.tsv

$ mariadb --host FULLY_QUALIFIED_DOMAIN_NAME --port TCP_PORT \
      --user DATABASE_USER --password \
      --batch \
      --skip-column-names \
      --quick \
      --execute='SELECT * FROM accounts.contacts;' \
      > contacts.tsv

CHANGE HISTORY