Tweak Hikari maximumPoolSize in direction of optimal performance
There are two formulas for the Hikari maximumPoolsize given at About-Pool-Sizing. Optimal throughput is calculated as:
pool_size = (core_count * 2) + effective_spindle_count
In our case that would result in (8 * 2) + 4 something close to 20 connections. The other formula calculates the minimum pool size to avoid a deadlock:
pool_size = MaximumThreads * (max_connections_held_by_single_thread - 1) + 1
In our case that looks like this with numbers 200 * ( 3 - 1 ) +1. That would be far from optimal throughput with a connection pool of 401. Im looking for arguments to close this gap. I did not find anything yet, but maybe there is a way to calculate in, the average transaction time, or statistics how many threads need more than one connection to the database to push the connection pool into the direction of the optimal throughput. Any hints are appreciated.
database database-connection hikaricp
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
add a comment |
There are two formulas for the Hikari maximumPoolsize given at About-Pool-Sizing. Optimal throughput is calculated as:
pool_size = (core_count * 2) + effective_spindle_count
In our case that would result in (8 * 2) + 4 something close to 20 connections. The other formula calculates the minimum pool size to avoid a deadlock:
pool_size = MaximumThreads * (max_connections_held_by_single_thread - 1) + 1
In our case that looks like this with numbers 200 * ( 3 - 1 ) +1. That would be far from optimal throughput with a connection pool of 401. Im looking for arguments to close this gap. I did not find anything yet, but maybe there is a way to calculate in, the average transaction time, or statistics how many threads need more than one connection to the database to push the connection pool into the direction of the optimal throughput. Any hints are appreciated.
database database-connection hikaricp
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
add a comment |
There are two formulas for the Hikari maximumPoolsize given at About-Pool-Sizing. Optimal throughput is calculated as:
pool_size = (core_count * 2) + effective_spindle_count
In our case that would result in (8 * 2) + 4 something close to 20 connections. The other formula calculates the minimum pool size to avoid a deadlock:
pool_size = MaximumThreads * (max_connections_held_by_single_thread - 1) + 1
In our case that looks like this with numbers 200 * ( 3 - 1 ) +1. That would be far from optimal throughput with a connection pool of 401. Im looking for arguments to close this gap. I did not find anything yet, but maybe there is a way to calculate in, the average transaction time, or statistics how many threads need more than one connection to the database to push the connection pool into the direction of the optimal throughput. Any hints are appreciated.
database database-connection hikaricp
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
There are two formulas for the Hikari maximumPoolsize given at About-Pool-Sizing. Optimal throughput is calculated as:
pool_size = (core_count * 2) + effective_spindle_count
In our case that would result in (8 * 2) + 4 something close to 20 connections. The other formula calculates the minimum pool size to avoid a deadlock:
pool_size = MaximumThreads * (max_connections_held_by_single_thread - 1) + 1
In our case that looks like this with numbers 200 * ( 3 - 1 ) +1. That would be far from optimal throughput with a connection pool of 401. Im looking for arguments to close this gap. I did not find anything yet, but maybe there is a way to calculate in, the average transaction time, or statistics how many threads need more than one connection to the database to push the connection pool into the direction of the optimal throughput. Any hints are appreciated.
database database-connection hikaricp
database database-connection hikaricp
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
asked Nov 13 '18 at 15:24
FrankensteinFrankenstein
13111
13111
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53284228%2ftweak-hikari-maximumpoolsize-in-direction-of-optimal-performance%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53284228%2ftweak-hikari-maximumpoolsize-in-direction-of-optimal-performance%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
