[MDEV-12924] No --innodb-numa-interleave in mysqld binaries Created: 2017-05-26 Updated: 2020-08-25 Resolved: 2018-04-19 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Affects Version/s: | 10.1.23 |
| Fix Version/s: | 10.3.7 |
| Type: | Bug | Priority: | Major |
| Reporter: | Hartmut Holzgraefe | Assignee: | Sachin Setiya (Inactive) |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | None | ||
| Sprint: | 10.2.10, 10.3.3-1, 10.2.13 |
| Description |
|
I tried the MariaDB 10.1.23 community binary tarball, and MariaDB Enterprise 10.1.23 Ubuntu packages, and in both cases the mysqld binary didn't have the --innodb-numa-interleave option. As the documentation says that the option is only available if the binaries were build on a NUMA machine I assume that the build machines used for these were plain non-NUMA boxes (or VMs?) |
| Comments |
| Comment by Sergei Golubchik [ 2017-05-26 ] | |||||||
|
The reason is — configure.cmake doesn't have the code to detect libnuma. The fix should consist of:
Note, new dependency means that we cannot do it in 10.0 or 10.1, and even in 10.2 it's barely possible. Also, the question is — should we really impose this new dependency unconditionally on all users? In 10.0 and 10.1 we can do 1. and 3. and force numa to be disabled in release builds. That is, no new dependency, but numa can be enabled in custom builds. | |||||||
| Comment by Daniel Black [ 2017-05-29 ] | |||||||
|
10.0/10.1 appears broken in the same way as below - no call to MYSQL_CHECK_NUMA() 10.2 specific break: Broken in 3a3b3d8ba8d8f32feb7cf6c2609639635ddb53b5 debian/control has numa-dev (broken) and ${shlibs:Depends} will pick up on this. Adding this dependency - its a 40-68k shared library depending on architecture and we've got other small compression libraries that aren't always used. part 1. https://github.com/MariaDB/server/pull/399 (thanks jplindst for the merge in 10.2) | |||||||
| Comment by Valerii Kravchuk [ 2017-05-31 ] | |||||||
|
Same problem with RHEL7 RPMs. | |||||||
| Comment by Vesa Pentti (Inactive) [ 2017-10-15 ] | |||||||
|
Ok now I realize it does work in 10.2 and 10.3 just fine already. As long as the builder has numa library installed (libnuma-dev, libnuma-devel ...) That's one thing, to ensure builders have the library. | |||||||
| Comment by Vesa Pentti (Inactive) [ 2017-10-15 ] | |||||||
|
Question: is it okay to have 10.0 and 10.1 as-is? | |||||||
| Comment by Vesa Pentti (Inactive) [ 2017-10-15 ] | |||||||
|
Having the numa library optional, looks like a deliberate choice originally, so the dependency is not enforced. Feels somehow natural. I wonder if it should be enforced or not. For enforcing, there could be something like:
| |||||||
| Comment by Sergei Golubchik [ 2017-10-16 ] | |||||||
|
Yes, it should be optional. But if you can introduce WITH_NUMA option with possible values YES/NO/AUTO (the default being AUTO) — we have a bunch of these YES/NO/AUTO options, so WITH_NUMA behavior will be quite consistent with existing options. When it's AUTO, it'll behave as now, with YES it'll abort when libnuma isn't found with NO it won't link with libnuma. | |||||||
| Comment by Vesa Pentti (Inactive) [ 2017-10-31 ] | |||||||
|
commit: 2fe025c45a47054d42703970d8d608642a535357 | |||||||
| Comment by Sachin Setiya (Inactive) [ 2018-04-16 ] | |||||||
|
Hi serg , I have tested the pentve patch it works accordingly. | |||||||
| Comment by Sergei Golubchik [ 2018-04-17 ] | |||||||
|
1. Did you test it with -DWITH_NUMA=OFF ? I'm not sure that
works for a string variable having the value of "OFF" (as a string). otherwise looks ok | |||||||
| Comment by Sachin Setiya (Inactive) [ 2018-04-17 ] | |||||||
|
I have tested with -DWITH_NUMA=OFF , it works 2. I think you are right , Invalid value is treated as on | |||||||
| Comment by Sachin Setiya (Inactive) [ 2018-04-17 ] | |||||||
|
http://lists.askmonty.org/pipermail/commits/2018-April/012410.html | |||||||
| Comment by Sergei Golubchik [ 2018-04-17 ] | |||||||
|
Looks ok, thanks. But please, fix the commit comment before pushing |