category - nabbleapache-ignite-users.70518.x6.nabble.com/file/t1346/benchmark.pdf · second, which...

37
1 Category 1Node16G-Memory Performance .............................................................................................. 2 Yardstick Configuration .................................................................................................... 2 Results Summary ............................................................................................................. 2 2Node16G-Memory Performance .............................................................................................. 5 Yardstick Configuration .................................................................................................... 5 Results Summary ............................................................................................................. 5 4Node16G-Memory Performance .............................................................................................. 8 Yardstick Configuration .................................................................................................... 8 Results Summary ............................................................................................................. 8 4Node32G-Memory Performance ............................................................................................ 11 Yardstick Configuration .................................................................................................. 11 Results Summary ........................................................................................................... 11 4Node64G-Memory Performance ............................................................................................ 14 Yardstick Configuration .................................................................................................. 14 Results Summary ........................................................................................................... 14 8Node16G-Memory Performance ............................................................................................ 17 Yardstick Configuration .................................................................................................. 17 Results Summary ........................................................................................................... 17 8Node32G-Memory Performance ............................................................................................ 20 Yardstick Configuration .................................................................................................. 20 Results Summary ........................................................................................................... 20 8Node64G-Memory Performance ............................................................................................ 23 Yardstick Configuration .................................................................................................. 23 Results Summary ........................................................................................................... 23 12Node16G-Memory Performance ........................................................................................... 26 Yardstick Configuration .................................................................................................. 26 Results Summary ........................................................................................................... 26 12Node32G-Memory Performance ........................................................................................... 29 Yardstick Configuration .................................................................................................. 29 Results Summary ........................................................................................................... 29 12Node64G-Memory Performance ........................................................................................... 32 Yardstick Configuration .................................................................................................. 32 Results Summary ........................................................................................................... 32 Comparison Atomic Put Performance Of Each Configuration .................................................... 35 Comparison Atomic Put and Get Performance Of Each Configuration ....................................... 36 Comparison SQL Query Performance Of Each Configuration ..................................................... 37

Upload: others

Post on 20-May-2020

4 views

Category:

Documents


0 download

TRANSCRIPT

1

Category

1Node16G-MemoryPerformance..............................................................................................2YardstickConfiguration....................................................................................................2ResultsSummary.............................................................................................................22Node16G-MemoryPerformance..............................................................................................5YardstickConfiguration....................................................................................................5ResultsSummary.............................................................................................................54Node16G-MemoryPerformance..............................................................................................8YardstickConfiguration....................................................................................................8ResultsSummary.............................................................................................................84Node32G-MemoryPerformance............................................................................................11YardstickConfiguration..................................................................................................11ResultsSummary...........................................................................................................114Node64G-MemoryPerformance............................................................................................14YardstickConfiguration..................................................................................................14ResultsSummary...........................................................................................................148Node16G-MemoryPerformance............................................................................................17YardstickConfiguration..................................................................................................17ResultsSummary...........................................................................................................178Node32G-MemoryPerformance............................................................................................20YardstickConfiguration..................................................................................................20ResultsSummary...........................................................................................................208Node64G-MemoryPerformance............................................................................................23YardstickConfiguration..................................................................................................23ResultsSummary...........................................................................................................2312Node16G-MemoryPerformance...........................................................................................26YardstickConfiguration..................................................................................................26ResultsSummary...........................................................................................................2612Node32G-MemoryPerformance...........................................................................................29YardstickConfiguration..................................................................................................29ResultsSummary...........................................................................................................2912Node64G-MemoryPerformance...........................................................................................32YardstickConfiguration..................................................................................................32ResultsSummary...........................................................................................................32ComparisonAtomicPutPerformanceOfEachConfiguration....................................................35ComparisonAtomicPutandGetPerformanceOfEachConfiguration.......................................36ComparisonSQLQueryPerformanceOfEachConfiguration.....................................................37

2

Performaceof1-Node(Local)16G-MemoryofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,1Server

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 16G

ResultsSummary

Forallbenchmarks,onelocalnodewasconfiguredwith128clientthreadsandatest

durationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 141,292 0.907

Atomic Put and Get 122,674 1.045

SQL Query 205,933 0.621

3

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredinlocalcache.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately155,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 141,292 120,446 154,847 6,071

Latency (microseconds)

0.907 0.826 1.062 40,013

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromlocalcache.ü ResultsSummaryResultsshowthatmorethan122,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviation Throughput

(Operations/sec) 122,674 105,255 145,420 5,532

Latency (microseconds)

1.045 0.881 1.216 47,781

4

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonlocalcache.ü ResultsSummaryResultsshowathroughputofapproximately207,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec)206,933 194,855 217,628 4,103

Latency(microseconds)

0.621 0.588 0.656 12,366

5

Performaceof2-Node16G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,2Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 16G

ResultsSummary

Forallbenchmarks,onelocalnodeandoneremotenodeswereconfiguredwith128client

threadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 273,611 0.469

Atomic Put and Get 139,708 0.918

SQL Query 180,182 0.710

6

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately308,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 273,611 226,785 308,689 16,948

Latency (microseconds)

0.469 0.414 0.564 29,512

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan140,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviation Throughput

(Operations/sec) 139,708 12,286 153,888 6,476

Latency (microseconds)

0.918 0831 1.036 42,946

7

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately180,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec)180,182 170,263 188,400 3,650

Latency(microseconds)

0,710 0,679 0,751 14,586

8

Performaceof4-Node16G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,4Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 16G

ResultsSummary

Forallbenchmarks,onelocalnodeandthreeremotenodeswereconfiguredwith128client

threadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 492,071 0.260

Atomic Put and Get 251,984 0.507

SQL Query 148,230 0.863

9

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately540,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 492,071 405,466 541,302 24,174

Latency (microseconds)

0.26 0.235 0.315 13,703

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan250,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviation Throughput

(Operations/sec) 251,984 223,230 270,687 8,018

Latency (microseconds)

0.507 0.472 0.572 16,310

10

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately148,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec)148,230 128,248 152,610 2,207

Latency(microseconds)

0.863 0.83. 0.997 13,609

11

Performaceof4-Node32G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,4Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 32G

ResultsSummary

Forallbenchmarks,onelocalnodeandthreeremotenodeswereconfiguredwith128client

threadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 482,847 0.265

Atomic Put and Get 251,546 0.509

SQL Query 145,040 0.882

12

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately530,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec)

482,847 374,875 530,387 24,692

Latency(microseconds)

0.265 0.241 0.341 14,147

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan250,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec)

251,546 215,996 273,344 8,760

Latency(microseconds)

0.509 0.467 0.592 18,144

13

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately145,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec)145,040 140,891 151,975 1,930

Latency(microseconds)

0.882 0.839 0.908 11,766

14

Performaceof4-Node64G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,4Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 64G

ResultsSummary

Forallbenchmarks,onelocalnodeandthreeremotenodeswereconfiguredwith128client

threadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 497,690 0.257

Atomic Put and Get 250,700 0.511

SQL Query 128,830 0.993

15

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately545,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec)

497,590 417,521 545,349 23,600

Latency(microseconds)

0.257 0.234 0.306 12,575

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan250,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec)

250,700 227,475 272,109 8,123

Latency(microseconds)

0.511 0.475 0.562 16,866

16

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately129,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec) 128,831 119,808 132,623 1,392

Latency (microseconds)

0.993 0.964 1.067 10,774

17

Performaceof8-Node16G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,8Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 16G

ResultsSummary

Forallbenchmarks,onelocalnodeandsevenremotenodeswereconfiguredwith128client

threadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 555,799 0.230

Atomic Put and Get 266,569 0.480

SQL Query 85,862 1.491

18

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately600,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 555,799 461,881 607,534 26,893

Latency (microseconds)

0.230 0.210 0.276 11,510

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan260,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec) 266,569 207,614 285,009 9,347

Latency (microseconds)

0.480 0.449 0.616 18,069

19

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately85,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec) 85,862 76,170 92,095 1,680

Latency (microseconds)

1.491 1.389 1.680 30,248

20

Performaceof8-Node32G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,8Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 32G

ResultsSummary

Forallbenchmarks,onelocalnodeandsevenremotenodeswereconfiguredwith128client

threadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 536,710 0.238

Atomic Put and Get 272,616 0.469

SQL Query 70,760 1.809

21

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately600,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 536,710 447,287 592,971 24,197

Latency (microseconds)

0.238 0.217 0.288 11,561

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan270,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec) 272,616 226,909 290,124 9,000

Latency (microseconds)

0.469 0.438 0.572 16,587

22

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately70,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec) 70,760 68,406 72,427 738

Latency (microseconds)

1.809 1.767 1.870 18,961

23

Performaceof8-Node64G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,8Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 64G

ResultsSummary

Forallbenchmarks,onelocalnodeandsevenremotenodeswereconfiguredwith128client

threadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 542,054 0.236

Atomic Put and Get 272,840 0.469

SQL Query 88,922 1.439

24

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately600,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 542,054 444,897 598,469 24,137

Latency (microseconds)

0.236 0.213 0.271 10,819

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan270,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec) 272,840 238,594 295,637 8,704

Latency (microseconds)

0.469 0.432 0.535 15,365

25

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately89,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec) 88,922 86,017 91,417 982

Latency (microseconds)

1.439 1.399 1.487 16,032

26

Performaceof12-Node16G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,12Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 16G

ResultsSummary

Forallbenchmarks,onelocalnodeandelevenremotenodeswereconfiguredwith128

clientthreadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 572,521 0.223

Atomic Put and Get 293,810 0.435

SQL Query 54,987 2.328

27

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately630,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 572,521 420,017 627,830 31,217

Latency (microseconds)

0.224 0.203 0.305 13,303

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan290,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec) 293,810 250,607 312,756 9,613

Latency (microseconds)

0.435 0.409 0.493 14,748

28

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately55,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec) 54,987 51,757 67447 777

Latency (microseconds)

2.328 2.267 2.473 32,090

29

Performaceof12-Node32G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,12Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 32G

ResultsSummary

Forallbenchmarks,onelocalnodeandelevenremotenodeswereconfiguredwith128

clientthreadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 566,031 0.226

Atomic Put and Get 290,982 0.440

SQL Query 56,317 2.273

30

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately620,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 566,031 452,708 619,485 28,057

Latency (microseconds)

0.226 0.204 0.279 11,829

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan290,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec) 290,982 225,438 310,816 10,797

Latency (microseconds)

0.440 0.411 0.567 17,283

31

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately56,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec) 56,317 52,747 58,074 908

Latency (microseconds)

2.273 2.203 2.426 37,267

32

Performaceof12-Node64G-MemoryClusterofIgnite

HardwareSpecification

Specification Description

CPU Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz

RAM 738GB

YardstickConfiguration

IgnitewasbenchmarkedusingYardstickframeworkwiththeconfigurationbelow.

YardstickConfiguration

Node 1Client,12Servers

Threads 128

Backup 0

JDK 1.8.0_121-b13

Off-heap Memory 64G

ResultsSummary

Forallbenchmarks,onelocalnodeandelevenremotenodeswereconfiguredwith128

clientthreadsandatestdurationof300sec.

BenchmarkName Throughput,Opt/Sec Latency,ms

Atomic Put 554,634 0.231

Atomic Put and Get 290,432 0.441

SQL Query 57,462 2.228

33

Ø AtomicPutBenchmarkBenchmarksatomicdistributedcacheputoperationinIgnite.Randomlygeneratedkey-valuepairsarestoredincacheonmultiplenodes.ü ResultsSummaryResultsshowthatatomiccacheputoperationsinIgniteperformedexceptionallywellwithapproximately620,000operationspersecond.

Avg Min Max StdDeviationThroughput

(Operations/sec) 554,634 395,113 620,115 40,473

Latency (microseconds)

0.232 0.206 0.324 19,866

Ø AtomicPutandGetBenchmarkBenchmarksatomicdistributedcacheputandgetoperationsinIgnite.Randomlygeneratedkey-valuepairsarestoredandretrievedfromcacheonmultiplenodes.ü ResultsSummaryResultsshowthatmorethan290,000cacheputandgetoperationspersecondcanbeperformedinIgnite.

Avg Min Max StdDeviationThroughput

(Operations/sec) 290,432 213,873 307,069 10,546

Latency (microseconds)

0.441 0.415 0.598 18,003

34

Ø SQLQueryBenchmarkBenchmarksdistributedSQLqueryoperationoncacheddata.AsimpleSQLquerywasexecutedonthedatastoredonmultiplenodesinaPARTITIONEDcache.ü ResultsSummaryResultsshowathroughputofapproximately57,000SQLbasedcachequeryoperationspersecond,whichproveshowquicklydatacanberetrievedfromIn-MemoryDataGridthroughcachequeriesinIGNITE.

Avg Min Max StdDeviationThroughput

(Operations/sec) 57,462 53,312 59,059 864

Latency (microseconds)

2.228 2.167 2.500 34,322

35

ComparisonbetweeneachConfigurationØ AtomicPut

Configuration Operations/sec Latency/msec

1Node16G 141,292 0.906

2Node16G 273,611 0.469

4Node16G 492,071 0.260

4Node32G 482,847 0.265

4Node64G 497,690 0.257

8Node16G 555,799 0.230

8Node32G 536,710 0.238

8Node64G 542,054 0.236

12Node16G 572,521 0.224

12Node32G 566,031 0.226

12Node64G 554,634 0.231

141,292

273,611

492,071 482,847 497,690555,799

536,710 542,054 572,521566,031 554,634

0100,000200,000300,000400,000500,000600,000700,000

AtomicPutOperations/sec

0.906

0.469

0.26 0.265 0.257 0.23 0.238 0.236 0.224 0.226 0.231

0

0.2

0.4

0.6

0.8

1AtomicPutLatency/msec

36

Ø AtomicPutandGet

Configuration Operations/sec Latency/msec

1Node16G 122,674 1.045

2Node16G 139,708 0.918

4Node16G 251,874 0.508

4Node32G 251,546 0.509

4Node64G 250,700 0.510

8Node16G 266,569 0.480

8Node32G 272,616 0.469

8Node64G 272,840 0.469

12Node16G 293,810 0.435

12Node32G 290,982 0.440

12Node64G 290,432 0.441

122,674 139,708

251,874 251,546 250,700 266,569 272,616 272,840293,810 290,982 290,432

050000

100000150000200000250000300000350000

AtomicPutandGetOperations/sec

1.0450.918

0.508 0.509 0.510.48 0.469 0.469 0.435 0.44 0.441

0

0.2

0.4

0.6

0.8

1

1.2AtomicPutandGetLatency/msec

37

Ø SQLQuery

Configuration Operations/sec Latency/msec

1Node16G 205,933 0.621

2Node16G 180,182 0.710

4Node16G 148,230 0.863

4Node32G 145,040 0.882

4Node64G 128,831 0.993

8Node16G 85,862 1.490

8Node32G 70,760 1.809

8Node64G 88,922 1.439

12Node16G 54,987 2.328

12Node32G 56,317 2.273

12Node64G 57,462 2.228

205,933180,182

148,230145,040128,831

85,86270,760

88,92254,987 56,317 57,462

0

50000

100000

150000

200000

250000SQLQueryOperations/sec

0.621 0.71 0.863 0.8820.993

1.491.809

1.439

2.3282.273 2.228

0

0.5

1

1.5

2

2.5SQLQueryLatency/msec