jinzhenshui - 博客园

2020年4月1日

摘要： 8.3 Optimization and Indexes 8.3.1 How MySQL Uses Indexes 8.3.2 Primary Key Optimization 8.3.3 Foreign Key Optimization 8.3.4 Column Indexes 8.3.5 Mul 阅读全文

posted @ 2020-04-01 20:14 jinzhenshui 阅读(420) 评论(0) 推荐(0)

Mysql：Optimizing for Many Tables：如果你的表太多，怎办？

摘要： 8.4.3 Optimizing for Many Tables 8.4.3.1 How MySQL Opens and Closes Tables 8.4.3.2 Disadvantages of Creating Many Tables in the Same Database Some tec 阅读全文

posted @ 2020-04-01 19:44 jinzhenshui 阅读(550) 评论(0) 推荐(0)

Mysql：Internal Temporary Table：【不可直接控制】的【内部】临时表：不要blob、不要text、不要太长>512的（二进制）字符串列！

摘要： 8.4.4 Internal Temporary Table Use in MySQL In some cases, the server creates internal temporary tables while processing statements. Users have no dir 阅读全文

posted @ 2020-04-01 19:17 jinzhenshui 阅读(245) 评论(0) 推荐(0)

Mysql：Optimizing Memory Use、Enabling Large Page Support：内存使用优化：【global + session】

摘要： 8.12.4 Optimizing Memory Use 8.12.4.1 How MySQL Uses Memory 8.12.4.2 Enabling Large Page Support 8.12.4.1 How MySQL Uses Memory MySQL allocates buffer 阅读全文

posted @ 2020-04-01 17:50 jinzhenshui 阅读(461) 评论(0) 推荐(0)

Mysql：Symbolic Links：软链接（符号链接）

摘要： 8.12.3 Using Symbolic Links 8.12.3.1 Using Symbolic Links for Databases on Unix 8.12.3.2 Using Symbolic Links for MyISAM Tables on Unix 8.12.3.3 Using 阅读全文

posted @ 2020-04-01 13:07 jinzhenshui 阅读(2560) 评论(0) 推荐(0)