Chapter 11 Configuration

Table of Contents

11.1 User-Settable Session Variables

11.2 Global System Variables

11.3 Shape-Dependent Global System Variables

A DB System's configuration comprises session variables and global system variables, which define its operation. MySQL HeatWave on AWS permits configuring session variables, which affect the current session only. Global system variables are either static or managed by the DB System and cannot be modified.

Some global system variables are tuned for a specific MySQL shape. A shape is a resource template that defines the resources available to your MySQL instance. For information about shapes, see Supported Shapes.

DB System variables are categorized as follows:

• User-settable session variables: Variables that can be modified for the current session only. See Section 11.1, “User-Settable Session Variables”.

• Global System Variables: Global system variables with values that are either static or managed by the DB System and cannot be modified. See Section 11.2, “Global System Variables”.

• Shape-Dependent Global System Variables: Global system variables that are tuned for a specific MySQL shape. Shape-dependent global system variables cannot be modified. See Section 11.3, “Shape-Dependent Global System Variables”.