[MySQL 源码] MySQL drop table(压缩表)效率与流程分析

  1. 云栖社区>
  2. 博客>
  3. 正文

[MySQL 源码] MySQL drop table(压缩表)效率与流程分析

zhaiwx_yinfeng 2016-05-10 14:10:10 浏览1637
展开阅读全文

 之前发生过一起连续drop压缩表,最后长时间等待信号量crash,线上alert log里的报错是:

OS WAIT ARRAY INFO: reservation count 36647199, signal count 34050225 --Thread 1331538240 has waited at row0purge.c line 680 for 950.00 seconds the semaphore: S-lock on RW-latch at 0xe60b60 '&dict_operation_lock' a writer (thread id 1383319872) has reserved it in mode exclusive number of readers 0, waiters flag 1,

网友评论

登录后评论
0/500
评论
zhaiwx_yinfeng
+ 关注