› 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
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
这是一个创建于 3095 天前的主题，其中的信息可能已经有所发展或是发生改变。
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 万的查询
 |
1
Infernalzero 2016-06-13 13:38:12 +08:00
LATEST DETECTED DEADLOCK 那段你没贴哪知道是什么原因
|
 |
2
sujin190 OP @Infernalzero 没有这段啊。。不过有这个 INNODB MONITOR OUTPUT
|
 |
3
tcsky 2016-06-13 21:58:39 +08:00
感觉这边提技术类问题回答的人越来越少了..
|
Select Language