« DBMS/MySQL/DRBD » : différence entre les versions

De TartareFR
Aller à la navigation Aller à la recherche
Aucun résumé des modifications
Ligne 3 308 : Ligne 3 308 :
|+ Benchmark - 1 thread
|+ Benchmark - 1 thread
! colspan="2" |  
! colspan="2" |  
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=8
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
|-
|-
| colspan="2" | '''OLTP test statistics'''
| colspan="2" | '''OLTP test statistics'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |Queries performed
| colspan="2" |Queries performed
|
|  
|  
|  
|  
Ligne 3 321 : Ligne 3 324 :
|  
|  
| read
| read
| 122570
| 122836
| 580174
| 580174
| 122766
|-
|-
|  
|  
| write
| write
| 43775
| 43870
| 207205
| 207205
| 43845
|-
|-
|  
|  
| other
| other
| 17510
| 17548
| 82882
| 82882
| 17538
|-
|-
|  
|  
| total
| total
| 183855
| 184254
| 870261
| 870261
| 184149
|-
|-
| colspan="2" |transactions
| colspan="2" |transactions
| 8755 ( 72.96/s )
| 8774 ( 73.11/s )
| 41441 ( 345.33/s )
| 41441 ( 345.33/s )
| 8769 ( 73.07/s )
|-
|-
| colspan="2" |deadlocks
| colspan="2" |deadlocks
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
|-
|-
| colspan="2" |R/w requests
| colspan="2" |R/w requests
| 166345 ( 1386.16/s )
| 166706 ( 1389.11/s )
| 787379 ( 6561.36/s )
| 787379 ( 6561.36/s )
| 166611 ( 1388.31/s )
|-
|-
| colspan="2" |Other operations
| colspan="2" |Other operations
| 17510 ( 145.91/s )
| 17548 ( 146.22/s )
| 82882 ( 690.67/s )
| 82882 ( 690.67/s )
| 17538 ( 146.14/s )
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Test execution summary'''
| colspan="2" |'''Test execution summary'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |total time
| colspan="2" |total time
| 120.0044s
| 120.0090s
| 120.0025s
| 120.0025s
| 120.0100s
|-
|-
| colspan="2" |total number of events
| colspan="2" |total number of events
| 8755
| 8774
| 41441
| 41441
| 8769
|-
|-
| colspan="2" |total time taken by event execution
| colspan="2" |total time taken by event execution
| 119.9291
| 119.9347
| 119.7836
| 119.7836
| 119.9339
|-
|-
| colspan="2" |per-request statistics
| colspan="2" |per-request statistics
|
|  
|  
|  
|  
Ligne 3 381 : Ligne 3 398 :
|  
|  
| min
| min
| 9.95ms
| 5.79ms
| 2.27ms
| 2.27ms
| 9.53ms
|-
|-
|  
|  
| avg
| avg
| 13.70ms
| 13.67ms
| 2.89ms
| 2.89ms
| 13.68ms
|-
|-
|  
|  
| max
| max
| 109.11ms
| 105.31ms
| 90.26ms
| 90.26ms
| 77.90ms
|-
|-
|  
|  
| Approx. 95%
| Approx. 95%
| 15.01ms
| 14.99ms
| 3.68ms
| 3.68ms
| 15.00ms
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Threads fairness'''
| colspan="2" |'''Threads fairness'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |events (avg/stddev)
| colspan="2" |events (avg/stddev)
| 8755.0000/0.00
| 8774.0000/0.00
| 41441.0000/0.00
| 41441.0000/0.00
| 8769.0000/0.00
|-
|-
| colspan="2" |execution time (avg/stddev)
| colspan="2" |execution time (avg/stddev)
| 119.9291/0.00
| 119.9347/0.00
| 119.7836/0.00
| 119.7836/0.00
| 119.9339/0.00
|}
|}


Ligne 3 419 : Ligne 3 444 :


{| class="wikitable"
{| class="wikitable"
|+ Benchmark - 8 threads
|+ Benchmark - 1 thread
! colspan="2" |  
! colspan="2" |  
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=8
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
|-
|-
| colspan="2" | '''OLTP test statistics'''
| colspan="2" | '''OLTP test statistics'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |Queries performed
| colspan="2" |Queries performed
|
|  
|  
|  
|  
Ligne 3 434 : Ligne 3 462 :
|  
|  
| read
| read
| 182294
| 181636
| 3032820
| 3032820
| 181930
|-
|-
|  
|  
| write
| write
| 65105
| 64870
| 1083150
| 1083150
| 64975
|-
|-
|  
|  
| other
| other
| 26042
| 25948
| 433260
| 433260
| 25990
|-
|-
|  
|  
| total
| total
| 273441
| 272454
| 4549230
| 4549230
| 272895
|-
|-
| colspan="2" |transactions
| colspan="2" |transactions
| 13021 ( 108.45/s )
| 12974 ( 108.05/s )
| 216630 ( 1805.20/s )
| 216630 ( 1805.20/s )
| 12995 ( 108.24/s )
|-
|-
| colspan="2" |deadlocks
| colspan="2" |deadlocks
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
|-
|-
| colspan="2" |R/w requests
| colspan="2" |R/w requests
| 247399 ( 2060.46/s )
| 246506 ( 2053.02/s )
| 4115970 ( 34298.87/s )
| 4115970 ( 34298.87/s )
| 246905 ( 2056.55/s )
|-
|-
| colspan="2" |Other operations
| colspan="2" |Other operations
| 26042 ( 216.89/s )
| 25948 ( 216.11/s )
| 433260 ( 3610.41/s )
| 433260 ( 3610.41/s )
| 25990 ( 216.48/s )
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Test execution summary'''
| colspan="2" |'''Test execution summary'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |total time
| colspan="2" |total time
| 120.0700s
| 120.0698s
| 120.0031s
| 120.0031s
| 120.0579s
|-
|-
| colspan="2" |total number of events
| colspan="2" |total number of events
| 13021
| 12974
| 216630
| 216630
| 12995
|-
|-
| colspan="2" |total time taken by event execution
| colspan="2" |total time taken by event execution
| 960.1908
| 960.1830
| 958.6631
| 958.6631
| 960.0874
|-
|-
| colspan="2" |per-request statistics
| colspan="2" |per-request statistics
|
|  
|  
|  
|  
Ligne 3 494 : Ligne 3 536 :
|  
|  
| min
| min
| 14.91ms
| 13.99ms
| 2.86ms
| 2.86ms
| 12.75ms
|-
|-
|  
|  
| avg
| avg
| 73.74ms
| 74.01ms
| 4.43ms
| 4.43ms
| 73.88ms
|-
|-
|  
|  
| max
| max
| 220.50ms
| 204.61ms
| 103.85ms
| 103.85ms
| 233.43ms
|-
|-
|  
|  
| Approx. 95%
| Approx. 95%
| 82.94ms
| 83.07ms
| 5.37ms
| 5.37ms
| 83.94ms
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Threads fairness'''
| colspan="2" |'''Threads fairness'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |events (avg/stddev)
| colspan="2" |events (avg/stddev)
| 1627.6250/4.53
| 1621.7500/3.93
| 27078.7500/204.62
| 27078.7500/204.62
| 1624.3750/6.76
|-
|-
| colspan="2" |execution time (avg/stddev)
| colspan="2" |execution time (avg/stddev)
| 120.0239/0.02
| 120.0229/0.02
| 119.8329/0.00
| 119.8329/0.00
| 120.0109/0.02
|}
|}


Ligne 3 532 : Ligne 3 582 :


{| class="wikitable"
{| class="wikitable"
|+ Benchmark - 16 threads
|+ Benchmark - 1 thread
! colspan="2" |  
! colspan="2" |  
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=8
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
|-
|-
| colspan="2" | '''OLTP test statistics'''
| colspan="2" | '''OLTP test statistics'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |Queries performed
| colspan="2" |Queries performed
|
|  
|  
|  
|  
Ligne 3 547 : Ligne 3 600 :
|  
|  
| read
| read
| 182294
| 182294
| 3324300
| 3324300
| 182378
|-
|-
|  
|  
| write
| write
| 65105
| 65105
| 1187250
| 1187250
| 65135
|-
|-
|  
|  
| other
| other
| 26042
| 26042
| 474900
| 474900
| 26054
|-
|-
|  
|  
| total
| total
| 273441
| 273441
| 4986450
| 4986450
| 273567
|-
|-
| colspan="2" |transactions
| colspan="2" |transactions
| 13021 ( 108.38/s )
| 13021 ( 108.38/s )
| 237450 ( 1978.67/s )
| 237450 ( 1978.67/s )
| 13027 ( 108.43/s )
|-
|-
| colspan="2" |deadlocks
| colspan="2" |deadlocks
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
|-
|-
| colspan="2" |R/w requests
| colspan="2" |R/w requests
| 247399 ( 2059.24/s )
| 247399 ( 2059.25/s )
| 4511550 ( 37594.79/s )
| 4511550 ( 37594.79/s )
| 247513 ( 2060.13/s )
|-
|-
| colspan="2" |Other operations
| colspan="2" |Other operations
| 26042 ( 216.76/s )
| 26042 ( 216.76/s )
| 474900 ( 3957.35/s )
| 474900 ( 3957.35/s )
| 26054 ( 216.86/s )
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Test execution summary'''
| colspan="2" |'''Test execution summary'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |total time
| colspan="2" |total time
| 120.1411s
| 120.1403s
| 120.0047s
| 120.0047s
| 120.1445s
|-
|-
| colspan="2" |total number of events
| colspan="2" |total number of events
| 13021
| 13021
| 237450
| 237450
| 13027
|-
|-
| colspan="2" |total time taken by event execution
| colspan="2" |total time taken by event execution
| 1921.0365
| 1921.0108
| 1918.4203
| 1918.4203
| 1921.0979
|-
|-
| colspan="2" |per-request statistics
| colspan="2" |per-request statistics
|
|  
|  
|  
|  
Ligne 3 607 : Ligne 3 674 :
|  
|  
| min
| min
| 11.76ms
| 15.04ms
| 3.64ms
| 3.64ms
| 12.75ms
|-
|-
|  
|  
| avg
| avg
| 147.53ms
| 147.53ms
| 8.08ms
| 8.08ms
| 147.47ms
|-
|-
|  
|  
| max
| max
| 368.45ms
| 339.62ms
| 117.54ms
| 117.54ms
| 363.63ms
|-
|-
|  
|  
| Approx. 95%
| Approx. 95%
| 157.91ms
| 158.00ms
| 9.85ms
| 9.85ms
| 159.05ms
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Threads fairness'''
| colspan="2" |'''Threads fairness'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |events (avg/stddev)
| colspan="2" |events (avg/stddev)
| 813.8125/2.35
| 813.8125/2.16
| 14840.6250/71.63
| 14840.6250/71.63
| 814.1875/1.94
|-
|-
| colspan="2" |execution time (avg/stddev)
| colspan="2" |execution time (avg/stddev)
| 120.0648/0.04
| 120.0632/0.04
| 119.9013/0.00
| 119.9013/0.00
| 120.0686/0.04
|}
|}


Ligne 3 645 : Ligne 3 720 :


{| class="wikitable"
{| class="wikitable"
|+ Benchmark - 24 threads
|+ Benchmark - 1 thread
! colspan="2" |  
! colspan="2" |  
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=8
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
|-
|-
| colspan="2" | '''OLTP test statistics'''
| colspan="2" | '''OLTP test statistics'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |Queries performed
| colspan="2" |Queries performed
|
|  
|  
|  
|  
Ligne 3 660 : Ligne 3 738 :
|  
|  
| read
| read
| 183638
| 183806
| 2882950
| 2882950
| 182938
|-
|-
|  
|  
| write
| write
| 65585
| 65645
| 1029625
| 1029625
| 65335
|-
|-
|  
|  
| other
| other
| 26234
| 26258
| 411850
| 411850
| 26134
|-
|-
|  
|  
| total
| total
| 275457
| 275709
| 4324425
| 4324425
| 274407
|-
|-
| colspan="2" |transactions
| colspan="2" |transactions
| 13117 ( 109.12/s )
| 13129 ( 109.22/s )
| 205925 ( 1715.92/s )
| 205925 ( 1715.92/s )
| 13067 ( 108.71/s )
|-
|-
| colspan="2" |deadlocks
| colspan="2" |deadlocks
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
|-
|-
| colspan="2" |R/w requests
| colspan="2" |R/w requests
| 249223 ( 2073.22/s )
| 249451 ( 2075.09/s )
| 3912575 ( 32602.51/s )
| 3912575 ( 32602.51/s )
| 248273 ( 2065.45/s )
|-
|-
| colspan="2" |Other operations
| colspan="2" |Other operations
| 26234 ( 218.23/s )
| 26258 ( 218.43/s )
| 411850 ( 3431.84/s )
| 411850 ( 3431.84/s )
| 26134 ( 217.42/s )
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Test execution summary'''
| colspan="2" |'''Test execution summary'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |total time
| colspan="2" |total time
| 120.2108s
| 120.2123s
| 120.0084s
| 120.0084s
| 120.2026s
|-
|-
| colspan="2" |total number of events
| colspan="2" |total number of events
| 13117
| 13129
| 205925
| 205925
| 13067
|-
|-
| colspan="2" |total time taken by event execution
| colspan="2" |total time taken by event execution
| 2882.3766
| 2882.3590
| 2878.4305
| 2878.4305
| 2882.2478
|-
|-
| colspan="2" |per-request statistics
| colspan="2" |per-request statistics
|
|  
|  
|  
|  
Ligne 3 720 : Ligne 3 812 :
|  
|  
| min
| min
| 12.87ms
| 12.83ms
| 2.73ms
| 2.73ms
| 11.80ms
|-
|-
|  
|  
| avg
| avg
| 219.74ms
| 219.54ms
| 13.98ms
| 13.98ms
| 220.57ms
|-
|-
|  
|  
| max
| max
| 554.02ms
| 543.23ms
| 1984.98ms
| 1984.98ms
| 612.97ms
|-
|-
|  
|  
| Approx. 95%
| Approx. 95%
| 231.29ms
| 230.05ms
| 19.64ms
| 19.64ms
| 232.89ms
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Threads fairness'''
| colspan="2" |'''Threads fairness'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |events (avg/stddev)
| colspan="2" |events (avg/stddev)
| 546.5417/1.91
| 547.0417/1.62
| 8580.2083/25.88
| 8580.2083/25.88
| 544.4583/2.02
|-
|-
| colspan="2" |execution time (avg/stddev)
| colspan="2" |execution time (avg/stddev)
| 120.0990/0.06
| 120.0983/0.06
| 119.9346/0.00
| 119.9346/0.00
| 120.0937/0.06
|}
|}


Ligne 3 758 : Ligne 3 858 :


{| class="wikitable"
{| class="wikitable"
|+ Benchmark - 32 threads
|+ Benchmark - 1 thread
! colspan="2" |  
! colspan="2" |  
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=8
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=16
! test4 sur neo-drbd<br>avec binlog et lecture écriture<br>innodb_thread_concurrency=0
|-
|-
| colspan="2" | '''OLTP test statistics'''
| colspan="2" | '''OLTP test statistics'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |Queries performed
| colspan="2" |Queries performed
|
|  
|  
|  
|  
Ligne 3 773 : Ligne 3 876 :
|  
|  
| read
| read
| 182560
| 182406
| 2458414
| 2458414
| 182504
|-
|-
|  
|  
| write
| write
| 65200
| 65145
| 878005
| 878005
| 65180
|-
|-
|  
|  
| other
| other
| 26080
| 26058
| 351202
| 351202
| 26072
|-
|-
|  
|  
| total
| total
| 273840
| 273609
| 3687621
| 3687621
| 273756
|-
|-
| colspan="2" |transactions
| colspan="2" |transactions
| 13040 ( 108.41/s )
| 13029 ( 108.32/s )
| 175601 ( 1463.09/s )
| 175601 ( 1463.09/s )
| 13036 ( 108.38/s )
|-
|-
| colspan="2" |deadlocks
| colspan="2" |deadlocks
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
| 0 ( 0.00/s )
|-
|-
| colspan="2" |R/w requests
| colspan="2" |R/w requests
| 247760 ( 2059.78/s )
| 247551 ( 2058.16/s )
| 3336419 ( 27798.74/s )
| 3336419 ( 27798.74/s )
| 247684 ( 2059.31/s )
|-
|-
| colspan="2" |Other operations
| colspan="2" |Other operations
| 26080 ( 216.82/s )
| 26058 ( 216.65/s )
| 351202 ( 2926.18/s )
| 351202 ( 2926.18/s )
| 26072 ( 216.77/s )
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Test execution summary'''
| colspan="2" |'''Test execution summary'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |total time
| colspan="2" |total time
| 120.2847s
| 120.2779s
| 120.0205s
| 120.0205s
| 120.2753s
|-
|-
| colspan="2" |total number of events
| colspan="2" |total number of events
| 13040
| 13029
| 175601
| 175601
| 13036
|-
|-
| colspan="2" |total time taken by event execution
| colspan="2" |total time taken by event execution
| 3844.4770
| 3844.2389
| 3838.5338
| 3838.5338
| 3844.1409
|-
|-
| colspan="2" |per-request statistics
| colspan="2" |per-request statistics
|
|  
|  
|  
|  
Ligne 3 833 : Ligne 3 950 :
|  
|  
| min
| min
| 12.85ms
| 15.07ms
| 4.60ms
| 4.60ms
| 18.98ms
|-
|-
|  
|  
| avg
| avg
| 294.82ms
| 295.05ms
| 21.86ms
| 21.86ms
| 294.89ms
|-
|-
|  
|  
| max
| max
| 607.42ms
| 862.65ms
| 150.82ms
| 150.82ms
| 670.98ms
|-
|-
|  
|  
| Approx. 95%
| Approx. 95%
| 307.83ms
| 308.93ms
| 33.14ms
| 33.14ms
| 309.03ms
|-
|-
| colspan="2" style="background-color:black;" |
| colspan="2" style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
| style="background-color:black;" |
|-
|-
| colspan="2" |'''Threads fairness'''
| colspan="2" |'''Threads fairness'''
|
|  
|  
|  
|  
|-
|-
| colspan="2" |events (avg/stddev)
| colspan="2" |events (avg/stddev)
| 407.5000/1.32
| 407.1562/1.20
| 5487.5312/15.42
| 5487.5312/15.42
| 407.3750/1.75
|-
|-
| colspan="2" |execution time (avg/stddev)
| colspan="2" |execution time (avg/stddev)
| 120.1399/0.08
| 120.1325/0.08
| 119.9542/0.01
| 119.9542/0.01
| 120.1294/0.08
|}
|}

Version du 12 janvier 2013 à 10:34

Introduction

DRBD est une technologie de Raid1 sur IP. C'est à dire que tous ce qui sera écrit sur la partition DRBD d'un noeud, le sera automatiquement sur sa partition jumelle sur l'autre noeud.

DRBD fonctionnant au niveau bloc, il faut un disque ou une partition dédiée à cela. Celle-ci n’a pas besoin (et ne doit pas) d’être formaté.

Depuis CentOS 6, les paquets DRBD ne sont plus dans les dépots de base, il faut donc ajouter ceux de atRPMS. Pour ce faire, ajouter le fichier <path>/etc/yum.repos.d/atrpms.repo</path> contenant ceci : 

[atrpms]
name=CentOS $releasever - $basearch - ATrpms
baseurl=http://dl.atrpms.net/el$releasever-$basearch/atrpms/stable
gpgkey=http://atrpms.net/RPM-GPG-KEY.atrpms
gpgcheck=1


Prérequis:

  • Ouverture du firewall pour le port tcp:7789 pour le LAN. On part du principe que toute connexion déjà établie est autorisée.
     -A RH-Firewall-1-INPUT -m state --state NEW -s 192.168.0.0/24 -d 192.168.0.0/24 -m tcp -p tcp --dport 7789 -j ACCEPT
  • SELinux est désactivé
  • Ajout des hôtes dans le fichier <path>/etc/hosts</path>
    192.168.0.71    sql1-didier     sql1-didier.b2pweb.com
    192.168.0.72    sql2-didier     sql2-didier.b2pweb.com

Schéma

MySQL-DRBD-Schema.png

Installation

Installation de drbd

On installe drbd ( utilitaires + module noyau ), puis on créer le volume logique qui accueillera notre partition drbd. 

# yum install drbd drbd-kmdl-2.6.32-279.19.1.el6.x86_64
Warning.png
Version de drbd-kmld
La version de <package>drbd-kmld</package> doit correspondre à celle du noyau en cours d'utilisation. Pour connaitre celle-ci:
uname -r

Fichier <path>/etc/drbd.conf</path> 

#
# /etc/drbd.conf
#
include "drbd.d/global_common.conf";
include "drbd.d/*.res";

Fichier <path>/etc/drbd.d/global_common.conf</path> 

global {
        usage-count yes;
        # minor-count dialog-refresh disable-ip-verification
}

common {
        protocol C;

        handlers {
                pri-on-incon-degr "/usr/lib/drbd/notify-pri-on-incon-degr.sh; /usr/lib/drbd/notify-emergency-reboot.sh; echo b > /proc/sysrq-trigger ; reboot -f";
                pri-lost-after-sb "/usr/lib/drbd/notify-pri-lost-after-sb.sh; /usr/lib/drbd/notify-emergency-reboot.sh; echo b > /proc/sysrq-trigger ; reboot -f";
                local-io-error "/usr/lib/drbd/notify-io-error.sh; /usr/lib/drbd/notify-emergency-shutdown.sh; echo o > /proc/sysrq-trigger ; halt -f";
                # fence-peer "/usr/lib/drbd/crm-fence-peer.sh";
                # split-brain "/usr/lib/drbd/notify-split-brain.sh root";
                # out-of-sync "/usr/lib/drbd/notify-out-of-sync.sh root";
                # before-resync-target "/usr/lib/drbd/snapshot-resync-target-lvm.sh -p 15 -- -c 16k";
                # after-resync-target /usr/lib/drbd/unsnapshot-resync-target-lvm.sh;
        }

        startup {
                # wfc-timeout degr-wfc-timeout outdated-wfc-timeout wait-after-sb
        }

        disk {
                # on-io-error fencing use-bmbv no-disk-barrier no-disk-flushes
                # no-disk-drain no-md-flushes max-bio-bvecs
        }

        net {
                # sndbuf-size rcvbuf-size timeout connect-int ping-int ping-timeout max-buffers
                # max-epoch-size ko-count allow-two-primaries cram-hmac-alg shared-secret
                # after-sb-0pri after-sb-1pri after-sb-2pri data-integrity-alg no-tcp-cork
        }

        syncer {
                # rate after al-extents use-rle cpu-mask verify-alg csums-alg
        }
}

Fichier <path>/etc/drbd.d/mysql.res</path> 

resource mysql {
        protocol C;
        net {
                cram-hmac-alg sha1;
                shared-secret "FuCk_ThE;@@System!";
                after-sb-0pri discard-older-primary;
                after-sb-1pri call-pri-lost-after-sb;
                after-sb-2pri call-pri-lost-after-sb;
        }
        disk {
                # because partition is on a lvm system
                no-disk-barrier;
        }
        startup {
                wfc-timeout 120;
                degr-wfc-timeout 120;
        }
        syncer {
                rate 100M;
                verify-alg "crc32c"; # Algorythm to tun "drbdadm verify"
        }
        on sql1-didier.b2pweb.com {
                device    /dev/drbd0;
                disk      /dev/vg0/lvmysql;
                address   192.168.0.71:7789;
                meta-disk internal;
        }
        on sql2-didier.b2pweb.com {
                device    /dev/drbd0;
                disk      /dev/vg0/lvmysql;
                address   192.168.0.72:7789;
                meta-disk internal;
        }
}

On copie la configuration sur l'autre noeud 

# scp /etc/drbd.conf sql2:/etc/
# scp /etc/drbd.d/* sql2:/etc/drbd.d/

Configuration de DRBD

Sur les deux noeuds, on créer la partition qui accueillera DRBD, ainsi que le point de montage ( sql1 + sql2 ) 

# lvcreate -n lvmysql -L 100G vg0

On exécute la commande suivante sur les deux noeuds ( sql1 + sql2 ) 

# drbdadm create-md mysql
md_offset 107374178304
al_offset 107374145536
bm_offset 107370868736

Found some data

 ==> This might destroy existing data! <==

Do you want to proceed?
[need to type 'yes' to confirm] yes

Writing meta data...
initializing activity log
NOT initialized bitmap
New drbd meta data block successfully created.
success

Démarrage du service drbd

On démarre le service drbd et on l'enlève à chkconfig sur les deux noeuds ( sql1 + sql2 ) 

# /etc/init.d/drbd start
# chkconfig drbd off

On note que le service drbd démarre en secondaire. On va donc forcer le primaire ( sql1 ) à se répliquer sur le secondaire ( sql2 ) pour ce premier démarrage.

La commande suivante n'est à lancer que sur le primaire ( sql1 ) 

# drbdadm -- --overwrite-data-of-peer primary mysql

Maintenant on va attendre que les partitions soient synchronisées. Ce que l'on peut vérifier par la commande : cat /proc/drbd. Vu la taille de notre partition ( 100Go ), ce peut être un peu long ( voir beaucoup ).

Ici, le processus n'est pas terminé. 

# cat /proc/drbd
version: 8.3.8 (api:88/proto:86-94)
GIT-hash: d78846e52224fd00562f7c225bcc25b2d422321d build by mockbuild@builder10.centos.org, 2010-06-04 08:04:09
 0: cs:SyncSource ro:Primary/Secondary ds:UpToDate/Inconsistent C r----
    ns:237568 nr:0 dw:0 dr:237568 al:0 bm:14 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:104616796
        [>....................] sync'ed:  0.3% (102164/102396)M delay_probe: 44
        finish: 2:39:28 speed: 10,816 (10,328) K/sec

Là, le processus est terminé 

# cat /proc/drbd
version: 8.3.8 (api:88/proto:86-94)
GIT-hash: d78846e52224fd00562f7c225bcc25b2d422321d build by mockbuild@builder10.centos.org, 2010-06-04 08:04:09
 0: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r---n
    ns:105395060 nr:0 dw:1780684 dr:103614448 al:849 bm:6400 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0

On ajoute cette ligne au fichier /etc/fstab pour le montage de notre partition drbd. Celle-ci ne sera pas montée automatiquement au boot mais soit à la main, soit avec heartbeat/corosync. A rajouter sur les deux noeuds ( mail3 + mail 4 ) 

/dev/drbd0              /var/lib/mysql             ext4    defaults,noauto 0 0

Installation de MySQL

Sur le serveur primaire ( sql1 ), avant l'installation de <package>MySQL-server</package>, on créer le répertoire <path>/var/lib/mysql</path>, ainsi qu'un système de fichier sur la partition drbd et et on monte la partition drbd 

mkfs -t ext4 -L datadir /dev/drbd0
mkdir -p /var/lib/mysql
mount /var/lib/mysql

Puis sur les deux serveurs, on installe 

yum install mysql-server MySQL-conf-prod mysql-client mysql-shared

Sur le secondaire ( sql2 ), le répertoire <path>/var/lib/mysql</path> n'a aucune importance. On supprime son contenu et on supprime le démarrage automatique du service. 

rm -rf /var/lib/mysql/*
chkconfig off mysql

Il s'agit simplement que le système soit informé de l'installation et que tous fichier externe à <path>/var/lib/mysql</path> soit installé/modifié.

Sur le serveur primaire ( sql1 ) On supprime le démarrage automatique du service, on initialise les service et on le démarre. 

chkconfig off mysql

mysql_install_db
mysql_secure_installation

/etc/init.d/mysql start

Test failover manuel

En l'état le service est hautement disponible à la manivelle.

Voici la marche à suivre:

Sur le primaire ( qui va devenir secondaire )

  1. Arrêt du service MySQL
    /etc/init.d/mysql stop
  2. Démontage de la partition
    umount /var/lib/mysql
  3. Passage en secondaire de la partition drbd
    drbdadm secondary mysql

Sur le secondaire ( qui va devenir primaire )

  1. Passage en primaire de la partition drbd
    drbdadm primary mysql
  2. Montage de la partition
    mount /var/lib/mysql
  3. Démarrage du service MySQL
    /etc/init.d/mysql start
  4. Test de mysql
    # mysql -p

SysBench

Le programme peut-être téléchargé sur sourceforge

Important.png
Régénération des scripts de construction
Il est obligatoire de régénérer les scripts de construction. On va donc avoir besoin des paquets <package>libtool</package> et <package>mysql-devel</package> 
yum install libtool mysql-devel

Ormis la régénération des scripts de construction, C'est du grand classique, on décompacte l'archive, on lance le script configure et on lance la compilation avec make 

tar xzf sysbench-0.4.12.tar.gz
cd sysbench-0.4.12
libtoolize --force --copy 
./autogen.sh   
./configure --with-mysql --with-gnu-ld --prefix=/usr/local
make
make install

Benchmark

Test effectués:

  1. sans binlog et lecture seule
  2. sans binlog et lecture écriture
  3. avec binlog et lecture seule
  4. avec binlog et lecture écriture
Note.png
Activation du binlog
Test avec binlog

Valeur des paramètres dans le fichier <path>/etc/my.cnf</path>

  • sync_binlog = 1
  • log-bin = /var/lib/mysql/mysql-bin
  • log-slave-updates

Test sans binlog

Les paramètres précédents sont commentés.

Préparation et lancement du bench

Création de la base de test et intialisation 

# mysql -p -e "CREATE DATABASE sbtest"
# sysbench --test=oltp --db-driver=mysql --mysql-host=localhost --mysql-user=root \
  --mysql-password=b2p2012web --mysql-db=sbtest --mysql-table-engine=innodb prepare \

Test 1: Read Only sans binlog

Test 3: Read Only avec binlog 

# sysbench --test=oltp --db-driver=mysql --num-threads=1 --mysql-host=localhost \
  --mysql-user=root --mysql-password=b2p2012web --mysql-db=sbtest --max-time=120 \
  --max-requests=0 --oltp-table-size=1000000 --oltp-read-only=on run

Test 2: Read Write sans binlog

Test 4: Read Write avec binlog 

# sysbench --test=oltp --db-driver=mysql --num-threads=1 --mysql-host=localhost \
  --mysql-user=root --mysql-password=b2p2012web --mysql-db=sbtest --max-time=120 \
  --max-requests=0 --oltp-table-size=1000000 --oltp-read-only=off run

Synthétisation des résultats

Comparatif entre les différentes méthodes de benchmark

Benchmark avec 1 threads
Benchmark - 1 thread
test1 sur cloud-drbd
sans binlog et lecture seule 		test2 sur cloud-drbd
sans binlog et lecture écriture 		test3 sur cloud-drbd
avec binlog et lecture seule 		test4 sur cloud-drbd
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 740124 571298 749770 570178
write 0 204035 0 203635
other 105732 81614 107110 81454
total 845856 856947 856880 855267
transactions 52866 ( 440.54/s ) 40807 ( 340.05/s ) 53555 ( 446.29/s ) 40727 ( 339.39/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 740124 ( 6167.58/s ) 775333 ( 6461.00/s ) 749770 ( 6248.01/s ) 773813 ( 6448.36/s )
Other operations 105732 ( 881.08/s ) 81614 ( 680.10/s ) 107110 ( 892.57/s ) 81454 ( 678.77/s )
Test execution summary
total time 120.0023s 120.0021s 120.0014s 120.0015s
total number of events 52866 40807 53555 40727
total time taken by event execution 119.7737 119.7826 119.7745 119.7867
per-request statistics
min 1.21ms 2.31ms 1.27ms 2.34ms
avg 2.27ms 2.94ms 2.24ms 2.94ms
max 4.96ms 64.70ms 9.67ms 83.73ms
Approx. 95% 2.70ms 3.63ms 2.57ms 3.73ms
Threads fairness
events (avg/stddev) 52866.0000/0.00 40807.0000/0.00 53555.0000/0.00 40727.0000/0.00
execution time (avg/stddev) 119.7737/0.00 119.7826/0.00 119.7745/0.00 119.7867/0.00
Benchmark avec 8 threads
Benchmark - 8 threads
test1 sur cloud-drbd
sans binlog et lecture seule 		test2 sur cloud-drbd
sans binlog et lecture écriture 		test3 sur cloud-drbd
avec binlog et lecture seule 		test4 sur cloud-drbd
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 1087716 2457560 1085882 2474724
write 0 877700 0 883830
other 155388 351080 155126 353532
total 1243104 3686340 1241008 3712086
transactions 77694 ( 647.42/s ) 175540 ( 1462.78/s ) 77563 ( 646.31/s ) 176766 ( 1473.01/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 1087716 ( 9063.86/s ) 3335260 ( 27792.91/s ) 1085882 ( 9048.38/s ) 3358554 ( 27987.21/s )
Other operations 155388 ( 1294.84/s ) 351080 ( 2925.57/s ) 155126 ( 1292.63/s ) 353532 ( 2946.02/s )
Test execution summary
total time 120.0059s 120.0040s 120.0085s 120.0032s
total number of events 77694 175540 77563 176766
total time taken by event execution 959.4963 959.0244 959.5030 959.0188
per-request statistics
min 3.29ms 2.25ms 3.35ms 2.17ms
avg 12.35ms 5.46ms 12.37ms 5.43ms
max 29.91ms 105.79ms 27.59ms 107.41ms
Approx. 95% 16.06ms 6.53ms 16.10ms 6.40ms
Threads fairness
events (avg/stddev) 9711.7500/8.10 21942.5000/31.26 9695.3750/21.27 22095.7500/35.03
execution time (avg/stddev) 119.9370/0.00 119.8780/0.00 119.9379/0.00 119.8773/0.00
Benchmark avec 16 threads
Benchmark - 16 threads
test1 sur cloud-drbd
sans binlog et lecture seule 		test2 sur cloud-drbd
sans binlog et lecture écriture 		test3 sur cloud-drbd
avec binlog et lecture seule 		test4 sur cloud-drbd
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 1068508 2501450 1069124 2501310
write 0 893375 0 893325
other 152644 357350 152732 357330
total 1221152 3752175 1221856 3751965
transactions 76322 ( 635.93/s ) 178675 ( 1488.90/s ) 76366 ( 636.31/s ) 178665 ( 1488.79/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 1068508 ( 8903.04/s ) 3394825 ( 28289.12/s ) 1069124 ( 8908.36/s ) 3394635 ( 28287.07/s )
Other operations 152644 ( 1271.86/s ) 357350 ( 2977.80/s ) 152732 ( 1272.62/s ) 357330 ( 2977.59/s )
Test execution summary
total time 120.0161s 120.0046s 120.0135s 120.0066s
total number of events 76322 178675 76366 178665
total time taken by event execution 1919.5903 1918.9951 1919.5624 1919.0151
per-request statistics
min 4.80ms 2.13ms 3.57ms 2.15ms
avg 25.15ms 10.74ms 25.14ms 10.74ms
max 60.41ms 128.60ms 50.98ms 138.31ms
Approx. 95% 33.80ms 21.46ms 33.67ms 21.71ms
Threads fairness
events (avg/stddev) 4770.1250/15.49 11167.1875/35.92 4772.8750/15.66 11166.5625/41.88
execution time (avg/stddev) 119.9744/0.00 119.9372/0.00 119.9727/0.00 119.9384/0.00
Benchmark avec 24 threads
Benchmark - 24 threads
test1 sur cloud-drbd
sans binlog et lecture seule 		test2 sur cloud-drbd
sans binlog et lecture écriture 		test3 sur cloud-drbd
avec binlog et lecture seule 		test4 sur cloud-drbd
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 1058134 2462236 1056776 2445100
write 0 879370 0 873250
other 151162 351748 150968 349300
total 1209296 3693354 1207744 3667650
transactions 75581 ( 629.72/s ) 175874 ( 1465.51/s ) 75484 ( 628.91/s ) 174650 ( 1455.33/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 1058134 ( 8816.02/s ) 3341606 ( 27844.62/s ) 1056776 ( 8804.71/s ) 3318350 ( 27651.25/s )
Other operations 151162 ( 1259.43/s ) 351748 ( 2931.01/s ) 150968 ( 1257.82/s ) 349300 ( 2910.66/s )
Test execution summary
total time 120.0240s 120.0090s 120.0240s 120.0072s
total number of events 75581 175874 75484 174650
total time taken by event execution 2879.7666 2879.0401 2879.7939 2879.0070
per-request statistics
min 7.04ms 2.17ms 5.86ms 2.19ms
avg 38.10ms 16.37ms 38.15ms 16.48ms
max 87.97ms 167.42ms 98.62ms 148.46ms
Approx. 95% 51.93ms 35.06ms 52.18ms 34.86ms
Threads fairness
events (avg/stddev) 3149.2083/9.58 7328.0833/33.68 3145.1667/8.74 7277.0833/37.14
execution time (avg/stddev) 119.9903/0.01 119.9600/0.00 119.9914/0.01 119.9586/0.00
Benchmark avec 32 threads
Benchmark - 32 threads
test1 sur cloud-drbd
sans binlog et lecture seule 		test2 sur cloud-drbd
sans binlog et lecture écriture 		test3 sur cloud-drbd
avec binlog et lecture seule 		test4 sur cloud-drbd
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 1048320 2406922 1048292 2394462
write 0 859615 0 855165
other 149760 343846 149756 342066
total 1198080 3610383 1198048 3591693
transactions 74880 ( 623.84/s ) 171923 ( 1432.55/s ) 74878 ( 623.84/s ) 171033 ( 1425.15/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 1048320 ( 8733.76/s ) 3266537 ( 27218.42/s ) 1048292 ( 8733.75/s ) 3249627 ( 27077.79/s )
Other operations 149760 ( 1247.68/s ) 343846 ( 2865.10/s ) 149756 ( 1247.68/s ) 342066 ( 2850.29/s )
Test execution summary
total time 120.0307s 120.0120s 120.0277s 120.0108s
total number of events 74880 171923 74878 171033
total time taken by event execution 3839.9916 3839.0820 3839.8516 3838.9952
per-request statistics
min 10.63ms 2.20ms 7.58ms 2.22ms
avg 51.28ms 22.33ms 51.28ms 22.45ms
max 107.53ms 180.54ms 107.18ms 191.84ms
Approx. 95% 70.58ms 46.13ms 70.60ms 46.21ms
Threads fairness
events (avg/stddev) 2340.0000/10.05 5372.5938/42.89 2339.9375/12.65 5344.7812/31.66
execution time (avg/stddev) 119.9997/0.01 119.9713/0.00 119.9954/0.01 119.9686/0.00

Comparaison entre les différentes plateformes (vm 4 coeurs)

Benchmark avec 1 threads
Benchmark - 1 thread
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 570178 605822 552020
write 203635 216365 197150
other 81454 86546 78860
total 855267 908733 828030
transactions 40727 ( 339.39/s ) 43273 ( 360.60/s ) 39430 ( 328.58/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 773813 ( 6448.36/s ) 822187 ( 6851.44/s ) 749170 ( 6243.07/s )
Other operations 81454 ( 678.77/s ) 86546 ( 721.20/s ) 78860 ( 657.17/s )
Test execution summary
total time 120.0015s 120.0020s 120.0002s
total number of events 40727 43273 39430
total time taken by event execution 119.7867 119.7467 119.7049
per-request statistics
min 2.34ms 2.13ms 1.84ms
avg 2.94ms 2.77ms 3.04ms
max 83.73ms 70.38ms 100.37ms
Approx. 95% 3.73ms 3.72ms 3.47ms
Threads fairness
events (avg/stddev) 40727.0000/0.00 43273.0000/0.00 39430.0000/0.00
execution time (avg/stddev) 119.7867/0.00 119.7467/0.00 119.7049/0.00
Benchmark avec 8 threads
Benchmark - 8 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2474724 2577792 4079264
write 883830 920640 1456880
other 353532 368256 582752
total 3712086 3866688 6118896
transactions 176766 ( 1473.01/s ) 184128 ( 1534.35/s ) 291376 ( 2428.08/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3358554 ( 27987.21/s ) 3498432 ( 29152.71/s ) 5536144 ( 46133.55/s )
Other operations 353532 ( 2946.02/s ) 368256 ( 3068.71/s ) 582752 ( 4856.16/s )
Test execution summary
total time 120.0032s 120.0037s 120.0025s
total number of events 176766 184128 291376
total time taken by event execution 959.0188 959.0014 956.9776
per-request statistics
min 2.17ms 2.14ms 1.80ms
avg 5.43ms 5.21ms 3.28ms
max 107.41ms 107.45ms 156.27ms
Approx. 95% 6.40ms 5.71ms 4.12ms
Threads fairness
events (avg/stddev) 22095.7500/35.03 23016.0000/42.44 36422.0000/242.19
execution time (avg/stddev) 119.8773/0.00 119.8752/0.00 119.6222/0.00
Benchmark avec 16 threads
Benchmark - 16 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2501310 2584554 7514948
write 893325 923055 2683910
other 357330 369222 1073564
total 3751965 3876831 11272422
transactions 178665 ( 1488.79/s ) 184611 ( 1538.35/s ) 536782 ( 4473.06/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3394635 ( 28287.07/s ) 3507609 ( 29228.65/s ) 10198858 ( 84988.18/s )
Other operations 357330 ( 2977.59/s ) 369222 ( 3076.70/s ) 1073564 ( 8946.12/s )
Test execution summary
total time 120.0066s 120.0059s 120.0032s
total number of events 178665 184611 536782
total time taken by event execution 1919.0151 1918.9869 1914.7307
per-request statistics
min 2.15ms 2.10ms 1.95ms
avg 10.74ms 10.39ms 3.57ms
max 138.31ms 136.00ms 451.13ms
Approx. 95% 21.71ms 20.66ms 4.23ms
Threads fairness
events (avg/stddev) 11166.5625/41.88 11538.1875/31.45 33548.8750/165.70
execution time (avg/stddev) 119.9384/0.00 119.9367/0.00 119.6707/0.00
Benchmark avec 24 threads
Benchmark - 24 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2445100 2592156 7315350
write 873250 925770 2612625
other 349300 370308 1045050
total 3667650 3888234 10973025
transactions 174650 ( 1455.33/s ) 185154 ( 1542.86/s ) 522525 ( 4353.89/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3318350 ( 27651.25/s ) 3517926 ( 29314.36/s ) 9927975 ( 82724.00/s )
Other operations 349300 ( 2910.66/s ) 370308 ( 3085.72/s ) 1045050 ( 8707.79/s )
Test execution summary
total time 120.0072s 120.0069s 120.0132s
total number of events 174650 185154 522525
total time taken by event execution 2879.0070 2878.9925 2874.5861
per-request statistics
min 2.19ms 2.08ms 2.03ms
avg 16.48ms 15.55ms 5.50ms
max 148.46ms 141.42ms 562.55ms
Approx. 95% 34.86ms 32.57ms 17.01ms
Threads fairness
events (avg/stddev) 7277.0833/37.14 7714.7500/30.11 21771.8750/286.75
execution time (avg/stddev) 119.9586/0.00 119.9580/0.00 119.7744/0.01
Benchmark avec 32 threads
Benchmark - 32 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2394462 2585310 7250166
write 855165 923325 2589345
other 342066 369330 1035738
total 3591693 3877965 10875249
transactions 171033 ( 1425.15/s ) 184665 ( 1538.72/s ) 517869 ( 4315.28/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3249627 ( 27077.79/s ) 3508635 ( 29235.63/s ) 9839511 ( 81990.34/s )
Other operations 342066 ( 2850.29/s ) 369330 ( 3077.43/s ) 1035738 ( 8630.56/s )
Test execution summary
total time 120.0108s 120.0123s 120.0082s
total number of events 171033 184665 517869
total time taken by event execution 3838.9952 3839.0571 3834.5203
per-request statistics
min 2.22ms 2.09ms 2.03ms
avg 22.45ms 20.79ms 7.40ms
max 191.84ms 188.69ms 288.58ms
Approx. 95% 46.21ms 44.06ms 27.50ms
Threads fairness
events (avg/stddev) 5344.7812/31.66 5770.7812/29.26 16183.4062/191.28
execution time (avg/stddev) 119.9686/0.00 119.9705/0.00 119.8288/0.02

Comparaison entre les différentes plateformes (vm 16 coeurs)

Benchmark avec 1 threads
Benchmark - 1 thread
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 580174 628124 552020
write 207205 224330 197150
other 82882 89732 78860
total 870261 942186 828030
transactions 41441 ( 345.33/s ) 44866 ( 373.88/s ) 39430 ( 328.58/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 787379 ( 6561.36/s ) 852454 ( 7103.72/s ) 749170 ( 6243.07/s )
Other operations 82882 ( 690.67/s ) 89732 ( 747.76/s ) 78860 ( 657.17/s )
Test execution summary
total time 120.0025s 120.0011s 120.0002s
total number of events 41441 44866 39430
total time taken by event execution 119.7836 119.7492 119.7049
per-request statistics
min 2.27ms 2.22ms 1.84ms
avg 2.89ms 2.67ms 3.04ms
max 90.26ms 72.04ms 100.37ms
Approx. 95% 3.68ms 2.98ms 3.47ms
Threads fairness
events (avg/stddev) 41441.0000/0.00 44866.0000/0.00 39430.0000/0.00
execution time (avg/stddev) 119.7836/0.00 119.7492/0.00 119.7049/0.00
Benchmark avec 8 threads
Benchmark - 8 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 3032820 3662582 4079264
write 1083150 1308065 1456880
other 433260 523226 582752
total 4549230 5493873 6118896
transactions 216630 ( 1805.20/s ) 261613 ( 2180.06/s ) 291376 ( 2428.08/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 4115970 ( 34298.87/s ) 4970647 ( 41421.09/s ) 5536144 ( 46133.55/s )
Other operations 433260 ( 3610.41/s ) 523226 ( 4360.12/s ) 582752 ( 4856.16/s )
Test execution summary
total time 120.0031s 120.0028s 120.0025s
total number of events 216630 261613 291376
total time taken by event execution 958.6631 958.4968 956.9776
per-request statistics
min 2.86ms 2.46ms 1.80ms
avg 4.43ms 3.66ms 3.28ms
max 103.85ms 102.81ms 156.27ms
Approx. 95% 5.37ms 4.45ms 4.12ms
Threads fairness
events (avg/stddev) 27078.7500/204.62 32701.6250/175.06 36422.0000/242.19
execution time (avg/stddev) 119.8329/0.00 119.8121/0.00 119.6222/0.00
Benchmark avec 16 threads
Benchmark - 16 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 3324300 3754058 7514948
write 1187250 1340735 2683910
other 474900 536294 1073564
total 4986450 5631087 11272422
transactions 237450 ( 1978.67/s ) 268147 ( 2234.44/s ) 536782 ( 4473.06/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 4511550 ( 37594.79/s ) 5094793 ( 42454.40/s ) 10198858 ( 84988.18/s )
Other operations 474900 ( 3957.35/s ) 536294 ( 4468.88/s ) 1073564 ( 8946.12/s )
Test execution summary
total time 120.0047s 120.0063s 120.0032s
total number of events 237450 268147 536782
total time taken by event execution 1918.4203 1918.2548 1914.7307
per-request statistics
min 3.64ms 2.66ms 1.95ms
avg 8.08ms 7.15ms 3.57ms
max 117.54ms 117.19ms 451.13ms
Approx. 95% 9.85ms 9.63ms 4.23ms
Threads fairness
events (avg/stddev) 14840.6250/71.63 16759.1875/327.54 33548.8750/165.70
execution time (avg/stddev) 119.9013/0.00 119.8909/0.00 119.6707/0.00
Benchmark avec 24 threads
Benchmark - 24 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2882950 3496836 7315350
write 1029625 1248870 2612625
other 411850 499548 1045050
total 4324425 5245254 10973025
transactions 205925 ( 1715.92/s ) 249774 ( 2081.32/s ) 522525 ( 4353.89/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3912575 ( 32602.51/s ) 4745706 ( 39545.00/s ) 9927975 ( 82724.00/s )
Other operations 411850 ( 3431.84/s ) 499548 ( 4162.63/s ) 1045050 ( 8707.79/s )
Test execution summary
total time 120.0084s 120.0077s 120.0132s
total number of events 205925 249774 522525
total time taken by event execution 2878.4305 2878.2739 2874.5861
per-request statistics
min 2.73ms 2.36ms 2.03ms
avg 13.98ms 11.52ms 5.50ms
max 1984.98ms 302.95ms 562.55ms
Approx. 95% 19.64ms 16.61ms 17.01ms
Threads fairness
events (avg/stddev) 8580.2083/25.88 10407.2500/67.95 21771.8750/286.75
execution time (avg/stddev) 119.9346/0.00 119.9281/0.00 119.7744/0.01
Benchmark avec 32 threads
Benchmark - 32 threads
test4 sur neo-drbd
avec binlog et lecture écriture 		test4 sur neo
avec binlog et lecture écriture 		test4 sur lame
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2458414 3737286 7250166
write 878005 1334745 2589345
other 351202 533898 1035738
total 3687621 5605929 10875249
transactions 175601 ( 1463.09/s ) 266949 ( 2224.30/s ) 517869 ( 4315.28/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3336419 ( 27798.74/s ) 5072031 ( 42261.67/s ) 9839511 ( 81990.34/s )
Other operations 351202 ( 2926.18/s ) 533898 ( 4448.60/s ) 1035738 ( 8630.56/s )
Test execution summary
total time 120.0205s 120.0149s 120.0082s
total number of events 175601 266949 517869
total time taken by event execution 3838.5338 3838.1775 3834.5203
per-request statistics
min 4.60ms 2.43ms 2.03ms
avg 21.86ms 14.38ms 7.40ms
max 150.82ms 163.41ms 288.58ms
Approx. 95% 33.14ms 25.29ms 27.50ms
Threads fairness
events (avg/stddev) 5487.5312/15.42 8342.1562/41.40 16183.4062/191.28
execution time (avg/stddev) 119.9542/0.01 119.9430/0.01 119.8288/0.02

Comparatif 4 et 16 coeurs

Comparatif 4 et 16 coeurs : avec 1 threads
Benchmark - 1 thread
test4 sur neo-drbd 4 coeurs
avec binlog et lecture écriture 		test4 sur neo 4 coeurs
avec binlog et lecture écriture 		test4 sur neo-drbd 16 coeurs
avec binlog et lecture écriture 		test4 sur neo 16 coeurs
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 570178 605822 580174 628124
write 203635 216365 207205 224330
other 81454 86546 82882 89732
total 855267 908733 870261 942186
transactions 40727 ( 339.39/s ) 43273 ( 360.60/s ) 41441 ( 345.33/s ) 44866 ( 373.88/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 773813 ( 6448.36/s ) 822187 ( 6851.44/s ) 787379 ( 6561.36/s ) 852454 ( 7103.72/s )
Other operations 81454 ( 678.77/s ) 86546 ( 721.20/s ) 82882 ( 690.67/s ) 89732 ( 747.76/s )
Test execution summary
total time 120.0015s 120.0020s 120.0025s 120.0011s
total number of events 40727 43273 41441 44866
total time taken by event execution 119.7867 119.7467 119.7836 119.7492
per-request statistics
min 2.34ms 2.13ms 2.27ms 2.22ms
avg 2.94ms 2.77ms 2.89ms 2.67ms
max 83.73ms 70.38ms 90.26ms 72.04ms
Approx. 95% 3.73ms 3.72ms 3.68ms 2.98ms
Threads fairness
events (avg/stddev) 40727.0000/0.00 43273.0000/0.00 41441.0000/0.00 44866.0000/0.00
execution time (avg/stddev) 119.7867/0.00 119.7467/0.00 119.7836/0.00 119.7492/0.00
Comparatif 4 et 16 coeurs : avec 8 threads
Benchmark - 8 threads
test4 sur neo-drbd 4 coeurs
avec binlog et lecture écriture 		test4 sur neo 4 coeurs
avec binlog et lecture écriture 		test4 sur neo-drbd 16 coeurs
avec binlog et lecture écriture 		test4 sur neo 16 coeurs
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2474724 2577792 3032820 3662582
write 883830 920640 1083150 1308065
other 353532 368256 433260 523226
total 3712086 3866688 4549230 5493873
transactions 176766 ( 1473.01/s ) 184128 ( 1534.35/s ) 216630 ( 1805.20/s ) 261613 ( 2180.06/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3358554 ( 27987.21/s ) 3498432 ( 29152.71/s ) 4115970 ( 34298.87/s ) 4970647 ( 41421.09/s )
Other operations 353532 ( 2946.02/s ) 368256 ( 3068.71/s ) 433260 ( 3610.41/s ) 523226 ( 4360.12/s )
Test execution summary
total time 120.0032s 120.0037s 120.0031s 120.0028s
total number of events 176766 184128 216630 261613
total time taken by event execution 959.0188 959.0014 958.6631 958.4968
per-request statistics
min 2.17ms 2.14ms 2.86ms 2.46ms
avg 5.43ms 5.21ms 4.43ms 3.66ms
max 107.41ms 107.45ms 103.85ms 102.81ms
Approx. 95% 6.40ms 5.71ms 5.37ms 4.45ms
Threads fairness
events (avg/stddev) 22095.7500/35.03 23016.0000/42.44 27078.7500/204.62 32701.6250/175.06
execution time (avg/stddev) 119.8773/0.00 119.8752/0.00 119.8329/0.00 119.8121/0.00
Comparatif 4 et 16 coeurs : avec 16 threads
Benchmark - 16 threads
test4 sur neo-drbd 4 coeurs
avec binlog et lecture écriture 		test4 sur neo 4 coeurs
avec binlog et lecture écriture 		test4 sur neo-drbd 16 coeurs
avec binlog et lecture écriture 		test4 sur neo 16 coeurs
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2501310 2584554 3324300 3754058
write 893325 923055 1187250 1340735
other 357330 369222 474900 536294
total 3751965 3876831 4986450 5631087
transactions 178665 ( 1488.79/s ) 184611 ( 1538.35/s ) 237450 ( 1978.67/s ) 268147 ( 2234.44/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3394635 ( 28287.07/s ) 3507609 ( 29228.65/s ) 4511550 ( 37594.79/s ) 5094793 ( 42454.40/s )
Other operations 357330 ( 2977.59/s ) 369222 ( 3076.70/s ) 474900 ( 3957.35/s ) 536294 ( 4468.88/s )
Test execution summary
total time 120.0066s 120.0059s 120.0047s 120.0063s
total number of events 178665 184611 237450 268147
total time taken by event execution 1919.0151 1918.9869 1918.4203 1918.2548
per-request statistics
min 2.15ms 2.10ms 3.64ms 2.66ms
avg 10.74ms 10.39ms 8.08ms 7.15ms
max 138.31ms 136.00ms 117.54ms 117.19ms
Approx. 95% 21.71ms 20.66ms 9.85ms 9.63ms
Threads fairness
events (avg/stddev) 11166.5625/41.88 11538.1875/31.45 14840.6250/71.63 16759.1875/327.54
execution time (avg/stddev) 119.9384/0.00 119.9367/0.00 119.9013/0.00 119.8909/0.00
Comparatif 4 et 16 coeurs : avec 24 threads
Benchmark - 24 threads
test4 sur neo-drbd 4 coeurs
avec binlog et lecture écriture 		test4 sur neo 4 coeurs
avec binlog et lecture écriture 		test4 sur neo-drbd 16 coeurs
avec binlog et lecture écriture 		test4 sur neo 16 coeurs
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2445100 2592156 2882950 3496836
write 873250 925770 1029625 1248870
other 349300 370308 411850 499548
total 3667650 3888234 4324425 5245254
transactions 174650 ( 1455.33/s ) 185154 ( 1542.86/s ) 205925 ( 1715.92/s ) 249774 ( 2081.32/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3318350 ( 27651.25/s ) 3517926 ( 29314.36/s ) 3912575 ( 32602.51/s ) 4745706 ( 39545.00/s )
Other operations 349300 ( 2910.66/s ) 370308 ( 3085.72/s ) 411850 ( 3431.84/s ) 499548 ( 4162.63/s )
Test execution summary
total time 120.0072s 120.0069s 120.0084s 120.0077s
total number of events 174650 185154 205925 249774
total time taken by event execution 2879.0070 2878.9925 2878.4305 2878.2739
per-request statistics
min 2.19ms 2.08ms 2.73ms 2.36ms
avg 16.48ms 15.55ms 13.98ms 11.52ms
max 148.46ms 141.42ms 1984.98ms 302.95ms
Approx. 95% 34.86ms 32.57ms 19.64ms 16.61ms
Threads fairness
events (avg/stddev) 7277.0833/37.14 7714.7500/30.11 8580.2083/25.88 10407.2500/67.95
execution time (avg/stddev) 119.9586/0.00 119.9580/0.00 119.9346/0.00 119.9281/0.00
Comparatif 4 et 16 coeurs : avec 32 threads
Benchmark - 32 threads
test4 sur neo-drbd 4 coeurs
avec binlog et lecture écriture 		test4 sur neo 4 coeurs
avec binlog et lecture écriture 		test4 sur neo-drbd 16 coeurs
avec binlog et lecture écriture 		test4 sur neo 16 coeurs
avec binlog et lecture écriture
OLTP test statistics
Queries performed
read 2394462 2585310 2458414 3737286
write 855165 923325 878005 1334745
other 342066 369330 351202 533898
total 3591693 3877965 3687621 5605929
transactions 171033 ( 1425.15/s ) 184665 ( 1538.72/s ) 175601 ( 1463.09/s ) 266949 ( 2224.30/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 3249627 ( 27077.79/s ) 3508635 ( 29235.63/s ) 3336419 ( 27798.74/s ) 5072031 ( 42261.67/s )
Other operations 342066 ( 2850.29/s ) 369330 ( 3077.43/s ) 351202 ( 2926.18/s ) 533898 ( 4448.60/s )
Test execution summary
total time 120.0108s 120.0123s 120.0205s 120.0149s
total number of events 171033 184665 175601 266949
total time taken by event execution 3838.9952 3839.0571 3838.5338 3838.1775
per-request statistics
min 2.22ms 2.09ms 4.60ms 2.43ms
avg 22.45ms 20.79ms 21.86ms 14.38ms
max 191.84ms 188.69ms 150.82ms 163.41ms
Approx. 95% 46.21ms 44.06ms 33.14ms 25.29ms
Threads fairness
events (avg/stddev) 5344.7812/31.66 5770.7812/29.26 5487.5312/15.42 8342.1562/41.40
execution time (avg/stddev) 119.9686/0.00 119.9705/0.00 119.9542/0.01 119.9430/0.01

Importance du paramètre innodb_thread_concurrency

Comparatif avec et sans innodb_thread_concurrency : avec 16 coeurs : avec 1 threads
Benchmark - 1 thread
test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=0 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=8 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=16
OLTP test statistics
Queries performed
read 122570 122836 580174
write 43775 43870 207205
other 17510 17548 82882
total 183855 184254 870261
transactions 8755 ( 72.96/s ) 8774 ( 73.11/s ) 41441 ( 345.33/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 166345 ( 1386.16/s ) 166706 ( 1389.11/s ) 787379 ( 6561.36/s )
Other operations 17510 ( 145.91/s ) 17548 ( 146.22/s ) 82882 ( 690.67/s )
Test execution summary
total time 120.0044s 120.0090s 120.0025s
total number of events 8755 8774 41441
total time taken by event execution 119.9291 119.9347 119.7836
per-request statistics
min 9.95ms 5.79ms 2.27ms
avg 13.70ms 13.67ms 2.89ms
max 109.11ms 105.31ms 90.26ms
Approx. 95% 15.01ms 14.99ms 3.68ms
Threads fairness
events (avg/stddev) 8755.0000/0.00 8774.0000/0.00 41441.0000/0.00
execution time (avg/stddev) 119.9291/0.00 119.9347/0.00 119.7836/0.00
Comparatif avec et sans innodb_thread_concurrency : avec 16 coeurs : avec 8 threads
Benchmark - 1 thread
test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=0 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=8 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=16
OLTP test statistics
Queries performed
read 182294 181636 3032820
write 65105 64870 1083150
other 26042 25948 433260
total 273441 272454 4549230
transactions 13021 ( 108.45/s ) 12974 ( 108.05/s ) 216630 ( 1805.20/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 247399 ( 2060.46/s ) 246506 ( 2053.02/s ) 4115970 ( 34298.87/s )
Other operations 26042 ( 216.89/s ) 25948 ( 216.11/s ) 433260 ( 3610.41/s )
Test execution summary
total time 120.0700s 120.0698s 120.0031s
total number of events 13021 12974 216630
total time taken by event execution 960.1908 960.1830 958.6631
per-request statistics
min 14.91ms 13.99ms 2.86ms
avg 73.74ms 74.01ms 4.43ms
max 220.50ms 204.61ms 103.85ms
Approx. 95% 82.94ms 83.07ms 5.37ms
Threads fairness
events (avg/stddev) 1627.6250/4.53 1621.7500/3.93 27078.7500/204.62
execution time (avg/stddev) 120.0239/0.02 120.0229/0.02 119.8329/0.00
Comparatif avec et sans innodb_thread_concurrency : avec 16 coeurs : avec 16 threads
Benchmark - 1 thread
test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=0 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=8 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=16
OLTP test statistics
Queries performed
read 182294 182294 3324300
write 65105 65105 1187250
other 26042 26042 474900
total 273441 273441 4986450
transactions 13021 ( 108.38/s ) 13021 ( 108.38/s ) 237450 ( 1978.67/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 247399 ( 2059.24/s ) 247399 ( 2059.25/s ) 4511550 ( 37594.79/s )
Other operations 26042 ( 216.76/s ) 26042 ( 216.76/s ) 474900 ( 3957.35/s )
Test execution summary
total time 120.1411s 120.1403s 120.0047s
total number of events 13021 13021 237450
total time taken by event execution 1921.0365 1921.0108 1918.4203
per-request statistics
min 11.76ms 15.04ms 3.64ms
avg 147.53ms 147.53ms 8.08ms
max 368.45ms 339.62ms 117.54ms
Approx. 95% 157.91ms 158.00ms 9.85ms
Threads fairness
events (avg/stddev) 813.8125/2.35 813.8125/2.16 14840.6250/71.63
execution time (avg/stddev) 120.0648/0.04 120.0632/0.04 119.9013/0.00
Comparatif avec et sans innodb_thread_concurrency : avec 16 coeurs : avec 24 threads
Benchmark - 1 thread
test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=0 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=8 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=16
OLTP test statistics
Queries performed
read 183638 183806 2882950
write 65585 65645 1029625
other 26234 26258 411850
total 275457 275709 4324425
transactions 13117 ( 109.12/s ) 13129 ( 109.22/s ) 205925 ( 1715.92/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 249223 ( 2073.22/s ) 249451 ( 2075.09/s ) 3912575 ( 32602.51/s )
Other operations 26234 ( 218.23/s ) 26258 ( 218.43/s ) 411850 ( 3431.84/s )
Test execution summary
total time 120.2108s 120.2123s 120.0084s
total number of events 13117 13129 205925
total time taken by event execution 2882.3766 2882.3590 2878.4305
per-request statistics
min 12.87ms 12.83ms 2.73ms
avg 219.74ms 219.54ms 13.98ms
max 554.02ms 543.23ms 1984.98ms
Approx. 95% 231.29ms 230.05ms 19.64ms
Threads fairness
events (avg/stddev) 546.5417/1.91 547.0417/1.62 8580.2083/25.88
execution time (avg/stddev) 120.0990/0.06 120.0983/0.06 119.9346/0.00
Comparatif avec et sans innodb_thread_concurrency : avec 16 coeurs : avec 32 threads
Benchmark - 1 thread
test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=0 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=8 		test4 sur neo-drbd
avec binlog et lecture écriture
innodb_thread_concurrency=16
OLTP test statistics
Queries performed
read 182560 182406 2458414
write 65200 65145 878005
other 26080 26058 351202
total 273840 273609 3687621
transactions 13040 ( 108.41/s ) 13029 ( 108.32/s ) 175601 ( 1463.09/s )
deadlocks 0 ( 0.00/s ) 0 ( 0.00/s ) 0 ( 0.00/s )
R/w requests 247760 ( 2059.78/s ) 247551 ( 2058.16/s ) 3336419 ( 27798.74/s )
Other operations 26080 ( 216.82/s ) 26058 ( 216.65/s ) 351202 ( 2926.18/s )
Test execution summary
total time 120.2847s 120.2779s 120.0205s
total number of events 13040 13029 175601
total time taken by event execution 3844.4770 3844.2389 3838.5338
per-request statistics
min 12.85ms 15.07ms 4.60ms
avg 294.82ms 295.05ms 21.86ms
max 607.42ms 862.65ms 150.82ms
Approx. 95% 307.83ms 308.93ms 33.14ms
Threads fairness
events (avg/stddev) 407.5000/1.32 407.1562/1.20 5487.5312/15.42
execution time (avg/stddev) 120.1399/0.08 120.1325/0.08 119.9542/0.01
Récupérée de « https://wikiold.home.tartarefr.eu/index.php?title=DBMS/MySQL/DRBD&oldid=1359 »