Codevalley
Codevalley

Reputation: 4651

MySQL database limits

We are using a solution with AWS+RDS, and I was wondering what are the absolute Database limits. Limits like

  1. Number of rows in a table.
  2. Number of tables in a database.
  3. Number of databases in an RDS instance.

Upvotes: 2

Views: 3432

Answers (1)

Jacob
Jacob

Reputation: 43319

Number of database instances: 20

Request to Increase Amazon RDS DB Instance Allocation

By default, customers are allowed to have up to a total of 20 Amazon RDS DB instances. Of those 20, up to 10 can be Oracle DB Instances under the "License Included" model. All 20 can be used for MySQL or Oracle under the "BYOL" model.

Size limit per instance is 1 TB.

You can have as many databases as you want on one instance.

Limits on MySQL depend on the storage engine:

  • MyISAM are files, so it depends on how many files are allowed on the filesystem etc
  • InnoDB has a maximum of two billion tables. I guess you run out of your 1 TB diskspace before filling those two billion tables ;) Is there a maximum number of tables ?

Upvotes: 4

Related Questions