MySQL最多能装多少记录

最新推荐文章于 2022-09-05 17:34:46 发布

fxsjy

最新推荐文章于 2022-09-05 17:34:46 发布

阅读量905

点赞数

文章标签： mysql scalability server table each up

本文链接：https://blog.csdn.net/fxsjy/article/details/4870003

版权

Scalability and Limits:

Support for large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 200,000 tables and about 5,000,000,000 rows.
Support for up to 64 indexes per table (32 before MySQL 4.1.2). Each index may consist of 1 to 16 columns or parts of columns. The maximum index width is 1000 bytes (767 for InnoDB); before MySQL 4.1.2, the limit is 500 bytes. An index may use a prefix of a column for CHAR, VARCHAR, BLOB, or TEXT column types.