2020 年 4月 1 日随笔档案 - 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 阅读(430) 评论(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 阅读(553) 评论(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 阅读(247) 评论(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 阅读(467) 评论(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 阅读(2568) 评论(0) 推荐(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 阅读(1642) 评论(0) 推荐(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 阅读(515) 评论(0) 推荐(0)