外键与分区 [英] Foreign keys vs partitioning

问题描述

由于目前分区的mySQL数据库不支持外键，因此我希望听到一些专业级和专业级的应用程序可以处理大约1-400 000行/每表。不幸的是，我还没有足够的经验在这方面做出自己的结论...

非常感谢！

参考文献：

/ 2496140 / mysql-partitioning-with-foreign-keys>分区有外键的mySQL表？ 解决方案

那么，如果你需要对一个小到400.000行的表进行分区，就会得到另一个不是MySQL的数据库。认真。按照现代标准，任何低于1,000,000行的表格通常都是小的（甚至不小），除非你也没有任何索引等等。而现代标准在这方面大概有10年的历史了。

Since foreign keys are not supported by partitioned mySQL databases for the moment, I would like to hear some pro's and con's for a read-heavy application that will handle around 1-400 000 rows per table. Unfortunately, I dont have enough experience yet in this area to make the conclusion by myself...

Thanks a lot!

References:

How to handle foreign key while partitioning

Partitioning mySQL tables that has foreign keys?

解决方案

Well, if you need partitioning for a table as small as 400.000 rows get another database than MySQL. Seriously. By modern standards any table below 1.000.000 rows is normally neglegible in size (not even small), unless you also dont have any index etc. And modern standards are about 10 years old in this regard.

这篇关于外键与分区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！