[Linuxppc-users] MariaDB tuning parameters / Best practises?

[Daniel Black]

On Thu, 24 Jan 2019 07:23:56 +0000
"Iranna D Ankad" <iranna.ankad at in.ibm.com> wrote:

> Did you already check this?
> 
> https://www-356.ibm.com/partnerworld/wps/servlet/ContentHandler/stg_ast_sys_wp_ibm-power-systems-solution-mariadb

This is a pretty good start on configuration

> 
> Would anyone have good link /instructions regarding mariadb running
> on Linux on Power (RHEL 7.6 LE) ?


Later stable version are available in RPM from:

https://downloads.mariadb.org/mariadb/repositories/#distro=RedHat&distro_release=rhel7-ppc64le--rhel7&version=10.3

Documentation above still applies regarding tuning. Applies equally to
POWER9 though SMT options are different. Some options may have been
removed from 10.0.14 in innodb especially.

This should always be a starting point in tuning. After you have a
running workload, look at the `SHOW GLOBAL STATUS` and see that
you have a good use of resources and no hot locations.

Any competent MariaDB / MySQL tuning guide will apply equally to POWER,
just keep in mind how many extra CPUs you have in the context of what
is written. Just because you have significant amount of memory isn't
always a good idea to raise all of the memory settings, though
innodb_buffer_pool_size to high values (available memory amounts) is
safe.

--
Daniel Black
Power Architecture Performance Engineer (MySQL/MariaDB)
IBM Systems