Public bug reported:
In order to use the InnoDB option 'innodb_numa_interleave'
(https://dev.mysql.com/doc/refman/5.7/en/innodb-
parameters.html#sysvar_innodb_numa_interleave) it is required the server
to be built with the cmake flag -DWITH_NUMA=ON. The default Ubuntu
package does not have this flag set.
root@ubuntu-xenial:~# dpkg -l | grep mysql
ii mysql-client-5.7 5.7.20-0ubuntu0.16.04.1
amd64 MySQL database client binaries
ii mysql-client-core-5.7 5.7.20-0ubuntu0.16.04.1
amd64 MySQL database core client binaries
ii mysql-common 5.7.20-0ubuntu0.16.04.1
all MySQL database common files, e.g. /etc/mysql/my.cnf
ii mysql-server-5.7 5.7.20-0ubuntu0.16.04.1
amd64 MySQL database server binaries and system database setup
ii mysql-server-core-5.7 5.7.20-0ubuntu0.16.04.1
amd64 MySQL database server binaries
root@ubuntu-xenial:~# echo 'innodb_numa_interleave = ON' >>
/etc/mysql/mysql.conf.d/mysqld.cnf
root@ubuntu-xenial:~# service mysql restart
root@ubuntu-xenial:~# cat /var/log/mysql/error.log
...
2017-11-30T14:02:13.260454Z 0 [Note] InnoDB: Initializing buffer pool, total
size = 128M, instances = 1, chunk size = 128M
2017-11-30T14:02:13.260470Z 0 [Note] InnoDB: Setting NUMA memory policy to
MPOL_INTERLEAVE
2017-11-30T14:02:13.260476Z 0 [Warning] InnoDB: Failed to set NUMA memory
policy to MPOL_INTERLEAVE: Invalid argument
2017-11-30T14:02:13.260489Z 0 [Warning] InnoDB: Failed to set NUMA memory
policy of buffer pool page frames to MPOL_INTERLEAVE (error: Invalid argument).
2017-11-30T14:02:13.265371Z 0 [Note] InnoDB: Setting NUMA memory policy to
MPOL_DEFAULT
2017-11-30T14:02:13.265388Z 0 [Note] InnoDB: Completed initialization of buffer
pool
...
root@ubuntu-xenial:~#
** Affects: mysql-5.7 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1735424
Title:
package mysql-server is compiled without cmake flag -DWITH_NUMA=ON
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1735424/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
