当前时间: 1970-01-01 08:00:00
分类:办公文件
评论(0)
直播预告:怎么能读懂MySQL的源码?很多时候,DBA需要具备“兜底”能力——不仅能解决手册上的常见问题,还要能应对MySQL内核层面的疑难杂症。如果你能提供一份详细的故障报告,并给出可行的规避方法,领导、研发乃至客户都会对你非常信任。也基于此,我们找到有多年数据库内核开发经验的柯煜昌老师,让他今晚9点来直播聊聊怎样能读懂MySQL源码。昨晚,我们还试播了一下,其中他分享了两个案例挺有意思的。柯老师在之前公司遇到过的一个问题:truncate table操作,发现其他库的insert或者select都变慢了,有些都到20秒30秒了,DBA排查发现不存在事务相关的表锁,行锁的争用,而且给出事故报告也无法让用户信服。更给不出规避方案。MySQL 5.7,有1000多个分区的表,在执行drop 库的时候,会导致其他库的事务被卡住。先留个悬念,如果想知道两个问题的具体原因,可以一起来围观今晚的直播。我们也会维护一个MySQL源码交流群,大家可以加下方微信,备注“MySQL内核交流”,等待拉你进群,直播里提到的一些资料以及PPT,也会分享到群里。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-04 17:23:28 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/711465.html
- 运行时间 : 1.680933s [ 吞吐率:0.59req/s ] 内存消耗:4,799.52kb 文件加载:145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=ceb04a4fd6dd22aac8de805d68bd7f31
- CONNECT:[ UseTime:0.013926s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001116s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.111678s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.144105s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.011605s ]
- SELECT * FROM `set` [ RunTime:0.108942s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001233s ]
- SELECT * FROM `article` WHERE `id` = 711465 LIMIT 1 [ RunTime:0.086811s ]
- UPDATE `article` SET `lasttime` = 1780565009 WHERE `id` = 711465 [ RunTime:0.123748s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.181492s ]
- SELECT * FROM `article` WHERE `id` < 711465 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.046787s ]
- SELECT * FROM `article` WHERE `id` > 711465 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.092153s ]
- SELECT * FROM `article` WHERE `id` < 711465 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.007080s ]
- SELECT * FROM `article` WHERE `id` < 711465 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.331130s ]
- SELECT * FROM `article` WHERE `id` < 711465 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.262648s ]
1.717007s