Amazon Aurora MySQL Lab Mode

Aurora lab mode is used to enable Aurora features that are available in the current
Aurora database version, but are not enabled by default. While Aurora lab mode features
are not recommended for use in production DB clusters, you can use Aurora lab mode
to
enable these features for DB clusters in your development and test environments. For
more information about Aurora features available when Aurora lab mode is enabled,
see
Aurora Lab Mode Features.

The aurora_lab_mode parameter is an instance-level parameter that is in the
default parameter group. The parameter is set to 0
(disabled) in the default parameter group. To enable Aurora lab mode, create a custom
parameter
group, set the aurora_lab_mode parameter to 1 (enabled) in the custom
parameter group, and modify your primary instance or Aurora Replica to use the custom
parameter
group. For information on modifying a DB parameter group, see Modifying Parameters in a DB Parameter Group. For information on
parameter groups and Amazon Aurora, see Amazon Aurora MySQL
Parameters.

Aurora Lab Mode Features

The following table lists the Aurora features currently available when Aurora lab
mode
is enabled. You must enable Aurora lab mode before any of these features can be used.
For
more information about Aurora lab mode, see Amazon Aurora MySQL Lab Mode.

This feature can improve query performance when you need to join a large amount of
data by using an equijoin. For more information about using this feature, see Working with Hash Joins in Aurora MySQL.

Fast DDL

This feature allows you to execute an ALTER TABLE
tbl_name ADD COLUMN
col_namecolumn_definition operation nearly
instantaneously. The operation completes without requiring the table
to be copied and without materially impacting other DML statements.
Since it does not consume temporary storage for a table copy, it
makes DDL statements practical even for large tables on small
instance types. Fast DDL is currently only supported for adding a
nullable column, without a default value, at the end of a table.
For more information about using this feature, see Altering Tables in Amazon Aurora Using Fast
DDL.

Hot Row Contention

This feature substantially improves throughput for workloads with
many transactions contending for rows on the same page. The improvement
involves changing the lock release algorithm used by Aurora.

Javascript is disabled or is unavailable in your browser.

To use the AWS Documentation, Javascript must be enabled. Please refer to your browser's
Help pages for instructions.