Amazon Aurora DSQL is provided as a Preview service.
To learn more, see Betas and Previews
The following sections describe the cluster quotas and database limits relevant to Aurora DSQL.
Cluster quotas
Your AWS account has the following cluster quotas in Aurora DSQL. To request an increase to the service quotas for single-Region and multi-Region clusters within a specific AWS Region, use the Service Quotas
| Description | Default Limit | Configurable? | Aurora DSQL error code | Error message |
|---|---|---|---|---|
|
Maximum single-Region clusters per AWS account. |
20 |
Yes |
N/A |
You have reached the cluster limit. |
|
Maximum multi-Region clusters per AWS account. |
5 |
Yes |
N/A |
N/A |
|
Maximum storage GB per cluster. |
100GB |
Yes |
DISK_FULL(53100) |
Current cluster size exceeds cluster size limit. |
|
Maximum connections per cluster. |
1000 |
Yes |
TOO_MANY_CONNECTIONS(53300) |
Unable to accept connection, too many open connections. |
|
Maximum connection rate per cluster. |
(10, 100) |
Yes |
CONFIGURED_LIMIT_EXCEEDED(53400) |
Unable to accept connection, rate exceeded. |
|
Maximum connection duration |
60 minutes |
No |
N/A |
N/A |
Database limits in Aurora DSQL
The following table describes all database limits in Aurora DSQL.
| Description | Default Limit | Configurable? | Aurora DSQL error code | Error message |
|---|---|---|---|---|
|
Maximum combined size of the columns used in a primary key |
1 Kibibyte |
No |
54000 |
ERROR: key size too large |
|
Maximum combined size of the columns in a secondary index |
1 Kibibyte |
No |
54000 |
ERROR: key size too large |
|
Maximum size of a row in a table |
2 Mebibytes |
No |
54000 |
ERROR: maximum row size exceeded |
|
Maximum size of a column used in a primary key or secondary index |
255 Bytes |
No |
54000 |
ERROR: maximum key column size exceeded |
|
Maximum size of a column that is not part of an index |
1 Mebibyte |
No |
54000 |
ERROR: maximum column size exceeded |
|
Maximum number of columns that can be used by included in a primary key or a secondary index |
8 Column Keys per Primary Key or Index |
No |
54011 |
ERROR: more than 8 column keys in an index are not supported |
|
Maximum number of columns in a table |
255 Columns per Table |
No |
54011 |
ERROR: tables can have at most 255 columns |
|
Maximum number of indexes that can be created for a single table |
24 |
No |
54000 |
ERROR: more than 24 indexes per table are not allowed |
|
Maximum size of all data modified within a write transaction |
10 MiB Transaction Size |
No |
54000 |
ERROR: transaction size limit 10mb exceeded DETAIL: Current transaction size <sizemb> 10mb |
|
Maximum number of table and index rows that can be mutated in a single transaction block |
10K rows per transaction, modified by number of secondary indexes. For more information, see Unsupported extensions. |
No |
54000 |
ERROR: transaction row limit exceeded |
|
The base maximum amount of memory to be used by a query operation. |
128 MiB per Transaction |
No |
53200 |
ERROR: query requires too much temp space, out of memory. |
|
Maximum number of schemas defined within a database |
10 Schemas |
No |
54000 |
ERROR: more than 10 schemas not allowed |
|
Maximum number of tables that can be created within a database |
1000 Tables |
No |
54000 |
ERROR: creating more than 1000 tables not allowed |
|
Maximum databases per cluster. |
1 |
No |
ERROR: unsupported statement |
|
|
Maximum transaction time |
5 minutes |
No |
54000 |
ERROR: transaction age limit of 300s exceeded |
|
Maximum connection duration |
1 hour |
No |
||
|
Maximum number of views that can be created within a database |
5000 views |
No |
54000 |
ERROR: creating more than 5000 views not allowed |
| Maximum size of the system created rewrite rule entry for storing the view definition | 2 Mebibytes | No | 54000 | ERROR: view definition too large |
For data type limits specific to Aurora DSQL, see Supported data types in Aurora DSQL.
