percona-xtradb-cluster-operator icon indicating copy to clipboard operation
percona-xtradb-cluster-operator copied to clipboard

K8SPXC-1028: Fix buffer pool autotuning

Open egegunes opened this issue 2 years ago • 3 comments

K8SPXC-1028 Powered by Pull Request Badge

Our autotuning params didn't match with values take effect in database. We need to be sure:

  1. innodb_buffer_pool_size needs to be multiple of innodb_buffer_chunk_size (default 128M).
  2. If innodb_buffer_pool_size > 1G, we need to set chunk size to be multiple of its minimum value (10M).

egegunes avatar May 24 '22 08:05 egegunes

@hors do we plan include it to the release?

nmarukovich avatar May 24 '22 10:05 nmarukovich

@hors do we plan include it to the release?

@nmarukovich no

hors avatar May 24 '22 11:05 hors

Test name Status
affinity-8-0 passed
auto-tuning-8-0 passed
cross-site-8-0 passed
demand-backup-8-0 passed
demand-backup-cloud-8-0 passed
demand-backup-encrypted-with-tls-8-0 passed
haproxy-5-7 passed
haproxy-8-0 passed
init-deploy-5-7 passed
init-deploy-8-0 passed
limits-8-0 passed
monitoring-2-0-8-0 passed
one-pod-5-7 passed
one-pod-8-0 passed
pitr-8-0 passed
proxy-protocol-8-0 passed
proxysql-sidecar-res-limits-8-0 passed
recreate-8-0 passed
restore-to-encrypted-cluster-8-0 passed
scaling-8-0 passed
scaling-proxysql-8-0 passed
scheduled-backup-5-7 passed
scheduled-backup-8-0 passed
security-context-8-0 passed
smart-update1-8-0 passed
smart-update2-8-0 passed
storage-8-0 passed
tls-issue-cert-manager-8-0 passed
tls-issue-cert-manager-ref-8-0 passed
tls-issue-self-8-0 passed
upgrade-consistency-8-0 passed
upgrade-haproxy-8-0 passed
upgrade-proxysql-8-0 passed
users-5-7 passed
users-8-0 passed
validation-hook-8-0 passed
We run 36 out of 36

commit: https://github.com/percona/percona-xtradb-cluster-operator/pull/1166/commits/1a176ec10e664aab61844bd637e036d18d7e46f9 image: perconalab/percona-xtradb-cluster-operator:PR-1166-1a176ec1

JNKPercona avatar Oct 28 '22 14:10 JNKPercona