Aurora MySQL configuration parameters
You manage your Amazon Aurora MySQL DB cluster in the same way that you manage other Amazon RDS DB instances, by using parameters in a DB parameter group. Amazon Aurora differs from other DB engines in that you have a DB cluster that contains multiple DB instances. As a result, some of the parameters that you use to manage your Aurora MySQL DB cluster apply to the entire cluster. Other parameters apply only to a particular DB instance in the DB cluster.
To manage cluster-level parameters, use DB cluster parameter groups. To manage instance-level parameters, use DB parameter groups. Each DB instance in an Aurora MySQL DB cluster is compatible with the MySQL database engine. However, you apply some of the MySQL database engine parameters at the cluster level, and you manage these parameters using DB cluster parameter groups. You can't find cluster-level parameters in the DB parameter group for an instance in an Aurora DB cluster. A list of cluster-level parameters appears later in this topic.
You can manage both cluster-level and instance-level parameters using the AWS Management Console, the AWS CLI, or the Amazon RDS API. You use separate commands for managing cluster-level parameters and instance-level parameters. For example, you can use the modify-db-cluster-parameter-group CLI command to manage cluster-level parameters in a DB cluster parameter group. You can use the modify-db-parameter-group CLI command to manage instance-level parameters in a DB parameter group for a DB instance in a DB cluster.
You can view both cluster-level and instance-level parameters in the console, or by using the CLI or RDS API. For example, you can use the describe-db-cluster-parameters AWS CLI command to view cluster-level parameters in a DB cluster parameter group. You can use the describe-db-parameters CLI command to view instance-level parameters in a DB parameter group for a DB instance in a DB cluster.
Note
Each default parameter group contains the default values for all parameters in the parameter group. If the parameter has "engine default" for this value, see the version-specific MySQL or PostgreSQL documentation for the actual default value.
Unless otherwise noted, parameters listed in the following tables are valid for Aurora MySQL versions 2 and 3.
For more information about DB parameter groups, see Working with parameter groups. For rules and restrictions for Aurora Serverless v1 clusters, see Parameter groups for Aurora Serverless v1.
Topics
Cluster-level parameters
The following table shows all of the parameters that apply to the entire Aurora MySQL DB cluster.
Parameter name | Modifiable | Notes |
---|---|---|
|
Yes |
Only affects clusters that use binary log (binlog) replication. For information about binlog replication, see Replication between Aurora and MySQL or between Aurora and another Aurora DB cluster (binary log replication). Removed from Aurora MySQL version 3. |
|
Yes |
Only affects clusters that use binary log (binlog) replication. For information about binlog replication, see Replication between Aurora and MySQL or between Aurora and another Aurora DB cluster (binary log replication). |
|
Yes |
Only affects clusters that use binary log (binlog) replication. For information about binlog replication, see Replication between Aurora and MySQL or between Aurora and another Aurora DB cluster (binary log replication). Removed from Aurora MySQL version 3. |
|
Yes |
Set this parameter to |
|
Yes |
For more information, see Performance considerations for Amazon Aurora MySQL replication. Doesn't apply to clusters that are part of an Aurora global database. Removed from Aurora MySQL version 3. |
|
Yes |
For more information, see Performance considerations for Amazon Aurora MySQL replication. Doesn't apply to clusters that are part of an Aurora global database. Removed from Aurora MySQL version 3. |
|
Yes |
This setting is available in Aurora MySQL version 3, but it isn't used. |
|
Yes |
This setting is turned on by default in Aurora MySQL 2.10 and higher. For more information, see Zero-downtime restart (ZDR) for Amazon Aurora MySQL. |
|
Yes |
Set the value of this parameter to 1 to turn on the enhanced binlog in Aurora MySQL version 3.03.1 and higher. For more information, see Setting up enhanced binlog. |
|
Yes |
For more information, see Loading data into an Amazon Aurora MySQL DB cluster from
text files in an Amazon S3 bucket. Currently not available in Aurora MySQL version
3. Use |
|
Yes |
This setting is turned on by default in Aurora MySQL 2.11 and higher. Use this setting to mask Aurora MySQL password hashes in the slow query and audit logs. The
allowed values are |
|
Yes |
For more information, see Saving data from an Amazon Aurora MySQL DB cluster into text files in an Amazon S3
bucket. Currently not available in Aurora MySQL version
3. Use |
|
Yes |
Controls case-insensitive username comparison for the This parameter is available in Aurora MySQL version 3.03 and higher. |
|
Yes |
|
|
Yes |
|
|
Yes |
For more information, see Invoking a Lambda function from an Amazon Aurora MySQL DB cluster. |
|
Yes |
Used when invoking the In Aurora MySQL version 2, the IAM role specified in
this parameter is used if an IAM role isn't specified for
In Aurora MySQL version 3, the IAM role specified for this parameter is always used. For more information, see Associating an IAM role with an Amazon Aurora MySQL DB cluster. |
|
Yes |
Set the value of this parameter to 0 to turn on the enhanced binlog in Aurora MySQL version 3.03.1 and higher. You can turn off this parameter only when you use enhanced binlog. For more information, see Setting up enhanced binlog. |
|
Yes |
The AWS CLI and RDS API report a value of |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
For more information, see Replication between Aurora and MySQL or between Aurora and another Aurora DB cluster (binary log replication). |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
Set the value of this parameter to 0 to turn on the enhanced binlog in Aurora MySQL version 3.03.1 and higher. You can turn off this parameter only when you use enhanced binlog. For more information, see Setting up enhanced binlog. |
|
No |
|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter sets an upper limit on the number of row hashes that are kept in memory and used for looking up the transaction that last modified a given row. After this number of hashes has been reached, the history is purged. This parameter applies to Aurora MySQL version 2.12 and higher, and version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
No |
Aurora MySQL clusters use the InnoDB storage engine for all of your data. |
|
Sometimes |
Modifiable in Aurora MySQL version 2 and higher. |
|
Yes |
Indicates the status of the Event Scheduler. Modifiable only at the cluster level in Aurora MySQL version 3. |
|
Sometimes |
Modifiable in Aurora MySQL version 2 and higher. |
|
Yes |
The number of seconds after which the MySQL database server fetches data from the storage engine and
replaces the data in the cache. The allowed values are
This parameter applies to Aurora MySQL version 3. |
|
Yes |
The command to be run by the server for each client that connects. Use double quotes (") for settings to avoid connection failures, for example:
In Aurora MySQL version 3, this parameter doesn't apply for users who have the
|
|
Yes |
You can modify this parameter at the DB cluster level in Aurora MySQL versions 2 and 3. The Adaptive Hash Index isn't supported on reader DB instances. |
|
Yes |
Controls whether the
For more information, see Column Operations This parameter applies to Aurora MySQL version 3.05 and higher. |
|
Yes |
|
|
No |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
Yes |
This option is used to disable deadlock detection in Aurora MySQL version 2.11 and higher and version 3. On high-concurrency systems, deadlock detection can cause a slowdown when numerous threads wait for the same lock. Consult the MySQL documentation for more information on this parameter. |
|
Yes |
This parameter defines the default row format for InnoDB tables (including user-created InnoDB temporary tables). It applies to Aurora MySQL versions 2 and 3. Its value can be |
|
Yes |
This parameter affects how table storage is organized. For more information, see Storage scaling. |
|
Yes |
We highly recommend that you use the default value of In Aurora MySQL version 3, before you can set this parameter to a value other than For more information, see Configuring how frequently the log buffer is flushed. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
No |
|
|
Yes |
When turned on, records information about all InnoDB deadlocks in the Aurora MySQL error log. For more information, see Minimizing and troubleshooting Aurora MySQL deadlocks. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
When this parameter is enabled, InnoDB includes delete-marked records when calculating persistent optimizer statistics. This parameter applies to Aurora MySQL version 2.12 and higher, and version 3. |
|
Yes |
|
|
Yes |
In Aurora MySQL version 3, set the value of this parameter to The default value of For more information, see Configuring how frequently the log buffer is flushed. |
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
Yes |
Controls which in-memory storage engine is used for internal temporary tables. Allowed values are
This parameter applies to Aurora MySQL version 2. |
|
Yes |
Controls which in-memory storage engine is used for internal temporary tables. Allowed values are
This parameter applies to Aurora MySQL version 3. |
|
Yes |
Key cache for MyISAM tables. For more information, see keycache->cache_lock mutex. |
|
Yes |
|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes (Aurora MySQL version 2) Only at cluster creation time (Aurora MySQL version 3) |
In Aurora MySQL version 2.10 and higher 2.x versions, make sure to reboot all reader instances after changing this setting and rebooting the writer instance. For details, see Rebooting an Aurora cluster with read availability. In Aurora MySQL version 3, the value of this parameter is set permanently at the time the cluster is created. If you use a nondefault value for this option, set up your Aurora MySQL version 3 custom parameter group before upgrading, and specify the parameter group during the snapshot restore operation that creates the version 3 cluster. With an Aurora global database based on Aurora MySQL, you can't perform an in-place upgrade from
Aurora MySQL version 2 to version 3 if the |
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
Aurora MySQL version 2. Use |
|
Yes |
Sets the maximum number of threads to handle This parameter applies to Aurora MySQL version 3. |
|
Yes |
The maximum number of error, warning, and note messages to be stored for display. This parameter applies to Aurora MySQL version 3. |
|
Yes |
The timeout for running For more information, see max_execution_time |
|
Yes |
Use this parameter to prevent queries that examine fewer than the specified number of rows from being logged. This parameter applies to Aurora MySQL version 3. |
|
No |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
The size of the buffer that's allocated when preloading indexes. This parameter applies to Aurora MySQL version 3. |
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
When this parameter is turned on, the server permits no updates except from those performed by replica threads. In Aurora MySQL version 3, this parameter doesn't apply for users who have the
|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter enables parallel execution on the replica of all uncommitted threads already in the prepare phase, without violating consistency. It applies to Aurora MySQL version 3. In Aurora MySQL version 3.03.* and lower, the default value is DATABASE. In Aurora MySQL version 3.04 and higher, the default value is LOGICAL_CLOCK. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter determines the type conversions used on replicas. The allowed values are:
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 2 and 3. For more information, see Using TLS with Aurora MySQL DB clusters. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
For instructions on uploading the logs to Amazon CloudWatch Logs, see Publishing Amazon Aurora MySQL logs to Amazon CloudWatch Logs. |
|
Yes |
You can publish audit logs to CloudWatch Logs by enabling Advanced Auditing and setting this parameter to
For more information, see Publishing Amazon Aurora MySQL logs to Amazon CloudWatch Logs. |
|
No |
|
|
Yes |
|
|
No |
|
|
Yes |
Only applies to Aurora MySQL version 2 clusters, with MySQL 5.7 compatibility. |
|
Yes |
Aurora MySQL version 3 |
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes | The number of threads to be cached. This parameter applies to Aurora MySQL versions 2 and 3. |
|
Yes |
|
|
Yes |
For more information, see TLS versions for Aurora MySQL. |
Instance-level parameters
The following table shows all of the parameters that apply to a specific DB instance in an Aurora MySQL DB cluster.
Parameter name | Modifiable | Notes |
---|---|---|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
No |
|
|
Yes |
Set this parameter to |
|
Yes |
For more information, see Amazon Aurora MySQL lab mode. Removed from Aurora MySQL version 3. |
|
Yes |
This parameter is supported for Aurora MySQL versions 2 and 3. For more information, see Amazon Aurora MySQL out-of-memory issues. |
|
Yes |
Set to |
|
Yes |
Set to |
|
Yes |
Enables |
|
Yes |
Determines whether the For more information, see Limiting the size of internal, in-memory temporary tables. |
|
Yes |
When this parameter is enabled, Aurora MySQL uses optimized vector processing instructions provided by modern CPUs to improve performance on I/O-intensive workloads. This setting is enabled by default in Aurora MySQL version 3.05 and higher. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
No |
This parameter applies to Aurora MySQL version 3. |
|
No |
|
|
Yes |
The default storage engine for temporary tables. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Sometimes |
Indicates the status of the Event Scheduler. Modifiable only at the cluster level in Aurora MySQL version 3. |
|
Yes |
|
|
No |
|
|
Yes |
|
|
No |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
For instructions on uploading the logs to CloudWatch Logs, see Publishing Amazon Aurora MySQL logs to Amazon CloudWatch Logs. |
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
Yes |
|
|
Yes |
|
|
Yes |
The command to be run by the server for each client that connects. Use double quotes (") for settings to avoid connection failures, for example:
In Aurora MySQL version 3, this parameter doesn't apply for
users who have the |
|
Yes |
You can modify this parameter at the DB instance level in Aurora MySQL version 2. It's modifiable only at the DB cluster level in Aurora MySQL version 3. The Adaptive Hash Index isn't supported on reader DB instances. |
|
Yes |
Modifying this parameter has no effect because
|
|
Yes |
In some cases where persisted statistics aren't available, you can use this parameter to improve the performance of row count estimations on partitioned tables. You can set it to a value from 0–8192, where the value determines the number of partitions to check during row count estimation. The default value is 0, which estimates using all of the partitions, consistent with default MySQL behavior. This parameter is available for Aurora MySQL version 3.03.1 and higher. |
|
Yes |
|
|
No |
|
|
No |
|
|
No |
|
|
No |
|
|
No |
|
|
No |
|
|
Yes |
The default value is represented by a formula. For details about how the
|
|
No |
Aurora MySQL doesn't use the InnoDB change buffer at all. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
Modifying this parameter has no effect, because |
|
Yes |
This option is used to disable deadlock detection in Aurora MySQL version 2.11 and higher and version 3. On high-concurrency systems, deadlock detection can cause a slowdown when numerous threads wait for the same lock. Consult the MySQL documentation for more information on this parameter. |
|
Yes |
Removed from Aurora MySQL version 3. |
|
No |
|
|
No |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
No |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
When turned on, records information about all InnoDB deadlocks in the Aurora MySQL error log. For more information, see Minimizing and troubleshooting Aurora MySQL deadlocks. |
|
Yes |
|
|
Yes |
|
|
No |
|
|
No |
Aurora MySQL manages the read-only and read/write state of DB instances based on the type of cluster. For example, a provisioned cluster has one read/write DB instance (the primary instance) and any other instances in the cluster are read-only (the Aurora Replicas). |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
No |
|
|
Yes |
Modifying this parameter has no effect because
|
|
Yes |
Aurora evaluates the minimum value of |
|
Yes |
Controls which in-memory storage engine is used for internal temporary tables. Allowed values are
This parameter applies to Aurora MySQL version 2. |
|
Yes |
Controls which in-memory storage engine is used for internal temporary tables. Allowed values are
This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
Key cache for MyISAM tables. For more information, see keycache->cache_lock mutex. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
No |
Setting |
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
No |
|
|
Yes |
|
|
Yes |
|
|
No |
Aurora MySQL version 2. Use |
|
No |
Aurora MySQL version 3 |
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
No |
|
|
Yes |
|
|
Yes |
|
|
Yes |
The default value is represented by a formula. For details about how the
|
|
Yes |
Sets the maximum number of threads to handle This parameter applies to Aurora MySQL version 3. |
|
Yes |
The maximum number of error, warning, and note messages to be stored for display. This parameter applies to Aurora MySQL version 3. |
|
Yes |
The timeout for running For more information, see max_execution_time |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
Use this parameter to prevent queries that examine fewer than the specified number of rows from being logged. This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
For information about Aurora MySQL features that use this switch, see Best practices with Amazon Aurora MySQL. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
This parameter determines which SHOW PROCESSLIST implementation to use:
This parameter applies to Aurora MySQL version 2.12 and higher, and version 3. |
|
Yes |
|
|
No |
|
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
No |
Aurora MySQL manages the connection properties and enforces consistent settings for all DB instances in a cluster. |
|
Yes |
The size of the buffer that's allocated when preloading indexes. This parameter applies to Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
The default value is represented by a formula. For details about how the
Removed from Aurora MySQL version 3. |
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
When this parameter is turned on, the server permits no updates except from those performed by replica threads. We recommend that you use the DB cluster parameter group in Aurora MySQL version 2 to make sure that the
NoteReader instances are always read only, because Aurora MySQL sets Removed at the instance level from Aurora MySQL version 3. |
|
Yes |
|
|
No |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
No |
|
|
Yes |
Aurora MySQL version 3 |
|
Yes |
Aurora MySQL version 3 |
|
Yes |
Aurora MySQL version 3 |
|
Yes |
Aurora MySQL version 3 |
|
Yes |
Aurora MySQL version 3 |
|
Yes |
Aurora MySQL version 3 |
|
Yes |
|
|
Yes |
This parameter is always turned on in Aurora MySQL version 2. Trying to turn it off generates an error. Removed from Aurora MySQL version 3. |
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
Yes |
Enabling this variable causes SHOW_CREATE_TABLE This parameter applies to Aurora MySQL version 2.12 and higher, and version 3. |
|
No |
|
|
No |
|
|
Yes |
|
|
Yes |
Aurora MySQL version 2. Use |
|
Yes |
Aurora MySQL version 2. Use |
|
Yes |
Aurora MySQL version 2. Use |
|
Yes |
Aurora MySQL version 2. Use |
|
Yes |
Aurora MySQL version 2. Use |
|
Yes |
|
|
Yes |
For instructions on uploading the logs to CloudWatch Logs, see Publishing Amazon Aurora MySQL logs to Amazon CloudWatch Logs. |
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
No |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
Yes |
|
|
No |
|
|
Yes |
|
|
Yes |
This parameter applies to Aurora MySQL version 3. |
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
|
|
Yes |
|
|
No |
|
|
Yes |
The default value is represented by a formula. For details about how the
|
|
Yes |
The default value is represented by a formula. For details about how the
|
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. For details, see New temporary table behavior in Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. For details, see New temporary table behavior in Aurora MySQL version 3. |
|
Yes |
This parameter applies to Aurora MySQL version 3. For details, see New temporary table behavior in Aurora MySQL version 3. |
|
Yes | The number of threads to be cached. This parameter applies to Aurora MySQL versions 2 and 3. |
|
No |
|
|
Yes |
|
|
Yes |
|
|
Yes |
Defines the maximum size of internal in-memory temporary tables created by the In Aurora MySQL version 3.04 and higher, defines the maximum size of internal in-memory temporary tables
created by the For more information, see Limiting the size of internal, in-memory temporary tables. |
|
No |
Aurora MySQL uses managed instances where you don't access the file system directly. |
|
Yes |
|
|
Yes |
This parameter applies to Aurora MySQL version 3. It replaces |
|
Yes |
|
|
Yes |
Removed from Aurora MySQL version 3. It is replaced by |
|
Yes |
|
|
No |
|
|
No |
|
|
No |
|
|
No |
|
|
No |
|
|
No |
|
|
No |
|
|
Yes |
Aurora evaluates the minimum value of |
MySQL parameters that don't apply to Aurora MySQL
Because of architectural differences between Aurora MySQL and MySQL, some MySQL parameters don't apply to Aurora MySQL.
The following MySQL parameters don't apply to Aurora MySQL. This list isn't exhaustive.
-
activate_all_roles_on_login
– This parameter doesn't apply to Aurora MySQL version 2. It is available in Aurora MySQL version 3. -
big_tables
-
bind_address
-
character_sets_dir
-
innodb_adaptive_flushing
-
innodb_adaptive_flushing_lwm
-
innodb_buffer_pool_chunk_size
-
innodb_buffer_pool_instances
-
innodb_change_buffering
-
innodb_checksum_algorithm
-
innodb_data_file_path
-
innodb_dedicated_server
-
innodb_doublewrite
-
innodb_flush_log_at_timeout
– This parameter doesn't apply to Aurora MySQL. For more information, see Configuring how frequently the log buffer is flushed. -
innodb_flush_method
-
innodb_flush_neighbors
-
innodb_io_capacity
-
innodb_io_capacity_max
-
innodb_log_buffer_size
-
innodb_log_file_size
-
innodb_log_files_in_group
-
innodb_log_spin_cpu_abs_lwm
-
innodb_log_spin_cpu_pct_hwm
-
innodb_log_writer_threads
-
innodb_max_dirty_pages_pct
-
innodb_numa_interleave
-
innodb_page_size
-
innodb_redo_log_capacity
-
innodb_redo_log_encrypt
-
innodb_undo_log_encrypt
-
innodb_undo_log_truncate
-
innodb_undo_logs
-
innodb_undo_tablespaces
-
innodb_use_native_aio
-
innodb_write_io_threads
Aurora MySQL global status variables
You can find the current values for Aurora MySQL global status variables by using a statement such as the following:
show global status like '%aurora%';
The following table describes the global status variables that Aurora MySQL uses.
Name | Description |
---|---|
|
The total number of commits since the last restart. |
|
The aggregate commit latency since the last restart. |
|
The aggregate DDL latency since the last restart. |
|
The aggregate |
|
The aggregate |
|
The aggregate |
|
The aggregate |
|
The number of bytes allocated to the binlog I/O cache. |
|
The number of read requests made to the binlog I/O cache. |
|
The number of read requests that were served from the binlog I/O cache. |
|
Indicates whether enhanced binlog is enabled or disabled for this DB instance. For more information, see Setting up enhanced binlog. |
|
The number of database connections to the DB instance, excluding RDS service connections used for database health checks. |
|
A counter that's incremented when the cached cursor is successfully retrieved and verified. For more information on the fast insert cache, see Amazon Aurora MySQL performance enhancements. |
|
A counter that's incremented when the cached cursor is no longer valid and Aurora performs a normal index traversal. For more information on the fast insert cache, see Amazon Aurora MySQL performance enhancements. |
|
The total number of DML statements forwarded to this writer DB instance. This variable applies to Aurora MySQL version 2. |
|
The total duration of DML statements forwarded to this writer DB instance. This variable applies to Aurora MySQL version 2. |
|
The number of times a forwarded connection failed to be established on the writer. |
|
The number of forwarded queries that get rejected due to |
|
The number of times a forwarding session is ended due to a timeout on the writer. |
|
The number of forwarded sessions on the writer DB instance. This variable applies to Aurora MySQL version 2. |
|
The total number of |
|
The total duration of |
|
The total number of DML statements forwarded to this writer DB instance. This variable applies to Aurora MySQL version 3. |
|
The total duration of DML statements forwarded to this writer DB instance. This variable applies to Aurora MySQL version 3. |
|
The number of times a forwarded connection failed to be established on the writer. |
|
The number of forwarded queries that get rejected due to |
|
The number of times a forwarding session is ended due to a timeout on the writer. |
|
The number of forwarded sessions on the writer DB instance. This variable applies to Aurora MySQL version 3. |
|
The total number of |
|
The total duration of |
|
The amount of memory in bytes that the Aurora MySQL lock manager is using. |
|
The aggregate request count that Aurora MySQLmakes to the Aurora machine learning services across all queries run by users of the DB instance. For more information, see Using Amazon Aurora machine learning with Aurora MySQL. |
|
The aggregate response count that Aurora MySQL receives from the Aurora machine learning services across all queries run by users of the DB instance. For more information, see Using Amazon Aurora machine learning with Aurora MySQL. |
|
The aggregate internal cache hit count that Aurora MySQL receives from the Aurora machine learning services across all queries run by users of the DB instance. For more information, see Using Amazon Aurora machine learning with Aurora MySQL. |
|
The number of logical requests that the DB instance has evaluated to be sent to the Aurora machine learning services
since the last status reset. Depending on whether batching has been used, this value can be higher than
|
|
The aggregate response count that Aurora MySQL receives from the Aurora machine learning services across all queries run by users of the DB instance. For more information, see Using Amazon Aurora machine learning with Aurora MySQL. |
|
The number of retried requests that the DB instance has sent to the Aurora machine learning services since the last status reset. For more information, see Using Amazon Aurora machine learning with Aurora MySQL. |
|
The aggregate count of Aurora machine learning functions that are evaluated by non-batch mode across all queries run by users of the DB instance. For more information, see Using Amazon Aurora machine learning with Aurora MySQL. |
|
The number of bytes for the tuple data structures transmitted to the head node during parallel
queries. Divide by 16,384 to compare against |
|
The maximum number of parallel query sessions that can run concurrently on this Aurora DB instance. This is a fixed number that depends on the AWS DB instance class. |
|
The number of data pages (each with a fixed size of 16 KiB) where parallel query avoided a network transmission to the head node. |
|
The number of parallel query sessions requested. This value might represent more than one session per query, depending on SQL constructs such as subqueries and joins. |
|
The number of parallel query sessions run successfully. |
|
The number of parallel query sessions that returned an error to the client. In some cases, a request for a parallel query might fail, for example due to a problem in the storage layer. In these cases, the query part that failed is retried using the nonparallel query mechanism. If the retried query also fails, an error is returned to the client and this counter is incremented. |
|
The number of parallel query sessions currently in progress. This number applies to the particular
Aurora DB instance that you are connected to, not the entire Aurora DB cluster. To see if a DB instance
is close to its concurrency limit, compare this value to
|
|
The number of times parallel query wasn't chosen to satisfy a query. This value is the sum of several other more
granular counters. An |
|
The number of times parallel query wasn't chosen due to the number of rows in the table. An |
|
The number of parallel query requests that use the nonparallel query processing path because of an unsupported data type in the list of projected columns. |
|
The number of parallel query requests that use the nonparallel query processing path because the table
has columns with the |
|
The number of parallel query requests that use the nonparallel query processing path because the table
has columns with a |
|
The number of parallel query requests that use the nonparallel query processing path because the table contains a virtual column. |
|
The number of parallel query requests that use the nonparallel query processing path because the table has columns with a custom character set. |
|
The number of parallel query requests that use the nonparallel query processing path because the table
is currently being altered by a fast DDL |
|
The number of times parallel query wasn't chosen, even though less than 95 percent of the table data was in the buffer pool, because there wasn't enough unbuffered table data to make parallel query worthwhile. |
|
The number of parallel query requests that use the nonparallel query processing path because the table has full-text indexes. |
|
The number of times parallel query wasn't chosen because a high percentage of the table data
(currently, greater than 95 percent) was already in the buffer pool. In these cases, the optimizer
determines that reading the data from the buffer pool is more efficient. An |
|
The number of parallel query requests that use the nonparallel query processing path because the query includes an index hint. |
|
The number of parallel query requests that use the nonparallel query processing path because the table
uses an unsupported InnoDB row format. Aurora parallel query only applies to the |
|
The number of parallel query requests that used the nonparallel query processing path, due to the
query being started inside a long-running transaction. An |
|
The number of parallel query requests that use the nonparallel query processing path because the query
doesn't include any |
|
The number of parallel query requests that use the nonparallel query processing path because the query uses a range scan on an index. |
|
The number of parallel query requests that use the nonparallel query processing path because the total combined length of all the columns is too long. |
|
The number of times parallel query wasn't chosen due to the overall size of the table, as determined by number of
rows and average row length. An |
|
The number of parallel query requests that use the nonparallel query processing path because the query
refers to temporary tables that use the unsupported |
|
The number of parallel query requests that use the nonparallel query processing path because query
uses an unsupported transaction isolation level. On reader DB instances, parallel query only applies to
the |
|
The number of parallel query requests that use the nonparallel query processing path because the query
is part of an |
|
The number of parallel query requests that use the nonparallel query processing path because the
|
|
The number of parallel query requests that use the nonparallel query processing path because the Aurora MySQL DB cluster isn't using a supported Aurora cluster storage configuration. For more information, see Limitations. This parameter applies to Aurora MySQL version 3.04 and higher. |
|
The number of times parallel query wasn't chosen due to the maximum number of concurrent parallel queries already running on a particular Aurora DB instance. |
|
Number of bytes replicated to an Aurora MySQL reader database instance since the last restart. For more information, see Replication with Amazon Aurora MySQL. |
|
The number of times since the last restart that the engine has exceeded reserved memory limits. If
|
|
The current number of threads in the Aurora thread pool. For more information on the thread pool in Aurora MySQL, see Thread pool. |
|
Denotes the current version of the time zone information used by the DB cluster. The values follow the
Internet Assigned Numbers Authority (IANA) format: This parameter applies to Aurora MySQL version 2.12 and higher, and version 3.04 and higher. |
|
Indicates whether Database Activity Streams (DAS) are enabled or disabled on this DB instance. For more information, see Monitoring Amazon Aurora with Database Activity Streams. |
MySQL status variables that don't apply to Aurora MySQL
Because of architectural differences between Aurora MySQL and MySQL, some MySQL status variables don't apply to Aurora MySQL.
The following MySQL status variables don't apply to Aurora MySQL. This list isn't exhaustive.
-
innodb_buffer_pool_bytes_dirty
-
innodb_buffer_pool_pages_dirty
-
innodb_buffer_pool_pages_flushed
Aurora MySQL version 3 removes the following status variables that were in Aurora MySQL version 2:
-
AuroraDb_lockmgr_bitmaps0_in_use
-
AuroraDb_lockmgr_bitmaps1_in_use
-
AuroraDb_lockmgr_bitmaps_mem_used
-
AuroraDb_thread_deadlocks
-
available_alter_table_log_entries
-
Aurora_lockmgr_memory_used
-
Aurora_missing_history_on_replica_incidents
-
Aurora_new_lock_manager_lock_release_cnt
-
Aurora_new_lock_manager_lock_release_total_duration_micro
-
Aurora_new_lock_manager_lock_timeout_cnt
-
Aurora_total_op_memory
-
Aurora_total_op_temp_space
-
Aurora_used_alter_table_log_entries
-
Aurora_using_new_lock_manager
-
Aurora_volume_bytes_allocated
-
Aurora_volume_bytes_left_extent
-
Aurora_volume_bytes_left_total
-
Com_alter_db_upgrade
-
Compression
-
External_threads_connected
-
Innodb_available_undo_logs
-
Last_query_cost
-
Last_query_partial_plans
-
Slave_heartbeat_period
-
Slave_last_heartbeat
-
Slave_received_heartbeats
-
Slave_retried_transactions
-
Slave_running
-
Time_since_zero_connections
These MySQL status variables are available in Aurora MySQL version 2, but they aren't available in Aurora MySQL version 3:
-
Innodb_redo_log_enabled
-
Innodb_undo_tablespaces_total
-
Innodb_undo_tablespaces_implicit
-
Innodb_undo_tablespaces_explicit
-
Innodb_undo_tablespaces_active