This cursor value (read/write) sets if the entire result-set of a SELECT or
SHOW is immediately read into memory. Default: 0 (unbuffered).
See also: MariaDB Connector/Python 1.0
Override the buffering and output its state:
import mariadb conn = mariadb.connect( host = 'localhost', user = 'root', password = 'secret', ) cursor = conn.cursor(buffered = True) print(cursor.buffered) # Prints: 1 cursor.buffered = False print(cursor.buffered) # Prints: 0