mysql参数Innodb_row_lock_current_waits异常

fofo成长记 发布于 2017/02/28 19:13
阅读 1K+
收藏 0

数据库巡检时遇到Innodb_row_lock_current_waits参数值异常情况,如下:

mysql> show  status  like "Innodb_row_lock%";
+-------------------------------+----------------------+
| Variable_name                 | Value                |
+-------------------------------+----------------------+
| Innodb_row_lock_current_waits | 18446744073709551606 |
| Innodb_row_lock_time          | 86562050             |
| Innodb_row_lock_time_avg      | 22                   |
| Innodb_row_lock_time_max      | 51968                |
| Innodb_row_lock_waits         | 3895570              |
+-------------------------------+----------------------+
5 rows in set (0.00 sec)

# mysql -e "select count(*) from information_schema.innodb_lock_waits;"
+----------+
| count(*) |
+----------+
|        0 |
+----------+

# mysql -e "select version();"
+------------+
| version()  |
+------------+
| 5.6.30-log |
+------------+

可能导致该问题的原因:

1)innodb-buffer-pool-size设置过小导致

排查:当前已检查过innodb-buffer-pool-size参数的设置,内存为65G,innodb-buffer-pool-size设置了42G。

 

备注

查询mysql官网的bugs库,该问题的id为71520

https://bugs.mysql.com/bug.php?id=71520

还未得到解答,求大牛帮忙解析下可能的原因

加载中
返回顶部
顶部