Plugin Pipeline Performance Results
April 27, 2023 ยท View on GitHub
Benchmarks
| Benchmark | Score | Error | Units |
|---|---|---|---|
| MySQL Connector/J | 858.705 | 142.615 | ms/op |
| JDBC Wrapper with MySQL with No Plugins | 853.966 | 45.878 | ms/op |
| JDBC Wrapper with MySQL with EFM | 913.390 | 101.253 | ms/op |
| JDBC Wrapper with MySQL with Failover Connection Plugin | 846.115 | 88.429 | ms/op |
| JDBC Wrapper with MySQL with EFM and Failover Connection Plugins | 911.715 | 57.303 | ms/op |
| Benchmark | Score | Error | Units |
|---|---|---|---|
| pgJDBC | 634.043 | 44.318 | ms/op |
| JDBC Wrapper with pgJDBC with No Plugins | 633.108 | 34.338 | ms/op |
| JDBC Wrapper with pgJDBC with EFM | 713.359 | 69.774 | ms/op |
| JDBC Wrapper with pgJDBC with Failover Connection Plugin | 636.123 | 50.273 | ms/op |
| JDBC Wrapper with pgJDBC with EFM and Failover Connection Plugins | 710.346 | 86.632 | ms/op |
| Benchmark | Score | Error | Units |
|---|---|---|---|
| connectWithNoPlugins | 86.697 | 14.275 | us/op |
| connectWithTenGenericPlugins | 133.620 | 36.312 | us/op |
| executeWithNoPlugins | 256.443 | 35.168 | us/op |
| executeTenGenericPlugins | 318.443 | 53.184 | us/op |
| initConnectionPluginManagerWithNoPlugins | 3.460 | 1.483 | us/op |
| initConnectionPluginManagerTenGenericPlugins | 10.553 | 4.089 | us/op |
| initHostProvidersWithNoPlugins | 7.783 | 2.568 | us/op |
| initHostProvidersTenGenericPlugins | 24.627 | 14.669 | us/op |
| notifyConnectionChangedWithNoPlugins | 8.430 | 2.016 | us/op |
| notifyConnectionChangedTenGenericPlugins | 20.343 | 4.517 | us/op |
| releaseResourcesWithNoPlugins | 3.833 | 1.058 | us/op |
| releaseResourcesTenGenericPlugins | 7.460 | 2.046 | us/op |
| Benchmark | Score | Error | Units |
|---|---|---|---|
| executeStatementBaseline | 682.607 | 133.777 | us/op |
| executeStatementWithExecutionTimePlugin | 741.764 | 165.556 | us/op |
| initAndReleaseBaseLine | 0.440 | 0.123 | us/op |
| initAndReleaseWithAuroraHostListAndReadWriteSplittingPlugin | 402.027 | 60.012 | us/op |
| initAndReleaseWithAuroraHostListAndReadWriteSplittingPluginWithInternalConnectionPools | 445.430 | 144.121 | us/op |
| initAndReleaseWithAuroraHostListPlugin | 406.563 | 73.480 | us/op |
| initAndReleaseWithExecutionTimeAndAuroraHostListPlugins | 412.493 | 71.445 | us/op |
| initAndReleaseWithExecutionTimePlugin | 457.957 | 75.872 | us/op |
| initAndReleaseWithReadWriteSplittingPlugin | 525.933 | 129.156 | us/op |
| initAndReleaseWithReadWriteSplittingPluginWithInternalConnectionPools | 485.773 | 101.451 | us/op |
Performance Tests
Failover Performance with 30 Seconds Socket Timeout Configuration
| SocketTimeout | NetworkOutageDelayMillis | MinFailureDetectionTimeMillis | MaxFailureDetectionTimeMillis | AvgFailureDetectionTimeMillis |
|---|---|---|---|---|
| 30 | 5000 | 25181 | 25302 | 25244 |
| 30 | 10000 | 20164 | 20279 | 20191 |
| 30 | 15000 | 15176 | 15186 | 15180 |
| 30 | 20000 | 10173 | 10213 | 10190 |
| 30 | 25000 | 5176 | 5192 | 5184 |
| 30 | 30000 | 166 | 189 | 176 |
Enhanced Failure Monitoring Performance with Different Failure Detection Configuration
| FailureDetectionGraceTime | FailureDetectionInterval | FailureDetectionCount | NetworkOutageDelayMillis | MinFailureDetectionTimeMillis | MaxFailureDetectionTimeMillis | AvgFailureDetectionTimeMillis |
|---|---|---|---|---|---|---|
| 30000 | 5000 | 3 | 5000 | 41109 | 41114 | 41111 |
| 30000 | 5000 | 3 | 10000 | 36108 | 36112 | 36110 |
| 30000 | 5000 | 3 | 15000 | 31109 | 31111 | 31110 |
| 30000 | 5000 | 3 | 20000 | 26108 | 26111 | 26109 |
| 30000 | 5000 | 3 | 25000 | 21107 | 21110 | 21109 |
| 30000 | 5000 | 3 | 30000 | 16108 | 16111 | 16109 |
| 30000 | 5000 | 3 | 35000 | 16109 | 16111 | 16110 |
| 30000 | 5000 | 3 | 40000 | 16110 | 16114 | 16112 |
| 30000 | 5000 | 3 | 50000 | 16109 | 16114 | 16112 |
| 30000 | 5000 | 3 | 60000 | 16115 | 16119 | 16117 |
| 6000 | 1000 | 1 | 1000 | 5106 | 5110 | 5108 |
| 6000 | 1000 | 1 | 2000 | 4108 | 4111 | 4109 |
| 6000 | 1000 | 1 | 3000 | 3107 | 3109 | 3108 |
| 6000 | 1000 | 1 | 4000 | 2106 | 2111 | 2107 |
| 6000 | 1000 | 1 | 5000 | 1105 | 1107 | 1106 |
| 6000 | 1000 | 1 | 6000 | 1101 | 1107 | 1105 |
| 6000 | 1000 | 1 | 7000 | 1105 | 1112 | 1107 |
| 6000 | 1000 | 1 | 8000 | 1107 | 1109 | 1108 |
| 6000 | 1000 | 1 | 9000 | 1106 | 1111 | 1109 |
| 6000 | 1000 | 1 | 10000 | 1109 | 1114 | 1111 |
Failover Performance with Different Enhanced Failure Monitoring Configuration
| FailureDetectionGraceTime | FailureDetectionInterval | FailureDetectionCount | NetworkOutageDelayMillis | MinFailureDetectionTimeMillis | MaxFailureDetectionTimeMillis | AvgFailureDetectionTimeMillis |
|---|---|---|---|---|---|---|
| 30000 | 5000 | 3 | 5000 | 41280 | 41315 | 41292 |
| 30000 | 5000 | 3 | 10000 | 36269 | 36283 | 36277 |
| 30000 | 5000 | 3 | 15000 | 31200 | 31292 | 31261 |
| 30000 | 5000 | 3 | 20000 | 26264 | 26288 | 26276 |
| 30000 | 5000 | 3 | 25000 | 21273 | 21311 | 21288 |
| 30000 | 5000 | 3 | 30000 | 16267 | 16316 | 16284 |
| 30000 | 5000 | 3 | 35000 | 16273 | 16284 | 16279 |
| 30000 | 5000 | 3 | 40000 | 16265 | 16287 | 16277 |
| 30000 | 5000 | 3 | 50000 | 16275 | 16312 | 16284 |
| 30000 | 5000 | 3 | 60000 | 16272 | 16293 | 16282 |
| 6000 | 1000 | 1 | 1000 | 5261 | 5301 | 5276 |
| 6000 | 1000 | 1 | 2000 | 4259 | 4275 | 4267 |
| 6000 | 1000 | 1 | 3000 | 3263 | 3280 | 3271 |
| 6000 | 1000 | 1 | 4000 | 2256 | 2282 | 2266 |
| 6000 | 1000 | 1 | 5000 | 1256 | 1275 | 1263 |
| 6000 | 1000 | 1 | 6000 | 1168 | 1273 | 1248 |
| 6000 | 1000 | 1 | 7000 | 1259 | 1277 | 1267 |
| 6000 | 1000 | 1 | 8000 | 1263 | 1289 | 1272 |
| 6000 | 1000 | 1 | 9000 | 1264 | 1281 | 1270 |
| 6000 | 1000 | 1 | 10000 | 1265 | 1287 | 1277 |