- 10.4.1 优化数据大小10.4.1 Optimizing Data Size
- 10.4.2 优化 MySQL 数据类型10.4.2 Optimizing MySQL Data Types
- 10.4.3 多表优化10.4.3 Optimizing for Many Tables
- 10.4.4 MySQL 内部临时表的使用10.4.4 Internal Temporary Table Use in MySQL
- 10.4.5 数据库和表数量的限制10.4.5 Limits on Number of Databases and Tables
- 10.4.6 表大小的限制10.4.6 Limits on Table Size
- 10.4.7 表列数和行大小的限制10.4.7 Limits on Table Column Count and Row Size
作为数据库设计人员,你应寻找最有效的方式来组织你的模式、表和列。就像优化应用程序代码一样,你需要最小化 I/O,将相关项放在一起,并提前规划,以便在数据量增加时性能依旧保持高效。从高效的数据库设计开始,可以使团队成员更容易编写高性能的应用程序代码,并使数据库在应用程序演变和重写时有更大的延续性。In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the data volume increases. Starting with an efficient database design makes it easier for team members to write high-performing application code, and makes the database likely to endure as applications evolve and are rewritten.