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 one or more DB instances in your Aurora cluster to use the custom parameter
group. Then connect to the appropriate instance endpoint to try the lab mode features. 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 Aurora MySQL configuration 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.
Feature | Description |
---|---|
Scan Batching |
Aurora MySQL scan batching speeds up in-memory, scan-oriented queries significantly. The feature boosts the performance of table full scans, index full scans, and index range scans by batch processing. |
Hash Joins |
This feature can improve query performance when you need to join a large amount of data by using an equijoin. You can use this feature without lab mode in Aurora MySQL version 2. For more information about using this feature, see Optimizing large Aurora MySQL join queries with hash joins. |
Fast DDL |
This feature allows you to run an
|