On the controller nodes the key_buffer_size parameter has wrong value in the [mysqld] section: # cat /etc/mysql/my.cnf ... [mysqld] ... key_buffer_size = 64 ...
# find /etc/ -type f -exec grep -nH "key_buffer_size" {} \; /etc/mysql/my.cnf:8:key_buffer_size = 16M /etc/mysql/my.cnf:33:key_buffer_size = 64 /etc/puppet/modules/mysql/CHANGELOG.md:239:- key_buffer renamed to key_buffer_size. /etc/puppet/modules/mysql/manifests/params.pp:375: 'key_buffer_size' => '16M', /etc/puppet/modules/mysql/manifests/params.pp:403: 'key_buffer_size' => '16M', /etc/puppet/modules/osnailyfacter/manifests/database/database.pp:130: $key_buffer_size = 64 /etc/puppet/modules/osnailyfacter/manifests/database/database.pp:134: "<%= [[((${::memorysize_mb} * 0.3 - ${key_buffer_size}) / /etc/puppet/modules/osnailyfacter/manifests/database/database.pp:180: 'key_buffer_size' => $key_buffer_size,
Expected results: key_buffer_size=64M
Actual result: key_buffer_size=64
Impact: performance issues (?)
Description of the environment: MOS 9.1
On the controller nodes the key_buffer_size parameter has wrong value in the [mysqld] section:
# cat /etc/mysql/my.cnf
...
[mysqld]
...
key_buffer_size = 64
...
# find /etc/ -type f -exec grep -nH "key_buffer_size" {} \; my.cnf: 8:key_buffer_ size = 16M my.cnf: 33:key_ buffer_ size = 64 modules/ mysql/CHANGELOG .md:239: - key_buffer renamed to key_buffer_size. modules/ mysql/manifests /params. pp:375: 'key_buffer_size' => '16M', modules/ mysql/manifests /params. pp:403: 'key_buffer_size' => '16M', modules/ osnailyfacter/ manifests/ database/ database. pp:130: $key_buffer_size = 64 modules/ osnailyfacter/ manifests/ database/ database. pp:134: "<%= [[((${: :memorysize_ mb} * 0.3 - ${key_buffer_size}) / modules/ osnailyfacter/ manifests/ database/ database. pp:180: 'key_buffer_size' => $key_buffer_size,
/etc/mysql/
/etc/mysql/
/etc/puppet/
/etc/puppet/
/etc/puppet/
/etc/puppet/
/etc/puppet/
/etc/puppet/
Expected results: size=64M
key_buffer_
Actual result:
key_buffer_size=64
Impact:
performance issues (?)
Description of the environment:
MOS 9.1