Mysql：Optimization and Indexes：优化-索引
摘要：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
阅读(384)
推荐(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
阅读(533)
推荐(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
阅读(238)
推荐(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
阅读(435)
推荐(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
阅读(2444)
推荐(0) 编辑
Mysql：--secure-auth、--secure-file-priv
摘要：secure_auth PropertyValue Command-Line Format --secure-auth[={OFF|ON}] Deprecated Yes System Variable secure_auth Scope Global Dynamic Yes Type Boolea
阅读全文
posted @
2020-04-01 11:16
jinzhenshui
阅读(1604)
推荐(0) 编辑
Mysql：Security Issues with LOAD DATA LOCAL：【LOCAL】关键字的安全问题：--load-infile
摘要：6.1.6 Security Issues with LOAD DATA LOCAL The LOAD DATA statement can load a file located on the server host, or, if the LOCAL keyword is specified,
阅读全文
posted @
2020-04-01 10:59
jinzhenshui
阅读(488)
推荐(0) 编辑
