• 1.MySQL 中的 3 大日志是指哪些？

https://mp.weixin.qq.com/s?__biz=MzUyNDc0NjM0Nw==&mid=2247493940&idx=1&sn=9bc8aef5716f0ac1f30d52b0681115c0&chksm=fa2a0230cd5d8b262b26c7b33900ed3f20fd9d8e970ea6eab17efd7606410e9d36ff84752fdc&mpshare=1&scene=23&srcid=10297hDoe0QpbvA0RPxEfpt5&sharer_sharetime=1635513008976&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 2.MySQL 定时备份数据库

https://mp.weixin.qq.com/s?__biz=MzAxNDMwMTMwMw==&mid=2247530893&idx=3&sn=db3623f63fdd3a2fca83bffcba3a5c5a&chksm=9b975895ace0d183b05ef73f3dc3e9db1c312831464d1afe2cf082b6bf928bfcb38348ad6fd6&mpshare=1&scene=23&srcid=1028vwIzWoiGIQn3cYD7dexd&sharer_sharetime=1635384202178&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 3.MySQL速查手册

https://mp.weixin.qq.com/s?__biz=Mzg2MjEwMjI1Mg==&mid=2247524087&idx=1&sn=ca6e74c1224bee85ac0f92ca7f5009a5&chksm=ce0e2974f979a0621b80271d6cf50d8daa5fced899672b6c6147592a037b296c842715a4be00&mpshare=1&scene=23&srcid=10221CFPinOEuOn5HptTk4zd&sharer_sharetime=1634893429540&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 4.select......for update会锁表还是锁行

https://mp.weixin.qq.com/s?__biz=MzIyNDU2ODA4OQ==&mid=2247492731&idx=1&sn=b9bb968956afb7e5b6e9636b8d638fb4&chksm=e80e520ddf79db1b3845b6946eedc01100b53ebf48ebe1c051a1a2f90857203355a0ef34ba10&mpshare=1&scene=23&srcid=1022D0RLp1mfoWKXDtZZ57TM&sharer_sharetime=1634893371835&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 4.MySQL 的零拷贝技术

https://mp.weixin.qq.com/s?__biz=MzA5ODM5MDU3MA==&mid=2650875264&idx=1&sn=6878d91ebfa8000e776c4b1daa4bbd0c&chksm=8b67c2c5bc104bd3ff211a746e0b4522a2c3a007b5ced0343dc34fdaf85f92a346a899817b07&mpshare=1&scene=23&srcid=1014uwJQv7SHIaGyfQDue6dR&sharer_sharetime=1634185572373&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 5.Innodb中的事务隔离级别和锁的关系

https://mp.weixin.qq.com/s?__biz=MzIyNDU2ODA4OQ==&mid=2247493300&idx=1&sn=03b1710852c30581ff0481cb89aa9a58&chksm=e80e50c2df79d9d43ad076f48323bb07b5c932bb86b6634d5899e37bd79118fef2acc931ea6c&mpshare=1&scene=23&srcid=11268nwGVPggsTdse6n2AATp&sharer_sharetime=1637886159188&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 6.一篇明白SQL的执行顺序

https://mp.weixin.qq.com/s?__biz=MzIyNDU2ODA4OQ==&mid=2247494193&idx=1&sn=ecf4e2fbf08c0d019efb7fbe4f1b9711&chksm=e80e5c47df79d551a26a8bf03805e80f333f97338e7db0848b9ec83f456ea8b4c0d034122648&mpshare=1&scene=23&srcid=01039fn4OHsgJOrXzftjX7Bj&sharer_sharetime=1641177225890&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 7.高逼格的 SQL 写法：行行比较

https://mp.weixin.qq.com/s?__biz=Mzg4ODYxNDMyMw==&mid=2247490254&idx=1&sn=9ca87c8d8b1cf29123402b2a35e97771&chksm=cff92612f88eaf04d5d0484756be68f430b2a70e6213e7a871639bdd88551bca3475bacc9d19&mpshare=1&scene=23&srcid=0228tZX9s6namCfcZWGvAyUP&sharer_sharetime=1646006978667&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 8.全网最全的 MySQL 索引优化方案

https://mp.weixin.qq.com/s?__biz=MzUxOTc4NjEyMw==&mid=2247529940&idx=3&sn=9ccb2a9a29e63eabfff88eb8d86db42b&chksm=f9f66e30ce81e72673908849d5398461c89ce3c4c5d0750ef20f0b558a1026924dac5de4cfd2&mpshare=1&scene=23&srcid=03315oH31c9LHjWIjxvELHI1&sharer_sharetime=1648707689703&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd

• 9.大厂在用的分库分表方案

https://mp.weixin.qq.com/s?__biz=MzUxOTc4NjEyMw==&mid=2247528768&idx=3&sn=20f26990c5d0cc6ca3e7ddd25726e4b9&chksm=f9f66aa4ce81e3b2612f91a96322a7e35d637c6ca51b8bf09004890094d20d5848a44c35b3e4&mpshare=1&scene=23&srcid=0312LOKDrkhQdesbYBn8mFMt&sharer_sharetime=1647044971534&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 10.警告！别再使用 TIMESTAMP 作为日期字段～

https://mp.weixin.qq.com/s?__biz=MzA4MDMyODg4OQ==&mid=2649486342&idx=1&sn=29f1d4a70aad5ff826fd9b2f0c754b71&chksm=87bab5d0b0cd3cc6d61586be5d271779e4266d65b6d95b68ef20f1badaf92fe68b1fa9771326&mpshare=1&scene=23&srcid=0321Blas7x1b9WgT0SWynLqK&sharer_sharetime=1647793835251&sharer_shareid=f770d25bc57f1c2f9159f85750f854dc#rd

• 11.mysql全文检索

https://mp.weixin.qq.com/s?__biz=MzI3ODcxMzQzMw==&mid=2247560071&idx=1&sn=b12323a97e9f31f40f79df0563c5104c&chksm=eb516eb1dc26e7a7d02a8982eca0b06d03c3398987a9b0e96ab697087cbd1a3555e9e1d36a1b&mpshare=1&scene=23&srcid=0407Zk07XFzQXDuISm7pHwyN&sharer_sharetime=1649375957734&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd

• 12.SQL优化万能公式：5 大步骤 + 10 个案例

https://mp.weixin.qq.com/s?__biz=MzUxOTc4NjEyMw==&mid=2247531333&idx=1&sn=736eb010fb7215fd7a7ec6a7cc897146&chksm=f9f660a1ce81e9b7c88edbd616ad5aff7699083e931a728611ce695b25656a0fb7a5d7157ae8&mpshare=1&scene=23&srcid=0421IuF60xFHhD8vM4zmNLIK&sharer_sharetime=1650499737810&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e%23rd

• 13.项目实践中如何优化MySQL

https://mp.weixin.qq.com/s?__biz=MzIyNDU2ODA4OQ==&mid=2247495951&idx=1&sn=d0b8ae6634c653d467e91531226b2beb&chksm=e80e4779df79ce6fd80ad4b0189c898deee0bd28cdb20e612bc8c1bc3a32a0eb12a2679ce991&mpshare=1&scene=23&srcid=0425NoXJm2iiVBbr8QSGZ58w&sharer_sharetime=1650893453893&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e%23rd

• 14.一次SQL查询优化原理分析：900W+数据，从17s到300ms

https://mp.weixin.qq.com/s?__biz=MzUzMTA2NTU2Ng==&mid=2247544936&idx=1&sn=ab2b67e2dd5e9ac1f595d9852b630444&chksm=fa4a4fd9cd3dc6cf78d5939f371d7ec9d0f950e40b48a65c9b62910eb1a6b8ebda3f792538bb&mpshare=1&scene=23&srcid=0524GEL4azIA6vR39mzVKPiW&sharer_sharetime=1653368578690&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e%23rd

• 15.数据库连接池设置多大才合适

https://mp.weixin.qq.com/s?__biz=MzIyNDU2ODA4OQ==&mid=2247496496&idx=1&sn=b18620c1e4ea1d3662506c777b8bdcb1&chksm=e80e4546df79cc50178a5b40d5e7bcd6939e3c96be37750f70b89b83da4cbada4601f390a30b&mpshare=1&scene=23&srcid=0521IWl7ivWn4lt8hPTepyE0&sharer_sharetime=1653147010765&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e%23rd

• SQL优化 21 连击 + 思维导图

https://mp.weixin.qq.com/s?__biz=Mzg5NDM1ODk4Mw==&mid=2247545538&idx=3&sn=ccc69e05e4ba10246a25f42333ab3627&chksm=c022b66af7553f7ca76eedf39afab550c20c980b265f9e5e1b21ec3983760de6e2bdbc1c0ec4&mpshare=1&scene=23&srcid=0902qLW9QW2mwI8zOx1k2DL0&sharer_sharetime=1662127171875&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e%23rd&sourceChannelId=2387235590

• MySQL 定时备份的几种方式（非常全面）

https://mp.weixin.qq.com/s?__biz=MzA4MDMyODg4OQ==&mid=2649489019&idx=2&sn=b4a9bbddd5dd38babddc214cc68f2a9b&chksm=87babfadb0cd36bb0dd63369cfa022931471962da28cd82d05a418c50d2908549928c7230dab&mpshare=1&scene=23&srcid=1109GFrs8G5TmCHXruZ5pYDa&sharer_sharetime=1668040429041&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd

• 优化慢查询SQL【重要】

https://mp.weixin.qq.com/s?__biz=MzUzMTA2NTU2Ng==&mid=2247561383&idx=3&sn=98927d90ab71711e728c4147b10e79b5&chksm=fa4b8f16cd3c0600b1b0812776efac45c1671c431534b53e7171ce8d7705b4ebbec73f1ea29f&mpshare=1&scene=23&srcid=1114LamU6MCLWMmk1VV9T2ed&sharer_sharetime=1668388451371&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd

• SQL 常用脚本大全

https://mp.weixin.qq.com/s?__biz=MzA4MDMyODg4OQ==&mid=2649489075&idx=1&sn=dc3e8dc356c7cc0b8d08c76e663e5819&chksm=87babf65b0cd3673e2c3b02478889a8f0fb7bd745fe63f60f9593a9170c2dd925e23bbc3be1a&mpshare=1&scene=23&srcid=1117P31BYPAPOTcaLBHPxSc7&sharer_sharetime=1668645326208&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd

• 原来count(*)就是我们系统的接口性能变差100倍的真凶

https://mp.weixin.qq.com/s?__biz=MzUzMTA2NTU2Ng==&mid=2247562807&idx=2&sn=a678d2ddea47a0a298b60b0f4bbc92e7&chksm=fa4b8986cd3c009022a21efe6b03f5b5ab37b0b321ca6c880dc164363a7ff2be3d4ebf30d71d&mpshare=1&scene=23&srcid=1204i2GtsRNfAmZk5zZ6pRC3&sharer_sharetime=1670164659362&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd

• Mysql 索引失效有哪些场景？

https://mp.weixin.qq.com/s?__biz=MzUxOTc4NjEyMw==&mid=2247548340&idx=3&sn=37b2f2b99c17001b29766fdeef01decc&chksm=f9f62650ce81af46e6bf008620598bde6791da930c7b2408ffa63beed1ecc9e30d8f6f784b3b&mpshare=1&scene=23&srcid=1201Gx4eH7xrM7CMPGserYbp&sharer_sharetime=1669855663573&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd

• MySQL 是怎么加行级锁的？

https://mp.weixin.qq.com/s?__biz=Mzk0MzIyMDA1OA==&mid=2247498026&idx=2&sn=18003ff15871b28356acf76ad1033da0&chksm=c3358d1ff4420409d4c30e34da5761272649547ea475e4beabe0a2e1da6b60616a02571751bf&mpshare=1&scene=23&srcid=1202y22vM4e35syG21O4sShA&sharer_sharetime=1669961509129&sharer_shareid=7fec9c1809ccb850bfdebba7d4f7a81e#rd