8.4.3 Optimizing for Many Tables对多个表进行优化

8.4.3.1 How MySQL Opens and Closes TablesMySQL如何打开和关闭表
8.4.3.2 Disadvantages of Creating Many Tables in the Same Database在同一数据库中创建多个表的缺点

Some techniques for keeping individual queries fast involve splitting data across many tables. When the number of tables runs into the thousands or even millions, the overhead of dealing with all these tables becomes a new performance consideration.一些保持单个查询速度的技术涉及跨多个表拆分数据。当表的数量达到数千甚至数百万时,处理所有这些表的开销成为新的性能考虑因素。

8.4.3.1 How MySQL Opens and Closes Tables
8.4.3.2 Disadvantages of Creating Many Tables in the Same Database