MySQL database limits
We are using a solution with AWS+RDS, and I was wondering what are 开发者_高级运维the absolute Database limits. Limits like
- Number of rows in a table.
- Number of tables in a database.
- Number of databases in an RDS instance.
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 ?
精彩评论