https://dev.mysql.com/server-system-variables.html
sql_buffer_result Property Value System Variable sql_buffer_result Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Boolean Default Value OFF If enabled, sql_buffer_result forces results from SELECT statements to be put into temporary ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/select.html
SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ... SQL_BUFFER_RESULT forces the result to be put into a ...[into_option] [FROM table_references [PARTITION partition_list]] [WHERE where_condition] [GROUP BY {col_name | expr | position}, ...
https://dev.mysql.com/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/table-locking.html
Using SQL_BUFFER_RESULT with SELECT statements can help to make the duration of table locks shorter. InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without ...
https://dev.mysql.com/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 5.1.9.1, “System Variable Privileges” The following table lists all dynamic system ...
