数据库/模式的数量是否有限制 [英] Is there a limit on number of databases/schemas

问题描述

我可以在Azure数据库for MySQL上创建的数据库/模式数量有限制吗？

---

Fabricio Rodriguez - 南非比勒陀利亚

解决方案

您好Fabricio，

此处详细介绍了Azure对MySQL实例的限制：  Azure数据库中MySQL的限制

在该文档中有一个指向MySQL文档的链接，该文档在容量方面说明如下：

< span style ="">"MySQL对数据库的数量没有限制。底层文件系统可能对目录数量有限制。


MySQL对表的数量没有限制。底层文件系统可能对表示表的文件数量有限制。单个存储引擎可能会施加特定于引擎的约束。 InnoDB允许多达40亿个表格。"

我希望此信息能够回答您的问题。请将其标记为已回答，或者请告知我们您可能会遇到的其他问题。

谢谢，

Mike

Is there a limit on number of databases/schemas I can create on Azure Database for MySQL?

---

Fabricio Rodriguez - Pretoria, South Africa

解决方案

Hi Fabricio,

The limitations that Azure places on an MySQL instance are detailed here: Limitations in Azure Database for MySQL

Within that document is a link to the MySQL docs, which state the following with regard to capacity:

"MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of directories.
MySQL has no limit on the number of tables. The underlying file system may have a limit on the number of files that represent tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables."

I hope this information answers your question. Please mark it as answered or please let us know what additional questions you may have.

Thank you,

Mike

这篇关于数据库/模式的数量是否有限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！