8.4 Optimizing Database Structure优化数据库结构

8.4.1 Optimizing Data Size优化数据大小
8.4.2 Optimizing MySQL Data Types优化MySQL数据类型
8.4.3 Optimizing for Many Tables对多个表进行优化
8.4.4 Internal Temporary Table Use in MySQLMySQL中内部临时表的使用
8.4.5 Limits on Number of Databases and Tables数据库和表的数量限制
8.4.6 Limits on Table Size表大小限制
8.4.7 Limits on Table Column Count and Row Size表列计数和行大小的限制

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. 与优化应用程序代码时一样,您可以最小化I/O,将相关项放在一起,并提前计划,以便在数据量增加时保持较高的性能。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.从高效的数据库设计开始,可以让团队成员更容易地编写高性能的应用程序代码,并使数据库能够随着应用程序的发展和重写而持久。

8.4.1 Optimizing Data Size
8.4.2 Optimizing MySQL Data Types
8.4.3 Optimizing for Many Tables
8.4.4 Internal Temporary Table Use in MySQL
8.4.5 Limits on Number of Databases and Tables
8.4.6 Limits on Table Size
8.4.7 Limits on Table Column Count and Row Size