一条sql语句慢在哪之抓包分析

心已赠人 2022-09-13 13:24 148阅读 0赞

本次将PPT内容全部放出，并在文末附上助理微信号二维码，可添加助理微信加入GreatSQL/MGR交流微信群。

\* GreatSQL社区原创内容未经授权不得随意使用，转载请联系小编并注明来源。

![8838885c3914b39463d28af9567b8b97.png][]

![f1fc88f1108552ce1ca4c187bb476347.png][]

![f6b4a3b1535af3c98f78707a090017c6.png][]

![45dec4e9ff14144933234b990258683b.png][]

![a7e882faa439661769fc492c7679b8a2.png][]

![38a4dd2f4ba87715727e29315703dd63.png][]

![7385671444172b88e0111d2ca21f11c7.png][]

![79a542d0519435c5aed25d14c1a9f915.png][]

![21c90d8cbd6563e420269286bd1f0b7d.png][]

![a460f8692a4f8e235d32f80093ba8d7b.png][]

![0c22ec37c4c62476618869348a71eef6.png][]

![b2c3e2e42ada13a035856b6a233e1f86.png][]

![6ad5906130548cf6648e9e81e6848250.png][]

![e8c9f845981b44e3de99be451a56f202.png][]

![05c47a860e80c5915c8ce3b90fb35dc5.png][]

![80faea258d257b06d5f9aa4da21cf3bf.png][]

![844bcba895280ae84f9e1bfa083e9b92.png][]

![f963e2a482520b96c569a87badd8d101.png][]

![f721049e0ee109502526b9ede47323b8.png][]

*  快速重传：（*https://datatracker.ietf.org/doc/html/rfc5681\#page-11*）
 *  uSACK：（*https://datatracker.ietf.org/doc/html/rfc2018*）
 *  uD-SACK：（*https://datatracker.ietf.org/doc/html/rfc2018*）

![4dc17e9c98cdd19902e84c30d9aadd98.png][]

![a499ca3dab020b4f4e13072cda050cbe.png][]

![dfe3911c53a80d32cc11a081eec7671b.png][]

![a799c20290a95cb4c3bcbe7161d3577a.png][]

![376cd54fe6af61284a8d4b56b629ad55.png][]

![0d676c055ec15ccf8b0666dbcbbf768f.png][]

![79f2f33986539e431ba8268063cb8eaf.png][]

![b08e4fd174eb712e6221382d5e015ce2.png][]

![000cdc52b38c7f5da9c49debc30927ad.png][]

![e535edae309178e8b70a60c2d70ab97f.png][]

![4d1bc1b4e149c156d78fd74c465f7d8c.png][]

![c2e94d6149b94b2d3a363b15901e1bee.png][]

![7b4a7979025c601b68e4e8744b5225f2.png][]

![652e658a68f1d9eeb57cfbe6e7cdeec7.png][]

![cecb070dec7a2a7a539de4c5dce75237.png][]

![bcb70b0225e5af11ea50c905f993b4b2.png][]

完整PPT文档下载地址：

*https://gitee.com/GreatSQL/GreatSQLDoc/tree/master/Presentations*

万里数据库公司成立于2000年，是原中国MySQL研发中心，也是国内最早并且唯一参与国际主流数据库核心代码开发的厂商，专注数据库领域20年，以做中国最优秀的分布式数据库为目标。

目前公司的主要产品GreatDB分布式版，在“2020-2021中国数字化年会”中荣膺“年度数据库创新产品奖”。它是一款NewSQL分布式关系型数据库软件，具有动态拓展、数据强一致、集群高可用等特性，目前已广泛应用于金融、能源、通信、政府、交通等多个行业的核心应用系统，历经500多个业务场景的锤炼，服务了国家电网、中国移动、中国石化、工商银行、光大银行等大型央企和国企。

Enjoy GreatSQL :)

--------------------

**文章推荐：**

*  [面向金融级应用的GreatSQL正式开源][GreatSQL]  
    
 *  [Changes in GreatSQL 8.0.25 (2021-8-26)][Changes in GreatSQL 8.0.25 _2021-8-26]
 *  [MySQL中MGR中SECONDARY节点磁盘满，导致mysqld进程被OOM Killed][MySQL_MGR_SECONDARY_mysqld_OOM Killed]
 *  [简单测试MySQL 8.0.26 vs GreatSQL 8.0.25的MGR稳定性表现][MySQL 8.0.26 vs GreatSQL 8.0.25_MGR]  
    
 *  [一周碎碎念，2021.9.12，之前说的MGR课程上线啦][2021.9.12_MGR]
 *  [技术分享 | Update更新慢、死锁等问题的排查思路分享][_ Update]
 *  [MySQL分区表的一个性能BUG][MySQL_BUG]  
    
 *  [《叶问》36期，MySQL最多只能用到128个逻辑CPU，是真的吗][Changes in GreatSQL 8.0.25 _2021-8-26]
 *  [GreatSQL重磅特性，InnoDB并行并行查询优化测试][Changes in GreatSQL 8.0.25 _2021-8-26]  
    
 *  [在Linux下源码编译安装GreatSQL/MySQL][Linux_GreatSQL_MySQL]

--------------------

扫码加入GreatSQL/MGR交流**QQ群**

![ee6b70fb1ea29cd1269db11cdb206c0c.png][]

点击文末“**阅读原文**”直达老叶专栏

[8838885c3914b39463d28af9567b8b97.png]: /images/20220828/5ada7caba13b40db84138f732ea546ce.png
[f1fc88f1108552ce1ca4c187bb476347.png]: /images/20220828/bb40ec40419c490f924df4a8ae914725.png
[f6b4a3b1535af3c98f78707a090017c6.png]: /images/20220828/5ce251a13bf14b21a0321da0fafc9009.png
[45dec4e9ff14144933234b990258683b.png]: /images/20220828/5f0cfbd34c86453fb9ed138ae5276fb1.png
[a7e882faa439661769fc492c7679b8a2.png]: /images/20220828/0348efc514674e2dad24ce7b432878c2.png
[38a4dd2f4ba87715727e29315703dd63.png]: /images/20220828/a6c8988da1c641b6bd06349437947618.png
[7385671444172b88e0111d2ca21f11c7.png]: /images/20220828/61769cc7d65448a9af6fcc93489ae2fa.png
[79a542d0519435c5aed25d14c1a9f915.png]: /images/20220828/3873285e3ca4417f97c40ac59904262c.png
[21c90d8cbd6563e420269286bd1f0b7d.png]: /images/20220828/800ef2d3a68941fcb85cf9ef7f506c33.png
[a460f8692a4f8e235d32f80093ba8d7b.png]: /images/20220828/798c591167b6444d861e0656da56655b.png
[0c22ec37c4c62476618869348a71eef6.png]: /images/20220828/1e42a0ecce34450fa7855ea99c1ee3d9.png
[b2c3e2e42ada13a035856b6a233e1f86.png]: /images/20220828/354bc3425aa04097866e6d40be556124.png
[6ad5906130548cf6648e9e81e6848250.png]: /images/20220828/34e0f2f2d8de418abef5e2776a35aee8.png
[e8c9f845981b44e3de99be451a56f202.png]: /images/20220828/7400f9057fbe41bf83fb5ef41dcf5f8d.png
[05c47a860e80c5915c8ce3b90fb35dc5.png]: /images/20220828/c12a58bde63a470ba7a397143bc78e3d.png
[80faea258d257b06d5f9aa4da21cf3bf.png]: /images/20220828/94fa139557de41ebb90cc8838057c52a.png
[844bcba895280ae84f9e1bfa083e9b92.png]: /images/20220828/49a787b779614a258ddd01fc6197e35c.png
[f963e2a482520b96c569a87badd8d101.png]: /images/20220828/14573cd2e677491dba5f3d294a5e550d.png
[f721049e0ee109502526b9ede47323b8.png]: /images/20220828/61f5b05bf5af4650a84920402159581e.png
[4dc17e9c98cdd19902e84c30d9aadd98.png]: /images/20220828/2436cbc4e4e34b90b5b18a227b3064e2.png
[a499ca3dab020b4f4e13072cda050cbe.png]: /images/20220828/832b3d3b409e40b499ccb0b44148d038.png
[dfe3911c53a80d32cc11a081eec7671b.png]: /images/20220828/5da91776573f4c6cb5560e98c2f6e94f.png
[a799c20290a95cb4c3bcbe7161d3577a.png]: /images/20220828/885e859ec1d84777a22bba71f101f6e3.png
[376cd54fe6af61284a8d4b56b629ad55.png]: /images/20220828/2e6534da3d824377904a11e6cfb4c796.png
[0d676c055ec15ccf8b0666dbcbbf768f.png]: /images/20220828/11c68a19b6c54906b71f259d495945c6.png
[79f2f33986539e431ba8268063cb8eaf.png]: /images/20220828/12204df58c44487f95a40d1df26063a9.png
[b08e4fd174eb712e6221382d5e015ce2.png]: /images/20220828/bc14881023724627945a13ab5bb21c9c.png
[000cdc52b38c7f5da9c49debc30927ad.png]: /images/20220828/934f353baae241f5968d7be930636523.png
[e535edae309178e8b70a60c2d70ab97f.png]: /images/20220828/37d7bb623d224b6cbb5e3a1e299ae578.png
[4d1bc1b4e149c156d78fd74c465f7d8c.png]: /images/20220828/5f741f6b826440d1864cd8a4c33ab364.png
[c2e94d6149b94b2d3a363b15901e1bee.png]: /images/20220828/cdb8fb9c714c4765bce7c60e1428e7f2.png
[7b4a7979025c601b68e4e8744b5225f2.png]: /images/20220828/3ddff03c094e46ffa3de5e2c88239486.png
[652e658a68f1d9eeb57cfbe6e7cdeec7.png]: /images/20220828/b4866e26c5054965844cddb8fb6abbf3.png
[cecb070dec7a2a7a539de4c5dce75237.png]: /images/20220828/31ac21e24e81456088c0b96ca5b2f789.png
[bcb70b0225e5af11ea50c905f993b4b2.png]: /images/20220828/9c2afa96cb2749c9a3b40fe2da41e293.png
[GreatSQL]: https://blog.csdn.net/enmotech/article/details/120108130
[Changes in GreatSQL 8.0.25 _2021-8-26]: https://blog.csdn.net/n88Lpo/article/details/120386624
[MySQL_MGR_SECONDARY_mysqld_OOM Killed]: http://mp.weixin.qq.com/s?__biz=MjM5NzAzMTY4NQ==&mid=2653936615&idx=1&sn=51c964adb602879095ac4f4dd853fe9d&chksm=bd3b418d8a4cc89b42b2138682a1326091d8526452dddf372dfc8ef7bd7e5ba3dbcc8b02db2a&scene=21#wechat_redirect
[MySQL 8.0.26 vs GreatSQL 8.0.25_MGR]: http://mp.weixin.qq.com/s?__biz=MjM5NzAzMTY4NQ==&mid=2653936592&idx=1&sn=310a26d6d78e176b925819359b604653&chksm=bd3b41ba8a4cc8ac0ca68da7c9ee83953d5f5e91cbc9480759eb8074c2b3994d8ecff2f59daa&scene=21#wechat_redirect
[2021.9.12_MGR]: http://mp.weixin.qq.com/s?__biz=MjM5NzAzMTY4NQ==&mid=2653936554&idx=1&sn=cc64211e88d16d8c2cc08b3b19061251&chksm=bd3b41c08a4cc8d6c23c8ba7aa423aaa7b40739c1ffbeaa0e5623fb85c255f8b59305313f3cb&scene=21#wechat_redirect
[_ Update]: https://blog.csdn.net/n88Lpo/article/details/120340200
[MySQL_BUG]: https://blog.csdn.net/yongqi_wang/article/details/86576006
[Linux_GreatSQL_MySQL]: http://mp.weixin.qq.com/s?__biz=MjM5NzAzMTY4NQ==&mid=2653936221&idx=1&sn=27183d95857dabef6bdf0d7541c4da57&chksm=bd3b40378a4cc921828ecf10774787bbf268d693490acf8c151a2b5c830bac3658870e95b396&scene=21#wechat_redirect
[ee6b70fb1ea29cd1269db11cdb206c0c.png]: /images/20220828/007a7c9250604354a6bb7a837fd79c9d.png