Per-query variable statement

Percona Server has implemented per-query variable statement support in 5.6.14-62.0. This feature provides the ability to set variable values only for a certain query, after execution of which the previous values will be restored. Per-query variable values can be set up with the following command:

mysql> SET STATEMENT <variable=value> FOR <statement>;

Examples

If we want to increase the sort_buffer_size value just for one specific sort query we can do it like this:

mysql> SET STATEMENT sort_buffer_size=100000 FOR SELECT name FROM name ORDER BY name;

This feature can also be used with Statement Timeout to limit the execution time for a specific query:

mysql> SET STATEMENT max_statement_time=1000 FOR SELECT name FROM name ORDER BY name;

We can provide more than one variable we want to set up:

mysql> SET STATEMENT sort_buffer_size=100000, max_statement_time=1000 FOR SELECT name FROM name ORDER BY name;

Version Specific Information

Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Extended SELECT INTO OUTFILE/DUMPFILE

Next topic

Extended mysqlbinlog

This Page



© Copyright Percona LLC and/or its affiliates 2009-2014.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>