大神速来围观，mysql ndbcluster7.3.2报错怎么处理

zsc1980

fuiou_cary 发表于 2014-12-2 11:40
没有，效率高的时候基本没问题，但是一旦碰到多个慢查询一起查这个表，恰好这个时候插入数据服务器响应慢 ...

手册里的解释 请问有没有尝试减少 MaxBufferedEpochs这个值呢？

MaxBufferedEpochs

Effective Version        Type/Units        Default        Range/Values        Restart Type
NDB 6.2.14        epochs        100        0 - 100000        N
The number of unprocessed epochs by which a subscribing node can lag behind. Exceeding this number causes a lagging subscriber to be disconnected.

The default value of 100 is sufficient for most normal operations. If a subscribing node does lag enough to cause disconnections, it is usually due to network or scheduling issues with regard to processes or threads. (In rare circumstances, the problem may be due to a bug in the NDB client.) It may be desirable to set the value lower than the default when epochs are longer.

Disconnection prevents client issues from affecting the data node service, running out of memory to buffer data, and eventually shutting down. Instead, only the client is affected as a result of the disconnect (by, for example gap events in the binary log), forcing the client to reconnect or restart the process.

http://dev.mysql.com/doc/refman/ ... d-maxbufferedepochs 原文地址】

zsc1980

fuiou_cary 发表于 2014-12-2 11:40
没有，效率高的时候基本没问题，但是一旦碰到多个慢查询一起查这个表，恰好这个时候插入数据服务器响应慢 ...

The number of unprocessed epochs by which a subscribing node can lag behind. Exceeding this number causes a lagging subscriber to be disconnected.

The default value of 100 is sufficient for most normal operations. If a subscribing node does lag enough to cause disconnections, it is usually due to network or scheduling issues with regard to processes or threads. (In rare circumstances, the problem may be due to a bug in the NDB client.) It may be desirable to set the value lower than the default when epochs are longer.

Disconnection prevents client issues from affecting the data node service, running out of memory to buffer data, and eventually shutting down. Instead, only the client is affected as a result of the disconnect (by, for example gap events in the binary log), forcing the client to reconnect or restart the process.

5.1文档里的 请问有没有尝试减小值？

fuiou_cary

zsc1980 发表于 2014-12-2 12:39
手册里的解释 请问有没有尝试减少 MaxBufferedEpochs这个值呢？

MaxBufferedEpochs

不太明白跟这个参数有什么关系啊？新手求解释！

zsc1980

fuiou_cary 发表于 2014-12-2 17:51
不太明白跟这个参数有什么关系啊？新手求解释！

出现这种情况的时候 管理节点的日志里会有这个相关的错误

fuiou_cary

zsc1980 发表于 2014-12-4 18:12
出现这种情况的时候 管理节点的日志里会有这个相关的错误

可是我的没有哎   我是7.3.2   跟版本有关系吗？

zsc1980

fuiou_cary 发表于 2014-12-5 11:59
可是我的没有哎   我是7.3.2   跟版本有关系吗？

我用的7.3.5 可能跟版本有关系吧

fuiou_cary

zsc1980 发表于 2014-12-9 13:34
我用的7.3.5 可能跟版本有关系吧

嗯   应该是  你是减少MaxBufferedEpochs？  我搞了个7.3.6的测试   可是出现的是
WARNING  -- Node 5: Disconnecting node 23 because it has exceeded MaxBufferedEpochs (100 > 100), epoch 4434486/0
这个是应该增大MaxBufferedEpochs吧？

fuiou_cary

zsc1980 发表于 2014-12-9 13:34
我用的7.3.5 可能跟版本有关系吧

我是一次性大量插数据的时候报了一个transaction abort的错，管理节点报了MaxBufferedEpochs这个exceed的错

zsc1980

fuiou_cary 发表于 2014-12-9 14:37
嗯   应该是  你是减少MaxBufferedEpochs？  我搞了个7.3.6的测试   可是出现的是
WARNING  -- Node 5:  ...

官方文档写到减小 表示怀疑