MySQL数据库中的最大表 [英] Max tables in a MySQL database

问题描述

在数据库中有太多的表是不好的吗？我在一个数据库中有大约160个表。最好将它分成几个数据库，而不是使用单个数据库？单个数据库对我来说更方便。

Is it bad to have too many tables in a database? I have about 160 tables in one database. Is it better to split it into several database rather than using a single database? Single database is more convenient for me.

推荐答案

有对MySQL数据库中的表数量没有服务器限制。您肯定没有160个表的问题，您不需要将它们拆分成多个数据库。

There are no server limits on the number of tables in a MySQL database. You will definitely have no problems with 160 tables, and you don't need to split them into multiple databases.

您不能通过将表分成多个数据库来获得性能。如果性能仍然是问题，您可以考虑使用每表表空间，以便将一些表集放在不同的物理磁盘上。

You will not gain performance by splitting your tables into multiple databases. If performance remains an issue, you could consider using per-table tablespaces in order to place some sets of tables on different physical disks.

这篇关于MySQL数据库中的最大表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！