content_image/833724.jpg content_image/833726.jpg content_image/833729.jpg
<img src='content_image/833724.jpg'>

If enabled, sql_buffer_result  forces results from SELECT  statements to be put into temporary tables. This helps MySQL free the table locks early and can be beneficial in cases where it takes a long time to send results to the client. The default value is OFF . 

• sql_log_off 

<img src='content_image/833726.jpg'>

This variable controls whether logging to the general query log is disabled for the current session (assuming that the general query log itself is enabled). The default value is OFF  (that is, enable logging). To disable or enable general query logging for the current session, set the session sql_log_off variable to ON  or OFF . 

Setting the session value of this system variable is a restricted operation. The session user must have privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . 

• sql_mode 

<img src='content_image/833729.jpg'>

