V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
MySQL 5.5 Community Server
MySQL 5.6 Community Server
Percona Configuration Wizard
XtraBackup 搭建主从复制
Great Sites on MySQL
Percona
MySQL Performance Blog
Severalnines
推荐管理工具
Sequel Pro
phpMyAdmin
推荐书目
MySQL Cookbook
MySQL 相关项目
MariaDB
Drizzle
参考文档
http://mysql-python.sourceforge.net/MySQLdb.html
sujin190
V2EX  ›  MySQL

mysql 奇怪的死锁问题求解

  •  
  •   sujin190 ·
    snower · 2016-06-13 10:04:27 +08:00 · 4809 次点击
    这是一个创建于 3083 天前的主题,其中的信息可能已经有所发展或是发生改变。
    InnoDB: Warning: a long semaphore wait:
    --Thread 139666312808192 has waited at buf0buf.cc line 2576 for 342.00 seconds the semaphore:
    S-lock on RW-latch at 0x7f077d5e08c0 created in file buf0buf.cc line 1069
    number of readers 0, waiters flag 0, lock_word: 100000
    Last time read locked in file btr0cur.cc line 3592
    Last time write locked in file /export/home/pb2/build/sb_0-17604105-1452827438.0/rpm/BUILD/mysql-5.6.29/mysql-5.6.29/storage/innobase/buf/buf0buf.cc line 3691
    InnoDB: Warning: a long semaphore wait:
    --Thread 139665275766528 has waited at buf0buf.cc line 2576 for 331.00 seconds the semaphore:
    S-lock on RW-latch at 0x7f077d5e08c0 created in file buf0buf.cc line 1069
    number of readers 0, waiters flag 0, lock_word: 100000
    Last time read locked in file btr0cur.cc line 3592
    Last time write locked in file /export/home/pb2/build/sb_0-17604105-1452827438.0/rpm/BUILD/mysql-5.6.29/mysql-5.6.29/storage/innobase/buf/buf0buf.cc line 3691
    InnoDB: Warning: a long semaphore wait:
    --Thread 139661653473024 has waited at buf0buf.cc line 2576 for 313.00 seconds the semaphore:
    S-lock on RW-latch at 0x7f0701de88c0 created in file buf0buf.cc line 1069
    number of readers 0, waiters flag 0, lock_word: 100000
    Last time read locked in file row0sel.cc line 3220
    Last time write locked in file /export/home/pb2/build/sb_0-17604105-1452827438.0/rpm/BUILD/mysql-5.6.29/mysql-5.6.29/storage/innobase/buf/buf0buf.cc line 3691
    InnoDB: Warning: a long semaphore wait:
    --Thread 139665089767168 has waited at buf0buf.cc line 2576 for 302.00 seconds the semaphore:
    S-lock on RW-latch at 0x7f0701de88c0 created in file buf0buf.cc line 1069
    number of readers 0, waiters flag 0, lock_word: 100000
    Last time read locked in file row0sel.cc line 3220
    Last time write locked in file /export/home/pb2/build/sb_0-17604105-1452827438.0/rpm/BUILD/mysql-5.6.29/mysql-5.6.29/storage/innobase/buf/buf0buf.cc line 3691
    InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
    InnoDB: Pending preads 2, pwrites 0
    

    这可能是什么问题导致的呢?读并发太高了? mysql 从库

    我在后面输出的内容中看到了这个

    267.14 inserts/s, 149.65 updates/s, 0.00 deletes/s, 362984.67 reads/s

    这个的意思是真的有 36 万的查询

    3 条回复    2016-06-13 21:58:39 +08:00
    Infernalzero
        1
    Infernalzero  
       2016-06-13 13:38:12 +08:00
    LATEST DETECTED DEADLOCK 那段你没贴哪知道是什么原因
    sujin190
        2
    sujin190  
    OP
       2016-06-13 17:23:48 +08:00
    @Infernalzero 没有这段啊。。不过有这个 INNODB MONITOR OUTPUT
    tcsky
        3
    tcsky  
       2016-06-13 21:58:39 +08:00
    感觉这边提技术类问题回答的人越来越少了..
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   3052 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 19ms · UTC 13:11 · PVG 21:11 · LAX 05:11 · JFK 08:11
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.