Comment 0 for bug 1648766

Revision history for this message
Dmitry Goloshubov (dgoloshubov) wrote :

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