This is a work in progress. With the same test current 3.x tree shows: 3.1 wsrep OFF Rows Seconds RSS 1 0 82116 2 0 82116 4 0 82116 8 0 82116 16 0 82116 32 0 82116 64 0 82116 128 0 82376 256 0 82376 512 0 82640 1024 0 83232 2048 0 83860 4096 0 85116 8192 0 87600 16384 0 92616 32768 1 102664 65536 0 122724 131072 2 163204 262144 2 243008 524288 5 342216 1048576 11 342216
3.1 wsrep ON Rows Seconds RSS 1 0 82428 2 0 82428 4 0 82428 8 0 82596 16 0 82624 32 0 82704 64 0 82704 128 0 82704 256 0 82964 512 0 83228 1024 0 83856 2048 0 84604 4096 0 86912 8192 0 91548 16384 0 100100 32768 1 117856 65536 1 140960 131072 2 199612 262144 4 317012 524288 9 484000 1048576 18 617764
This effectively halves memory overhead compared to 2.x branch.
This is a work in progress. With the same test current 3.x tree shows:
3.1 wsrep OFF
Rows Seconds RSS
1 0 82116
2 0 82116
4 0 82116
8 0 82116
16 0 82116
32 0 82116
64 0 82116
128 0 82376
256 0 82376
512 0 82640
1024 0 83232
2048 0 83860
4096 0 85116
8192 0 87600
16384 0 92616
32768 1 102664
65536 0 122724
131072 2 163204
262144 2 243008
524288 5 342216
1048576 11 342216
3.1 wsrep ON
Rows Seconds RSS
1 0 82428
2 0 82428
4 0 82428
8 0 82596
16 0 82624
32 0 82704
64 0 82704
128 0 82704
256 0 82964
512 0 83228
1024 0 83856
2048 0 84604
4096 0 86912
8192 0 91548
16384 0 100100
32768 1 117856
65536 1 140960
131072 2 199612
262144 4 317012
524288 9 484000
1048576 18 617764
This effectively halves memory overhead compared to 2.x branch.