wsrep_max_ws_rows seems ineffective

[Henrik Ingo]

The option wsrep_max_ws_rows should limit max nr of rows a transaction can modify (and thus, replicate). Default is 128K. However, in Alex' own testing he deleted 3M rows without getting problems. Also on the mailing list people are hit by issues following running a large transaction.

As long as running a large transaction can lead to issues (ie forever), it would improve usability if this option actually enforces a max size on transactions. That way people would get a client side error instead of OOM and other issues.

note: also check wsrep_max_ws_size while at it.

[Philip Stoev (philip-stoev-f)]

wsrep_max_ws_size does not work for me, but wsrep_max_ws_rows does work.

[Seppo Jaakola (seppo-jaakola)]

Tracked in github: https://github.com/codership/mysql-wsrep/issues/257