Re: Test cluster slower than single machine

[Brad Crotchett]

Thanks for the input Jonas and JD. Here are my latest tests and results:

I changed the BIGINT columns to INT
I added --ndb_autoincrement_prefetch_sz=250 --ndb_use_exact_count=0 to SQL nodes

I then ran a series of tests with all the nodes on a single SGI. I started with 2 data nodes and went through different numbers of SQL nodes, then went to 4 data nodes and varied the number of SQL nodes. Here is what the results look like:

Tests with 2 data nodes:
2 sql nodes: 77.25 tps
3 sql nodes: 79.35 tps
4 sql nodes: 72.31 tps
5 sql nodes: 73.34 tps

Tests with 4 data nodes:
1 sql node: 47.58 tps
2 sql nodes: 71.75 tps
3 sql nodes: 63.41 tps
4 sql nodes: 63.67 tps
5 sql nodes: 65.12 tps
6 sql nodes: 60.09 tps
7 sql nodes: 59.48 tps

I am not just not seeing the performance.

Oh, and yes, Jonas, I am running with engine_condition_pushdown=1

Thanks again,

Brad